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


 
 

Share on Google+Share on Google+

PHP SQL Fetch

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

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

Ask Questions?    Discuss: PHP SQL Fetch  

Post your Comment


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