Home Sql Mysql-table PHP SQL Rows
Questions:Ask|Latest

 
 

Share on Google+Share on Google+

PHP SQL Rows

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

Advertisements

If you enjoyed this post then why not add us on Google+? Add us to your Circles



Liked it!  Share this Tutorial


Follow us on Twitter, or add us on Facebook or Google Plus to keep you updated with the recent trends of Java and other open source platforms.

Posted on: April 3, 2006

Related Tutorials

Ask Questions?    Discuss: PHP SQL Rows  

Post your Comment


Your Name (*) :
Your Email :
Subject (*):
Your Comment (*):
  Reload Image
 
 
Comments
DMCA.com