JpGraph折线图功能实现过程

公司最近要求开发网站点击量统计的功能，使用折线图显示出来。通过查阅资料发现jpgraph是很方便、强大的制作图表工具。

下载地址：http://jpgraph.net/

1、先要保证PHP打开了Gd2的扩展：

打开PHP.ini，定位到extension=php_gd2.dll，把前面的分号删掉。

2、如果出现以下错误：

strtotime(): It is not safe to rely on the system’s timezone settings

请不要慌张，打开php.ini文件输入以下内容：

date.timezone = “Asia/Shanghai”

重启apache即可。

步骤：

一、把下载的jpgraph包放到自己的项目中

二、折线图代码读取数据库

<?php/*** Created by PhpStorm.* User: liang* Date: 2017/6/5* Time: 14:23*/$servername = "localhost";$username = "root";$password = "root";$dbname = "******";// 创建连接$conn = mysqli_connect($servername, $username, $password,$dbname);// 检测连接if (!$conn) {die("Connection failed: " . mysqli_connect_error());}$title = $_REQUEST['url'];$sql = "select *,count(*) as hit, FROM_UNIXTIME(addtime,'%Y-%m-%d') as e from cnmstl_artmodule_hits where FROM_UNIXTIME(addtime) >= date_sub(curdate(), INTERVAL 7 DAY) and title = '$title' group by e";//获取某个模块最近7天的点击量$result = $conn->query($sql);while($row = $result->fetch_assoc()) {$value = $row['hit'];$value_y[]=$value;$value_x[] = $row['e'];//x轴坐标名称// print_r($value);}$conn->close();-----------------------------------------------------------折线图类<?phpinclude ("jpgraph.php");include ("jpgraph_line.php");//将要用于图表创建的数据存放在数组中//$data = array(19,23,34,38,45,67,71,78,85,90,96,145);//print_r("$value_y");$data = $value_y;$graph = new Graph(500,300); //创建新的Graph对象$graph->SetScale("textlin"); //设置刻度样式$graph->img->SetMargin(30,30,80,30); //设置图表边界$graph->title->Set("XAZX Traffic Total"); //设置图表标题$graph->title->SetColor("blue");$graph->title->SetMargin(20);// Create the linear plot$lineplot=new LinePlot($data); // 创建新的LinePlot对象$lineplot->SetLegend("Line(hits)"); //设置图例文字$lineplot->SetColor("red"); // 设置曲线的颜色//设置x、y轴名称//$x = array('jan','feb','mar','asdfa','asdfa');//$y = array(1,3,4,5,6,7);$x = $value_x;$graph->xaxis->SetTickLabels($x);//$graph->xaxis->SetFont(FF_SIMSUN,FS_BOLD);//$graph->yaxis->SetTickLabels($y);//经过测试y轴的无效//$graph->yaxis->SetFont(FF_SIMSUN,FS_BOLD);// Add the plot to the graph$graph->Add($lineplot); //在统计图上绘制曲线// Display the graph$graph->Stroke(); //输出图像

三、效果