|
<html>
<head>
<title>Listing all rows and fields in a table</title>
</head>
<body>
<?php
$user = "java2s";
$pass = "password";
$db = "java2s";
$link = mysql_connect( "mysql153.secureserver.net", $user, $pass );
if ( ! $link ){
die( "Couldn't connect to MySQL" );
}
mysql_select_db( $db, $link ) or die ( "Couldn't open $db: ".mysql_error() );
$result = mysql_query( "SELECT * FROM Employee" );
$num_rows = mysql_num_rows( $result );
print "There are currently $num_rows rows in the table<P>";
print "<table border=1>\n";
while ( $a_row = mysql_fetch_row( $result ) ){
print "<tr>\n";
foreach ( $a_row as $field )
print "\t<td>$field</td>\n";
print "</tr>\n";
}
print "</table>\n";
mysql_close( $link );
?>
</body>
</html>
|
