php mysql select record and display

PHP MySQL Select Row In Database

the select query is display the records in database table.

PHP mysql_query() function is used to execute select query. Since PHP 5.5, mysql_query() function is deprecated. Now it is recommended to use one of the 2 alternatives.

• mysqli_query()

There are two other MySQLi functions used in select query.

• mysqli_num_rows(mysqli_result $result): returns number of rows.
• mysqli_fetch_assoc(mysqli_result $result): returns row as an associative array. Each key of the array represents the column name of the table. It return NULL if there are no more rows.

PHP MySQLi Select Query Example

Example

1. <?php  
2. $host = 'localhost';  
3. $user = 'root';  
4. $pass = '';  
5. $dbname = 'test';  
6. $conn = mysqli_connect($host, $user, $pass,$dbname);  
7. if(!$conn){  
8.   die('Could not connect: '.mysqli_connect_error());  
9. }  
10. echo 'Connected successfully<br/>';  
11.   
12. $sql = 'SELECT * FROM staff';  
13. $retval=mysqli_query($conn, $sql);  
14.   
15. if(mysqli_num_rows($retval) > 0){  
16.  while($row = mysqli_fetch_assoc($retval)){  
17.     echo "staff id :{$row['id']}  <br> ".  
18.          "staff name : {$row['name']} <br> ".  
19.          "staff salary : {$row['salary']} <br> ".  ;
20.  } //end of while  
21. }else{  
22. echo "0 results";  
23. }  
24. mysqli_close($conn);  
25. ?>  

Output:

Connected successfully
staff id :1 
staff name : ratan 
staff salary : 9000 

staff id :2 
staff name : karan 
staff salary : 40000 

staff id :3 
staff name : jai 
staff salary : 90000