"; // browse the whole table: browse_table($tableName); echo ""; } // close the database: close_database($link); // end with a 0 to close the session to the client: echo "\0"; end; // Functions ------------------------------- // Connect to a server and open a database: function open_database($myServer, $myDatabase, $myUser, $myPwd) { $myLink = mysql_connect($myServer, $myUser, $myPwd) or die('Could not connect: ' . mysql_error()); if ($list == 1) { echo 'Connected successfully'; } mysql_select_db($myDatabase) or die('Could not select database'); return $myLink; } // close an open database: function close_database($myLink) { mysql_close($myLink); } // select all from a table: function browse_table($myTable) { $query = "SELECT * FROM `$myTable`"; $result = mysql_query($query) or die('Query failed: ' . mysql_error()); // Printing results in HTML echo "\n"; while ($line = mysql_fetch_array($result, MYSQL_ASSOC)) { echo "\t\n"; foreach ($line as $col_value) { echo "\t\t\n"; } echo "\t\n"; } echo "
$col_value
\n"; // Free resultset mysql_free_result($result); } // insert a new record in the table: function insert_record($myTable, $recValue, $recDate, $recTime) { $query = "INSERT INTO `$myTable` (`Value`, `Date`, `Timestamp`) VALUES ('$recValue', '$recDate','$recTime')"; $result = mysql_query($query) or die('Query failed: ' . mysql_error()); // Free resultset mysql_free_result($result); } // delete a record from the table: function delete_record($myTable, $recNum) { $query = "DELETE FROM `$myTable` WHERE `ID` = $recNum LIMIT 1"; $result = mysql_query($query) or die('Query failed: ' . mysql_error()); // Free resultset mysql_free_result($result); } ?>