如何使用php在我的管理面板中绘制统计数据折线图


how to draw statistics line chart in my admin panel using php?

我想使用php在管理面板中使用GD库显示我的图表。。我从数据库中获取日期,但当我使用任何库以折线图显示此结果时,它都不起作用;它没有显示任何错误。我不明白我做错了什么?有人能帮我吗?

<?php
include ("../setting.php");
include("../classes/phpgraphlib.php"); 

$result = mysql_query("SELECT   DATE_FORMAT(log_date, '%Y-%m-%d') as Date,count(*) as Count FROM log  
where operation_type='Add' and user_id='82' and faculty_code='0' group by log_date order by log_date") or die(mysql_error());
$MultiDimArray = array();
$data = array();
while( $row = mysql_fetch_array($result , MYSQL_BOTH) )
{   
$MultiDimArray[] = array ( 'Date' => $row['Date'], 'Count' => $row['Count'] );
}

foreach($MultiDimArray as $value)
{
    if ( !array_key_exists($value['Date'], $data) ) {
      $data[$value['Date']] = $value['Count'];
    }
   else{ $data[$value['Date']] += (string)$value['Count'];} 
}
$data = array_map('strval', $data);
$graph = new PHPGraphLib(400,300);
$graph->addData($data);
$graph->setTitle("Site Statistics");
$graph->setBars(false);
$graph->setLine(true);
$graph->setDataPoints(true);
$graph->setDataPointColor("maroon");
$graph->setDatadata(true);
$graph->setDataValueColor("maroon");
$graph->setGoalLine(.0025);
$graph->setGoalLineColor("red");
$graph->setXdataHorizontal(true);
$graph->createGraph();
?>    `

$data数组的输出如下:

array'2013-05-13' => string '7' (length=1)'2013-05-15' => string '3' (length=1)'2013-05-16' => string '5' (length=1)'2013-05-18' => string '8' (length=1)'2013-05-19' => string '2' (length=1)'2013-05-21' => string '2' (length=1)'2013-05-22' => string '10' (length=2)'2013-05-23' => string '2' (length=1)'2013-05-25' => string '1' (length=1)'2013-05-26' => string '8' (length=1)'2013-05-27' => string '19' (length=2)'2013-05-28' => string '7' (length=1)'2013-05-29' => string '3' (length=1)'2013-06-02' => string '11' (length=2)'2013-06-03' => string '2' (length=1)'2013-06-04' => string '7' (length=1)'2013-06-05' => string '3' (length=1)'2013-06-06' => string '2' (length=1)'2013-06-09' => string '15' (length=2)'2013-06-10' => string '5' (length=1)'2013-06-11' => string '1' (length=1)'2013-06-12' => string '3' (length=1)'2013-06-15' => string '10' (length=2)'2013-06-16' => string '3' (length=1)'2013-06-19' => string '2' (length=1)

我建议使用JS来实现这一点,并向其提供来自PHP的数据。看看Flot或类似的东西。