need php/mysql help

i have create php script which logs each visit in mysql database

i want to generate graph for user activiti in past 24 hours like


how to do this please help

 

You need the help of a GD library to accomplish this, just customize this code to suit your needs.

http://valokuva.org/?p=60

 

Try this script - http://pchart.sourceforge.net/

Great tool for creating charts. You will basically need to pull the data from the database and then it is fairly easy to generate a chart with it.

Google charts has an api that can be used for this as well which is nice since you don't need to install gd or anything else on you server - http://code.google.com/apis/chart/

 

Google "opensource php charts". I bet you'll find half a dozen useful scripts that you can use in your project for free.

 

You can use PHP and Dojo for the chart
dojotoolkit[dot]org/documentation/tutorials/1.6/charting/

 

Add a php chart class, here is a good example: http://mightystuff.net/php-chart-class
-clonepal

 

Before trying different charting libraries decide what do you want to chart . Make sure that you're collecting the proper data. For example from data "ip,pagevisited,time" you won't be able to make exactly the same chart as you've attached.

 

logging visits in a database with php is a waste.
all of the data you are collecting is already in your server log files.
do your website a favor and just make the charts from the .log file.

 

@lioncub5
That's right. There are many tools capable of analyzing apache logs and making great charts. However you have to get access to the logs. On a shared hosting it can be a problem.