There are many threads on this forum that cover this exact topic, search for "PHP" in the forum and see if any of those help. If you try out the examples posted in them and can't get them to work for you, I'd be happy to help fix it.
On Thursday, March 21, 2013 6:05:23 AM UTC-4, Simon Mandy wrote: > > Hello I am a new user to Google Chart and my knowledge on php and mysql > is also limited. > > I have a website running on php and mysql. I have a counter page setup > where the clients' ip address and date,time they visited the website is > stored on mysql databse. Below is the page where it is displayed > http://raspisimon.no-ip.org/view.php > > I am trying to setup a chart using google charts. X axis - Date . Y axis - > Total number hits on that particular date. > > How to get started. > > Below is the code, that generated the Visitors section of counter page, > > *<?php > > // ######################## > // ### Display visitors ### > // ######################## > > echo '<h3> Visitors </h3>' ; > > $result = mysql_query("SELECT * FROM $dbtableinfo ORDER BY id DESC") > or die(mysql_error()); > > echo "<table width='100%' border='0'>"; > echo '<tr> <td width="200" bgcolor="#1AC414"> IP </td> <td height="2" > bgcolor="#1AC414" width="400">User agent</td> <td height="2" > bgcolor="#1AC414" width="169"> Date & Time</td></tr>'; > > // keeps getting the next row until there are no more to get > while($row = mysql_fetch_array( $result )) > { > // Print out the contents of each row into a table > echo '<tr><td bgcolor="#75D169">'; > echo $row['ip_address']; > echo '</td><td bgcolor="#75D169">'; > echo $row['user_agent']; > echo '</td><td bgcolor="#75D169">'; > echo $row['datetime']; > echo "</td></tr>"; > } > echo "<tr><td bgcolor=\"#1AC414\"> <strong> Total unique IP´s </strong> > </td><td bgcolor=\"#1AC414\"> <strong> $totalips </strong> </td></tr>" ; > echo "</table><br /> "; > > ?>* > > -- You received this message because you are subscribed to the Google Groups "Google Visualization API" group. To unsubscribe from this group and stop receiving emails from it, send an email to [email protected]. To post to this group, send email to [email protected]. Visit this group at http://groups.google.com/group/google-visualization-api?hl=en. For more options, visit https://groups.google.com/groups/opt_out.
