Listing All Rows and Fields in a Table : Database Query : MySQL Database PHP Source Code


PHP Source Code » MySQL Database » Database Query »

 

Listing All Rows and Fields in a Table



<html>
<head>
<title>Listing all rows and fields in a table</title>
</head>
<body>
<?php
$user = "navioo";
$pass = "password";
$db = "navioo";
$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>


           
       



HTML code for linking to this page:

Follow Navioo On Twitter

PHP Source Code

 Navioo MySQL Database
» Database Query