PHP : MySQL Select Data

The MySQL SELECT statement is used to select data from database tables.

Process of Data Fetching/Retrieving:

  • Create Database connection using mysqli_connect()
  • Use mysqli_query() to perform a select query on database
  • mysqli_query() returns a resource (data type) on success for select statement
  • The returned resource should be passed to mysqli_fetch_array() to access data/tables.
  • mysqli_fetch_array() Returns an array of strings for each table row or NULL if there are no more rows in resultset.
  • Finally, The while() loop iterates to display data from each row.
<?php
/**
 * Create Database Connection
 */
 
$database_server = 'localhost';
$database_username = 'root';
$database_password = '';
$database_name = 'student';
 
// Create connection using mysqli_connect()
$conn = mysqli_connect($database_server, $database_username, $database_password, $database_name);
 
// If $conn is false, connection is failed
if (!$conn ) {
  die("Failed to connect to MySQL: " . mysqli_connect_error());
}
 
echo "Database Connected Successfully. <br />";
 
?>
<?php
/**
 * Select Table Data
 * Fectching aata from database using mysqli_fetch_array() function and without table tag
 */
 
require_once('db-connection.php');
 
// Mysql query to select data from table
$mysql_query_statement = "SELECT * FROM users";
$result = $conn->query($mysql_query_statement);
 
while($user_data = mysqli_fetch_array($result)) {
 	echo $user_data['name']." ".$user_data['mobile']." ".$user_data['email'] . '<br />';
}
 
//Connection Close	
mysqli_close($conn);
?>

Congratulations! Chapter Finished. Learn more about the similar topics:
Exercises & Assignments
No Content Found.
Interview Questions & Answers
No Content Found.