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.

PHP SQL Fetch

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
1Ajay12
2Bhanu12
3Komal12
4Rakesh12
5Santosh12
6Tanuj12