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:
|
Del.icio.us
Digg
Google
Spurl
Blink
Furl
Simpy
Y! MyWeb
