背景知识
JpGraph:以前用PHP作图时必须要掌握复杂抽象的画图函数,或者借助一些网上下载的花柱形图、饼形图的类来实现。没有一个统一的chart类来实现图表的快速开发。
现在我们有了一个新的选择:JpGraph。专门提供图表的类库。它使得作图变成了一件非常简单的事情,你只需从数据库中取出相关数据,定义标题,图表类型,然后的事情就交给JpGraph,只需掌握为数不多的JpGraph内置函数(可以参照JpGraph附带例子学习),就可以画出非常炫目的图表!
一、 JpGraph安装方法:
1、先到http://www.aditus.nu/jpgraph/下载最新的版本。
2、确保你的PHP版本最低为4.04(最好是4.1.1),并且支持GD库。必须确保GD库可以正常运行,可以通过运行phpinfo()来查看GD库的信息是否存在的方法来判断。同时要有要求GD库的版本应为2.0,而不是1.0。
3、将下载的JpGraph压缩包解压到任意文件夹。
4、设置jpgraph.php(jpgraph的主配置文件)。设置jpgraph的cache(缓存)文件夹,和TTF(字体)文件夹。
分别在35行和38行
35 // DEFINE("CACHE_DIR","/tmp/jpgraph_cache/");
38 // DEFINE("TTF_DIR","/usr/X11R6/lib/X11/fonts/truetype/");
Linux系统改为:
DEFINE("CACHE_DIR","/tmp/jpgraph_cache/");
DEFINE("TTF_DIR","/usr/X11R6/lib/X11/fonts/truetype/");
Windows系统改为:
DEFINE("CACHE_DIR","c:/apache/htdocs/ jpgraph_cache/");
DEFINE("TTF_DIR","c:/windows/fonts");
注意事项:
(1)cache(缓存)文件夹路径可以自己定义,而TTF(字体)文件夹必须是%system%/Fonts。
(2)确保PHP对cache(缓存)文件夹有写的权限。
5、完成上述设置后就可以使用JpGraph了,可以先将JpGraph的例子copy到htdocs文件夹中,运行一下看看。呵呵,200多个例子,包含各类图表,够学一阵子的。
在实际使用中,如果还有一些不懂或者不太明白地方,可以参考bkJia中文发布的 bkJia视频教程85:PHP 图表类 JPGraph 入门配置与应用
从数据库中读取数据到jpgraph图表中
1、将./src/Examples目录中的文件example16.2.php以及./src目录中的文件jpgraph_bar.php、jpgraph_gradient.php、jpgraph_line.php、jpgraph_plotmark.inc、jpgraph.php拷贝到同一目录下。
2、建立数据库jpg,数据库表test
建立2个字段:
id(主键):int
number:int
并添加一些数据
3、修改example16.2.php
修改后的代码
<ol class="dp-c"> <li class="alt"><span><span><?php </span></span></span></li> <li> <span class="keyword">include</span><span> (</span><span class="string">"jpgraph.php"</span><span>); </span> </li> <li class="alt"> <span class="keyword">include</span><span> (</span><span class="string">"jpgraph_line.php"</span><span>); </span> </li> <li> <span class="keyword">include</span><span> (</span><span class="string">"jpgraph_bar.php"</span><span>); </span> </li> <li class="alt"> <span class="vars">$connect</span><span>=mysql_connect(</span><span class="string">"localhost"</span><span>,</span><span class="string">"root"</span><span>,</span><span class="string">""</span><span>); </span> </li> <li> <span>mysql_select_db(</span><span class="string">"jpg"</span><span>,</span><span class="vars">$connect</span><span>); </span> </li> <li class="alt"> <span class="vars">$query</span><span>=mysql_query(</span><span class="string">"select * from test"</span><span>,</span><span class="vars">$connect</span><span>); </span> </li> <li> <span class="vars">$i</span><span>=0; </span> </li> <li class="alt"> <span class="keyword">while</span><span> (</span><span class="vars">$array</span><span>=mysql_fetch_array(</span><span class="vars">$query</span><span>)) { </span> </li> <li> <span class="vars">$l2datay</span><span>[</span><span class="vars">$i</span><span>]=</span><span class="vars">$array</span><span>[</span><span class="string">"number"</span><span>]; </span> </li> <li class="alt"> <span class="vars">$i</span><span>++; </span> </li> <li><span>} </span></li> <li class="alt"> <span>mysql_close(</span><span class="vars">$connect</span><span>); </span> </li> <li> <span class="comment">// Create the graph. </span><span> </span> </li> <li class="alt"> <span class="vars">$graph</span><span> = </span><span class="keyword">new</span><span> Graph(400,200,</span><span class="string">"auto"</span><span>); </span> </li> <li> <span class="vars">$graph</span><span>->SetScale(</span><span class="string">"textlin"</span><span>); </span> </li> <li class="alt"> <span class="vars">$graph</span><span>->img->SetMargin(40,130,20,40); </span> </li> <li> <span class="vars">$graph</span><span>->SetShadow(); </span> </li> <li class="alt"> <span class="comment">// Create the bar plot </span><span> </span> </li> <li> <span class="vars">$bplot</span><span> = </span><span class="keyword">new</span><span> BarPlot(</span><span class="vars">$l2datay</span><span>); </span> </li> <li class="alt"> <span class="vars">$bplot</span><span>->SetFillColor(</span><span class="string">"orange"</span><span>); </span> </li> <li> <span class="vars">$bplot</span><span>->SetLegend(</span><span class="string">"Result"</span><span>); </span> </li> <li class="alt"> <span class="comment">// Add the plots to the graph </span><span> </span> </li> <li> <span class="vars">$graph</span><span>->Add(</span><span class="vars">$bplot</span><span>); </span> </li> <li class="alt"> <span class="vars">$graph</span><span>->title->Set(</span><span class="string">"Adding a line plot to a bar graph v1"</span><span>); </span> </li> <li> <span class="vars">$graph</span><span>->xaxis->title->Set(</span><span class="string">"X-title"</span><span>); </span> </li> <li class="alt"> <span class="vars">$graph</span><span>->yaxis->title->Set(</span><span class="string">"Y-title"</span><span>); </span> </li> <li> <span class="vars">$graph</span><span>->title->SetFont(FF_FONT1,FS_BOLD); </span> </li> <li class="alt"> <span class="vars">$graph</span><span>->yaxis->title->SetFont(FF_FONT1,FS_BOLD); </span> </li> <li> <span class="vars">$graph</span><span>->xaxis->title->SetFont(FF_FONT1,FS_BOLD); </span> </li> <li class="alt"> <span class="comment">//$graph->xaxis->SetTickLabels($datax); </span><span> </span> </li> <li> <span class="comment">//$graph->xaxis->SetTextTickInterval(2); </span><span> </span> </li> <li class="alt"> <span class="comment">// Display the graph </span><span> </span> </li> <li> <span class="vars">$graph</span><span>->Stroke(); </span> </li> <li class="alt"><span>?> </span></li> </ol>
4、刷新页面即可看到结果