PHP SQL Fetch
PHP SQL Fetch is used to fetch the records from Mysql database to PHP and
print in the form of array records in browser.
Understand with Example
The Tutorial illustrate an example from PHP SQL Fetch. To understand and
grasp the example we create a table 'stu' that include the required fieldnames
and datatypes respectively. The table 'stu' has a Primary Key 'id' that uniquely
identify the records in a table 'stu'.
Create table Stu:
CREATE TABLE `stu` (
`id` int(11) NOT NULL ,
`name` varbinary(10) default NULL,
`class` int(11) default NULL,
PRIMARY KEY (`id`)
);
|
Insert data into Stu:
Insert into is used to add the records or rows value to the table 'stu'.
INSERT INTO `stu` VALUES (1,'Ajay',12);
INSERT INTO `stu` VALUES (2,'Bhanu',12);
INSERT INTO `stu` VALUES (3,'Komal',12);
INSERT INTO `stu` VALUES (4,'Rakesh',12);
INSERT INTO `stu` VALUES (5,'Santosh',12);
INSERT INTO `stu` VALUES (6,'Tanuj',12);
|
php_sql_fetch.php:
The code below is used to fetch the records from database to server side
scripting. Before accessing the records in database, you create a
connection to the database. The While loop is used to execute the same block of
code as long as condition remains true.
<html>
<body>
<?php
$host = "localhost";
$user = "root";
$password = "root";
$database = "komal";
$connection = mysql_connect($host,$user,$password) or die("Could not connect: ".mysql_error());
mysql_select_db($database,$connection) or die("Error in selecting the database:".mysql_error());
$sql="Select * from stu";
$sql_result=mysql_query($sql,$connection) or exit("Sql Error".mysql_error());
$sql_num=mysql_num_rows($sql_result);
echo "<table width =\"20%\" bgcolor=\"#F5F5FF\">";
echo "<tr>";
echo "<td ><b>Id</b></td> <td><b>Name</b></td> <td><b>Class</b></td>";
echo "</tr>";
while($sql_row=mysql_fetch_array($sql_result))
{
$id=$sql_row["id"];
$name=$sql_row["name"];
$class=$sql_row["class"];
echo "<tr><td>".$id."</td>";
echo "<td>".$name."</td>";
echo "<td>".$class."</td></tr>";
}
echo "</table>"
?>
</body>
</html>
|
Result
| Id | Name | Class | | 1 | Ajay | 12 | | 2 | Bhanu | 12 | | 3 | Komal | 12 | | 4 | Rakesh | 12 | | 5 | Santosh | 12 | | 6 | Tanuj | 12 |
|
Del.icio.us
Digg
Google
Spurl
Blink
Furl
Simpy
Y! MyWeb
