PHP SQL Rows

PHP SQL Rows is used to fetch the select the row value based on the condition specified in where clause and display it on the browser.

PHP SQL Rows

PHP SQL Rows

     

PHP SQL Rows is used to fetch the select the row value based on the condition specified in where clause and display it on the browser.

Understand with Example

The Tutorial illustrate an example from 'PHP SQL Rows'. To understand the example we create a table 'users'. The select query is used to returns  the records from table 'users'.

 

 

 

Table: users:

Source Code of sql_rows.php :

The sql_rows.php is a server side begins with <?php and end with ?>. This include a connection variable which is initialized with mysql_connect function. The mysql_connect ( ) accept the parameter like local host, user and password to authenticate the connection between the PHP and MySQL. Incase, there is connection failure between the PHP and  MySQL, the die part will be executed shows you the error message specifying the 'Could not connect'. To execute MySQL query in PHP, we make use of mysql_function ( )  that run the sql command. In this example we create a SQL query result which returns the set of records  from table 'users' based on the condition specified in where Clause. The row variable assigned the value of mysql_fetch_row ( ) function which accept the parameter result. Finally the echo print the row values on the browser. 

<?php
  $con = mysql_connect("localhost","root","root");
  if (!$con){
  die('Could not connect: ' . mysql_error());
  }
  mysql_select_db("test", $con);

  $result = mysql_query("SELECT id,email FROM users WHERE id = '12'");

  if (!$result) {
  echo 'Could not run query: ' . mysql_error();
  exit;
  }

  $row = mysql_fetch_row($result);
  echo "<b>ID: </b>";
  echo $row[0]."<br>";
  echo "<b>Email: </b>";
  echo $row[1];
?>

Download Source Code

Output:

Tutorials

  1. MySQL Create Table
  2. Mysql Add Column Default Value
  3. Mysql Add Column Number
  4. SQL Add Column Int
  5. SQL Add Column Position
  6. MySQL PHP Query delete
  7. Mysql Table Describe
  8. Mysql PHP Select
  9. MySQL PHP Search
  10. Mysql Table
  11. MySQL PHP Insert
  12. PHP SQL Search
  13. PHP SQL Insert
  14. PHP SQL Table
  15. PHP SQL Insert Statement
  16. PHP SQL Rows
  17. PHP SQL Fetch
  18. PHP SQL Select
  19. Mysql PHP Where
  20. PHP SQL Insertion
  21. SQL All Column Names
  22. SQL All Tables
  23. MySQL Add Column