Work:MySQL Test Script

<?php
 
// change the below to whatever you want
$dat = "localhost";
$datuser = "bootydoc_mgn01";
$datpass = "password";
$datdb = "bootydoc_mgn01";
$table = "table";
// begin your code
 
print ("<h3><u>test 1 - connect to host</u></h3>\n");
$link = mysql_connect($dat, $datuser, $datpass)
or die("<br>die message<br>--------------<br><b><i>Could not connect<br>\n" . mysql_error() . "</i></b>");
print ("Connected successfully<br>\nmysql_connect value:&nbsp;\n");
print ("<b><i>" . $link . "</i></b><br>\n");
print ("connected successfully to host <b><i>" . $dat . "</b></i> and user <b><i>" . $datuser . "</b></i>\n<br>\n");
 
print ("<h3><u>test 2 - mysql persistent connect test</u></h3>");
mysql_close($link);
$link = mysql_pconnect($dat, $datuser, $datpass)
or die("<br>die message<br>--------------<br><b><i>Could not connect<br>\n" . mysql_error() . "</i></b>");
print ("Connected successfully<br>\nmysql_pconnect value:&nbsp;\n");
print ("<b><i>" . $link . "</i></b><br>\n");
print ("connected successfully to host <b><i>" . $dat . "</b></i> and user <b><i>" . $datuser . "</b></i>\n<br>\n");
 
print ("<h3><u>test 3 - connect to database</u></h3>");
mysql_select_db($datdb)
or die("<br>die message<br>--------------<br><b><i>Could not connect db<br>\n" . mysql_error() . "</i></b>");
print ("mysql_select_db successfully connected to database <b><i>" . $datdb . "</b></i><br><br>\n");
 
print ("<h3><u>test 4 - perform select query</u></h3>\n");
$query = "SELECT * FROM $table";
$result = mysql_query($query)
or die("Query failed");
 
print "<table>\n";
while ($line = mysql_fetch_array($result, MYSQL_ASSOC)) {
print "\t<tr>\n";
foreach ($line as $col_value) {
print "\t\t<td>$col_value</td>\n";
}
print "\t</tr>\n"; }
print "</table>\n";
mysql_close($link);
?>