function create_usage_graph($from_date, $end_date) { //create an instance of class database here $con = new database(); //set up query string $query_members = "SELECT * FROM people_online WHERE people_online.member = 'y' \r\n\t\t\t\t\t AND people_online.log_date BETWEEN '{$from_date}' AND '{$end_date}'"; $query_visitors = "SELECT * FROM people_online WHERE people_online.member = 'n' \r\n\t\t\t\t\t AND people_online.log_date BETWEEN '{$from_date}' AND '{$end_date}'"; $rs_members = $con->query($query_members) or die($con->error()); $rs_visitors = $con->query($query_visitors) or die($con->error()); // COMMENT : must use OOP style ( use the $con object uve created ) not a procedural one...-mh $data_member = mysql_fetch_assoc($rs_members); // this is wrong... $data_visitors = mysql_fetch_assoc($rs_visitors); $data_member = $con->getnumrows($rs_members); $data_visitors = $con->getnumrows($rs_visitors); $data = $data_member + $data_visitors; if ($data == 0) { echo '<script>alert("Sorry, no usage results found.");window.close();</script>'; exit; } //echo 'm='.$data_member; //echo 'v='.$data_visitors; $arr_label = array("Members", "Visitors"); //$arr_data = array($data_member['MEMBERS'], $data_visitors['VISITORS']); $arr_data = array($data_member, $data_visitors); //start displaying the graph $from_date = explode('-', $from_date); $from_date = strdate($from_date[1], '', '') . ' ' . $from_date[2] . ',' . $from_date[0]; $end_date = explode('-', $end_date); $end_date = strdate($end_date[1], '', '') . ' ' . $end_date[2] . ',' . $end_date[0]; $graph = new graph_creator(320, 600, "People Online As of {$from_date} to {$end_date}", $arr_label, $arr_data, $center_value = 0.45); $graph->create_pie_graph(); }
include 'configuration.php'; require 'coreclass.php'; session_start(); // if user is not login..redirect him to login page if (!isset($_SESSION['login'])) { header('Location: login.php'); } if (isset($_SESSION['login'])) { $userID = $_SESSION['userID']; $usertype = $_SESSION['usertype']; } $db = new database(); $year = $_POST['year']; $month = $_POST['month']; $month2 = strdate("{$month}", ''); $_SESSION['month'] = $month2; $_SESSION['year'] = $year; $sql = " select * from article_versions av "; $sql .= " where av.stageID=6 and av.status='published'"; $sql .= " and av.published_month = '{$month}' and av.published_year = '{$year}' "; $sql .= " order by av.dateline DESC "; if (!($result = $db->query($sql))) { die('Error:' . $db->error()); } $article_versions = array(); while ($row = $db->fetcharray()) { $article_versions[] = $row; } if (!($db->getnumrows() > 0)) { $result_msg = 'No Records Found';
unset($_SESSION['penddate']); */ if (isset($_POST['submit'])) { $_SESSION['submit'] = 'submit'; $puserid = $_POST['userid']; $pactivity = $_POST['activity']; //$pstartdate = $_POST['from_year']."-".$_POST['from_month']."-".$_POST['from_date'];; //$penddate = $_POST['end_year']."-".$_POST['end_month']."-".$_POST['end_date']; $day = $_POST['from_date']; $month = $_POST['from_month']; $year = $_POST['from_year']; $day2 = $_POST['end_date']; $month2 = $_POST['end_month']; $year2 = $_POST['end_year']; $sdmonth = strdate("{$month}", ''); $edmonth = strdate("{$month2}", ''); $_SESSION['sdmonth'] = $sdmonth; $_SESSION['sdday'] = $day; $_SESSION['sdyear'] = $year; $_SESSION['edmonth'] = $edmonth; $_SESSION['edday'] = $day2; $_SESSION['edyear'] = $year2; $pstartdate = mktime(0, 0, 0, $month, $day, $year); $penddate = mktime(0, 0, 0, $month2, $day2, $year2); /*echo 't1='.$t1; echo 't2='.$t2; echo 'sd='.$pstartdate; echo 'ed='.$penddate;*/ //print_r($_POST); $_SESSION['puserid'] = $puserid; $_SESSION['pactivity'] = $pactivity;
die('Error:' . $db->error()); } $my_articles = array(); while ($row = $db->fetcharray()) { $my_articles[] = $row; } if (!($db->getnumrows() > 0)) { $result_msg = 'No Records Found'; } //Remove pre-existing session vars if exists.. unset($_SESSION['report_editor_articles']); unset($_SESSION['year']); unset($_SESSION['month']); $_SESSION['report_editor_articles'] = $my_articles; $_SESSION['year'] = $year; $_SESSION['month'] = strdate($month, ''); for ($i = 0; $i < count($my_articles); $i++) { if ($my_articles[$i]->articleID) { $i % 2 == 0 ? $bgcolor = "" : ($bgcolor = "#F5F5F5"); $row_data .= '<tr class="tdhover" id= "tdata" bgcolor = "' . $bgcolor . '">'; $row_data .= '<td>'; $row_data .= $i + 1; $row_data .= '</td>'; $row_data .= '<td class="blue">'; $title = getArticleTitle($my_articles[$i]->articleID); $row_data .= ' ' . $title; $row_data .= '</td>'; $row_data .= '<td class="blue2">'; $category_name = getCategory_name($my_articles[$i]->articleID); $row_data .= $category_name; $row_data .= '</td>';