| <?php |
| |
| require_once "/home/data/httpd/eclipse-php-classes/system/dbconnection_dashboard_rw.class.php"; |
| |
| $db_connection = new DBConnectionDashboard(); |
| $db_handle = $db_connection->connect(); |
| |
| echo "<HTML>\n<HEAD><TITLE>Test page</TITLE></HEAD>\n"; |
| echo "<BODY>\n<H1>Test</H1>\n"; |
| |
| $table = "stats"; |
| |
| $query = "SELECT * FROM ".$table." WHERE stats_date = DATE_SUB(\"".date('Y-m-d')."\", INTERVAL 1 DAY)"; |
| |
| #$query = "SELECT * FROM ".$table." WHERE stats_date = \"".date('Y-m-d')."\""; |
| echo $query."<br>"; |
| $res = mysql_query($query,$db_handle); |
| while($a = mysql_fetch_assoc($res)){ |
| print_r($a); |
| echo "<br>"; |
| } |
| |
| echo "</BODY></HTML>"; |
| |
| $db_handle = null; |
| $db_connection = null; |
| |
| |
| ?> |
