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 Chart 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-chart-api?hl=en. For more options, visit https://groups.google.com/groups/opt_out.
