Retrieving Data With PHP & MySQL(while loop)


Sandy | Full stack Web developer

<?php
mysql_connect(“localhost”, “admin”, “password”) or die(mysql_error());
mysql_select_db(“test”) or die(mysql_error());

// Retrieve all the data from the “example” table
$result = mysql_query(“select * from example”) or die(mysql_error());

//store the record of the “example” table into $row

//Print out the contents of the entry
echo “<table border=’1′>”;
echo “<tr><th>Name</th><th>Age</th></tr>”;
while($row = mysql_fetch_array($result))
{
echo “<tr><td>”.$row[‘name’].”</td><td>”.$row[‘age’];
echo “</td></tr>”;
}
echo “</table>”;
?>

View original post

Advertisements

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out / Change )

Twitter picture

You are commenting using your Twitter account. Log Out / Change )

Facebook photo

You are commenting using your Facebook account. Log Out / Change )

Google+ photo

You are commenting using your Google+ account. Log Out / Change )

Connecting to %s