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;
