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: