Cheap VPS & Xen Server


Residential Proxy Network - Hourly & Monthly Packages

PHP MySQL Select


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

  1. <?php
  2. $host = ‘localhost:3306’;
  3. $user = ;
  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. $sql = ‘SELECT * FROM emp4’;
  12. $retval=mysqli_query($conn$sql);
  13. if(mysqli_num_rows($retval) > 0){
  14.  while($row = mysqli_fetch_assoc($retval)){
  15.     echo “EMP ID :{$row[‘id’]}  <br> “.
  16.          “EMP NAME : {$row[‘name’]} <br> “.
  17.          “EMP SALARY : {$row[‘salary’]} <br> “.
  18.          “——————————–<br>”;
  19.  } //end of while
  20. }else{
  21. echo “0 results”;
  22. }
  23. mysqli_close($conn);
  24. ?>

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 
--------------------------------

Comments

comments