PHP Tutorial
Control Statement
PHP Programs
- 20-php-programs
PHP Functions
PHP Arrays
PHP Strings
- php-string
- php-string-functions
PHP Math
- php-math-functions
PHP Form
- php-form:-get-post
PHP Include
- php-include-require
State Management
- php-cookie
- php-session
PHP File
Upload Download
- php-file-upload
- php-download-file
PHP Misc
PHP Mail
- php-mail
PHP MySQLi
PHP JSON
- php-json-example
PHP OOPs Concepts
PHP Topics
Related Tutorials
Interview Questions

PHP MySQL Select Query

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()
PDO::__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

<?php
$host = 'localhost:3306';
$user = '';
$pass = '';
$dbname = 'test';
$conn = mysqli_connect($host, $user, $pass,$dbname);
if(!$conn){
  die('Could not connect: '.mysqli_connect_error());
}
echo 'Connected successfully<br/>';

$sql = 'SELECT * FROM emp4';
$retval=mysqli_query($conn, $sql);

if(mysqli_num_rows($retval) > 0){
 while($row = mysqli_fetch_assoc($retval)){
    echo "EMP ID :{$row['id']}  <br> ".
         "EMP NAME : {$row['name']} <br> ".
         "EMP SALARY : {$row['salary']} <br> ".
         "--------------------------------<br>";
 } //end of while
}else{
echo "0 results";
}
mysqli_close($conn);
?>

Output:

Connected successfully
EMP ID :1 
EMP NAME : ratan 
EMP SALARY : 9000 
--------------------------------
EMP ID :2 
EMP NAME : karan 
EMP SALARY : 40000 
--------------------------------
EMP ID :3 
EMP NAME : jai 
EMP SALARY : 90000 
--------------------------------

Next TopicPHP MySQL Order by

← prev next →

Hot Tutorials

Contact US

Email:[email protected]

PHP Tutorial

Control Statement

PHP Programs

PHP Functions

PHP Arrays

PHP Strings

PHP Math

PHP Form

PHP Include

State Management

PHP File

Upload Download

PHP Misc

PHP Mail

PHP MySQLi

PHP JSON

PHP OOPs Concepts

PHP Topics

Related Tutorials

Interview Questions

PHP MySQL Select Query

PHP MySQLi Select Query Example

Hot Tutorials

Contact US