function _setValues($pid) { $log = new LogDatabaseQueryArticleMonthYear(LOGDEF); $log->SetPid($pid); if (!($result = $log->executeQuery())) { echo "Error: " . $log->getMySQLError(); $log->destroy(); exit; } $date = $log->getInitDate(); if ($date) { $iniYear = substr($date, 0, 4); } $date = $log->getLastDate(); if ($date) { $finYear = substr($date, 0, 4); } $count = 0; for ($year = $iniYear; $year <= $finYear; $year++) { $this->_legend[$count] = $year; $this->_data[$count++] = array(0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0); } for ($i = 0; $i < mysql_num_rows($result); $i++) { $row = mysql_fetch_array($result); $index = $row["year"] - $iniYear; $imonth = $row["month"] - 1; $this->_data[$index][$imonth] += $row["total"]; } $log->destroy(); }
<?php include_once "classLogDatabaseQueryArticleMonthYear.php"; define("LOGDEF", "../scielo.def"); define("MYSQL_SUCCESS", 0); /***************************************************************************************************/ /**************************************** MAIN CODE ******************************************/ /***************************************************************************************************/ $log = new LogDatabaseQueryArticleMonthYear(LOGDEF); if (isset($pid)) { $log->SetPid($pid); } if (isset($debug)) { $log->SetDebug($debug); } if (isset($script)) { $log->SetScriptName("sci_artmonthyearstat"); } if (isset($lng)) { $log->SetInterfaceLanguage($lng); } if (isset($nrm)) { $log->SetStandard($nrm); } $response = $log->getResultXML(); $log->destroy(); echo $response;