PHP MySQL Select

PHP MySQL Display Data

The SELECT statement is used to display data from a table.

To display all data from a table use select(*) statement and to display particular field's data use select filed1,filed2 at the place of (*).

Syntax

 SELECT  column1, column2, column3,... FROM table_name
//OR
SELECT * FROM table_name

Ex(PHP MySQL Display Data)

<?php
//connect database 
$con=mysqli_connect("localhost","root","","Employee") or die(mysqli_error());
//select all values from empInfo table
$data="SELECT * FROM empInfo";
$val=mysqli_query($con,$data);
while($r=mysqli_fetch_array($val))
{
echo $r['emp_id']." ".$r['name']." ".$r['email']." ".$r['mobile']."<br/>";
}				
?>

The example above stores the data returned by the mysql_query( ) function in the $data variable. Next, we use the mysql_fetch_array( ) function to return the first row from the recordset as an array. Each call to mysql_fetch_array( ) returns the next row in the recordset. The while loop loops through all the records in the recordset. To print the value of each row, we use the PHP $r variable ($r['emp_id'], $r['name'],$r['email'] and $r['mobile']).

Select values from table using list( ) function

<?php
//connect database 
$con=mysqli_connect("localhost","root","","Employee") or die(mysqli_error());
	
//select all values from empInfo table
$data="SELECT * FROM empInfo";
$val=mysqli_query($con,$data);
			
while(list($id,$name,$eid,$mob) = mysqli_fetch_array($val))
{
 echo $id." ".$name." ".$eid." ".$mob."<br/>";
}		
?>

The example above stores the data returned by the mysql_query( ) function in the $data variable. Next, we use the mysql_fetch_array( ) function to return the first row from the recordset as list($id,$name,$eid,$mob) funtion in variable $id,$name,$eid,$mob. 1st field values stored in $id, 2nd in $name, 3rd in $eid and 4th values in $mob . Now print variables $id, $name, $eid, $mob.

Display the Records inside Table

<?php
//connect database 
$con=mysqli_connect("localhost","root","","Employee") or die(mysqli_error());
//select values from empInfo table
$data="SELECT * FROM empInfo";

$val=mysqli_query($con,$data);			
echo "<table border='1'>";
echo "<tr><th>Emp_id</th><th>Name</th><th>Email</th><th>Mobile</th></tr>";
while(list($id,$name,$eid,$mob)= mysql_fetch_array($val))
{
 echo "<tr>";	
 echo "<td>".$id."</td>";
 echo "<td>".$name."</td>";
 echo "<td>".$eid."</td>";
 echo "<td>".$mob."</td>";
 echo "</tr>";
}		
echo "</table>";		
?>

« Previous Next »

MySQL Tutorial SQL Introduction MySQL Constraints MySQL Common Queries PHP MySQL Connectivity PHP Mysqli Database Connectivity PHP MySQL Create Database PHP Create MySQLi Database PHP MySQL Insert PHP MySQL Update PHP MySQL Delete PHP MySQL Select Mysqli Fetch Array Mysqli Fetch Assoc Mysqli fetch row Mysqli fetch object MySQL Where Clause MySQL Order By Select Insert Update Delete in Php How to create foreign key MySQL auto increment PHP MySQL Secure Registration Page PHP MySQL Secure Login Page MySQL Predefined Function MySQL Joins How to Export MySQL to CSV How to import csv into mysql How to edit radio button in PHP MySQL PHP MySQL Pagination Upload and Display Video in PHP Building a bar chart How to update Radio button, Checkbox and dropdown Create Registration form PHP MySQL How to insert data from textarea to database PHP PHP PDO

No Sidebar ads