PHP MySql Select

In PHP, we can execute a select MySql statement and fetch the records from the database table. First we need to create a MySql connection, write the sql query, execute the query and fetch the record.

Example 1: Create a MySql connection, execute the query and fetch all the record from the MySql table.

<?php
	//$conn = mysqli_connect("server_name", "username" , "password", "database_name");
	$conn = mysqli_connect("localhost", "root" , "", "student");
	
	if($conn === false){
		die("ERROR: Could not connect to database.");
	}
	
	$sql = "select * from book"; //sql query, book is a table name
	$result = mysqli_query($conn, $sql);
	
	while($rows = mysqli_fetch_array($result)) //fetch all records
	{
		echo $rows['Id'] . $rows['Name'] . "<br>"; //display records
	}
	
	mysqli_close($conn); //close connection
?>

Example 2: Count number of rows/records.

<?php
	$conn = mysqli_connect("localhost", "root" , "", "student");
	
	if($conn === false){
		die("ERROR: Could not connect to database.");
	}
	
	$sql = "select * from book";
	$result = mysqli_query($conn, $sql);
	$rows = mysqli_num_rows($result);
	echo "Total number of Records: ". $rows;
	
	mysqli_close($conn);
?>