PHP call GNUPlot to create chart

sleep_meng

Sorry, my English is bad. But I have not Chinese input type in my system. very sorry!

    I just finish a project that display chart graph. At biganing, I use the JpGraph to create chart. but JpGraph can't create the it better. And JpGraph is very slow if have many data(have max then 50000 line data from SQL server and use it to draw chart). The CPU used 99% when I browser. and must set php.ini to change the memory_limit=32M. memory and time used very many too.

    now, I use a shell script to create the chart, and use PHP call this shell script to  get chart graph. That very fast and not use many memory.

    Folowing is my code.

1. bash script:  plot
   
2. #!/bin/bash
   
3. . config
   
4. echo "SELECT nm_t,$4 FROM $tablename WHERE \
   
5.       nm_gap=$1 AND nm_t>;=$2 AND nm_t<=$3 GROUP BY nm_t;" \
   
6.       | mysql $dbname --user=$dbuser --pass=$dbpass --silent \
   
7.       >; plot.dat
   
8. 
   
9. gnuplot << ENDOFINPUT
   
10. set terminal png color
    
11. set xdata time
    
12. set timefmt "%Y%m%d%H%M%S"
    
13. set format x "%Y\n%m/%d\n%H:%M"
    
14. set size 1.4,0.7
    
15. set title "Cosmic rays variations"
    
16. set nokey
    
17. set grid
    
18. plot "plot.dat" using 1:2 with lines
    
19. ENDOFINPUT
    
20. 
    
21. 
    
22. php file: plot.php
    
23. <?php
    
24. isset($_GET['fromYear']) ? $fromYear  = $_GET['fromYear']  : $fromYear= gmdate("Y");
    
25. isset($_GET['toYear'])   ? $toYear    = $_GET['toYear']    : $toYear  = gmdate("Y");
    
26. isset($_GET['fromMonth'])? $fromMonth = $_GET['fromMonth'] : $fromMonth= gmdate("m");
    
27. isset($_GET['toMonth'])  ? $toMonth   = $_GET['toMonth']   : $toMonth = gmdate("m");
    
28. isset($_GET['fromDay'])  ? $fromDay   = $_GET['fromDay']   : $fromDay = gmdate("d")-1;
    
29. isset($_GET['toDay'])    ? $toDay     = $_GET['toDay']     : $toDay   = gmdate("d")-1;
    
30. isset($_GET['fromMin'])  ? $fromMin   = $_GET['fromMin']   : $fromMin = 0;
    
31. isset($_GET['toMin'])    ? $toMin     = $_GET['toMin']     : $toMin   = 0;
    
32. isset($_GET['fromHour']) ? $fromHour  = $_GET['fromHour']  : $fromHour= 0;
    
33. isset($_GET['toHour'])   ? $toHour    = $_GET['toHour']    : $toHour  = 23;
    
34. isset($_GET['timeSlot']) ? $timeSlot  = $_GET['timeSlot']  : $timeSlot= 60;
    
35. isset($_GET['dataType']) ? $dataType  = $_GET['dataType']  : $dataType= 0;
    
36. 
    
37. $gap = $timeSlot;
    
38. if ($dataType == 0)$coly = "nm_on";
    
39. if ($dataType == 1)$coly = "nm_off";
    
40. 
    
41. if($fromMonth<10)$fromMonth = "0".$fromMonth;
    
42. if($toMonth<10)  $toMonth   = "0".$toMonth;
    
43. if($fromDay<10)  $fromDay   = "0".$fromDay;
    
44. if($toDay<10)    $toDay     = "0".$toDay;
    
45. if($fromHour<10) $fromHour  = "0".$fromHour;
    
46. if($toHour<10)   $toHour    = "0".$toHour;
    
47. if($fromMin<10)  $fromMin   = "0".$fromMin;
    
48. if($toMin<10)    $toMin     = "0".$toMin;
    
49. 
    
50. $from = $fromYear.$fromMonth.$fromDay.$fromHour.$fromMin."00";
    
51. $to   = $toYear.$toMonth.$toDay.$toHour.$toMin."60";
    
52. 
    
53. passthru("/bin/bash plot ".escapeshellcmd($gap)." "
    
54.                           .escapeshellcmd($from)." "
    
55.                           .escapeshellcmd($to)." "
    
56.                           .escapeshellcmd($coly));
    
57. exit;
    
58. ?>;

复制代码

like this to display chart graph.

<img src="plot.php?title=&dataType=0&timeSlot=86400&fromYear=2003
         &toYear=2003&fromMonth=1&toMonth=12&fromDay=1&toDay=31
         &fromHour=0&toHour=23&fromMin=0&toMin=59">;

sleep_meng

我想这篇文章对那些要用PHP做图表的人一定有所帮助，怎么没人关心呢？