How can we display all records from MySQL table using PHP script?

To illustrate this, we will use a PHP script to get all records from a table named 'Tutorials_tbl' using mysql_query() and mysql_fetch_array() function, the example is as follows:

<?php
   $dbhost = &#39;localhost:3036&#39;;
   $dbuser = &#39;root&#39;;
   $dbpass = &#39;rootpassword&#39;;
   $conn = mysql_connect($dbhost, $dbuser, $dbpass);

   if(! $conn ) {
      die(&#39;Could not connect: &#39; . mysql_error());
   }
   $sql = &#39;SELECT tutorial_id, tutorial_title, tutorial_author, submission_date
      FROM tutorials_tbl&#39;;

   mysql_select_db(&#39;TUTORIALS&#39;);
   $retval = mysql_query( $sql, $conn );

   if(! $retval ) {
      die(&#39;Could not get data: &#39; . mysql_error());
   }

   while($row = mysql_fetch_array($retval, MYSQL_ASSOC)) {
      echo "Tutorial ID :{$row[&#39;tutorial_id&#39;]} <br> ".
         "Title: {$row[&#39;tutorial_title&#39;]} <br> ".
         "Author: {$row[&#39;tutorial_author&#39;]} <br> ".
         "Submission Date : {$row[&#39;submission_date&#39;]} <br> ".
         "--------------------------------<br>";
   }
   echo "Fetched data successfully</p><p>";
   mysql_close($conn);
?>

In the above example, the constant MYSQL_ASSOC is used as the second of the PHP function mysql_fetch_array() parameters to return the rows as an associative array. With associative arrays, you can access fields by using their names instead of indexes.

The above is the detailed content of How can we display all records from MySQL table using PHP script?. For more information, please follow other related articles on the PHP Chinese website!