Mega Code Archive
Constantly refresh your PHP-HTML page data
<![CDATA[
<?
ECHO "<html><head><title>Constantly refresh your page.</title></head><body>";
ECHO "Starting...<br>";
flush();
sleep(2);
$i=1;
while ($i < 4) { // delay
ECHO "$i<br>"; // Display the counter.
flush();
sleep(1);
$i++;
} // end
// Query your database here. I am using sybase calls.
if (!@sybase_Connect("DATABASENAME, "USERNAME", "PASSWORD")) {
echo "<p><font color="red\">Error - Unable to connect to the sybase server. </font></p> \n";
exit;
}
if (!@sybase_select_db("SOMEDATABASE")) {
echo "<p><font color=\"red\">Error - unable to access the specific database. </font></p> \n";
exit;
}
$query_get_info = "SELECT FIELDA, FIELDB, FIELDC, FIELDD FROM SOMETABLE ORDER BY FIELDA";
$rs = @sybase_query($query_get_info); // execute the query
if ($rs) { // ok
$nrows = 0;
$nrows = @sybase_num_rows($rs);
echo "<p>Found $nrows row(s). </p> \n";
if ($nrows > 0) {
echo "<table border=\"1\" width=\"100%\" bordercolor=\"#000000\" bgcolor=\"#C0C0C0\" name=\"displaytable\"> \n";
$x = 0;
/* display the table column headers */
echo "<tr><th bgcolor=\"#6666FF\">FIELDA</th> \n";
echo "<th bgcolor=\"#6666FF\">FIELDB</th> \n";
echo "<th bgcolor=\"#6666FF\">FIELDC</th> \n";
echo "<th bgcolor=\"#6666FF\">FIELDD</th></tr> \n";
while ($x < $nrows) { // display the information
$display_row = @sybase_fetch_row($rs);
echo "<tr> \n";
$display_item1 = $display_row[0];
echo "<td>$display_item1 </td> \n";
$display_item2 = $display_row[1];
echo "<td>$display_item2 </td> \n";
$display_item3 = $display_row[2];
echo "<td>$display_item3 </td> \n";
$display_item4 = $display_row[3];
echo "<td>$display_item4 </td></tr> \n";
$x++;
} // end loop
echo "</table><br> \n";
} // end if nrows
} // end if rs
ECHO "<br><b>In 5 seconds this page will refresh.</b><br>\n";
flush();
sleep(5);
// Now use javascript to send the page to itself.
?>
<SCRIPT LANGUAGE="JavaScript">
history.go(0)
</SCRIPT>
<?
ECHO "</body></html>";
?>
]]>