Reading Data From MySQL Database With PHP

To read records from a database, the technique is usually to loop round and find the ones you want. To specify which records you want, you use something called SQL. This stands for Structured Query Language. This is a natural, non-coding language that uses words like SELECT and WHERE. At it's simplest level, it's fairly straightforward. But the more complex the database, the more trickier the SQL is. We'll start with something simple though.
What we want to do, now that we have a connection to our database, is to read all the records, and print them out to the page. Here's some new code, added to the PHP script you already have. The new lines are in red:

    $user_name = "root";
    $password = "";
    $database = "addressbook";
    $server = "127.0.0.1";

    $db_handle = mysql_connect($server, $user_name, $password);
    $db_found = mysql_select_db($database, $db_handle);

   if ($db_found) {
   $SQL = "SELECT * FROM tb_address_book";
   $result = mysql_query($SQL);
   while ($db_field = mysql_fetch_assoc($result)) {
       print $db_field['ID'];
       print $db_field['First_Name'];
       print $db_field['Surname'];
       print $db_field['Address'];
   }
   mysql_close($db_handle);
  }
  else {
  print "Database NOT Found ";
  mysql_close($db_handle);
}

Here ID,First_Name,Surname,Address are the attributes of the table tb_address_book in the MySQL Database.