Home Sql Mysql-example PHP SQL Example
Questions:Ask|Latest


 
 

Share on Google+Share on Google+

PHP SQL Example

Advertisement
A PHP scripting block is executed on the server side, and the html result is sent to the browser.

PHP SQL Example

     

A PHP scripting  block is executed on the server side, and the html result is sent to the browser. 

Understand with Example

The Tutorial illustrate an example from PHP SQL Example. To understand and grasp the example we create a table 'stu' in Mysql that include the required fieldnames and datatypes respectively. The Table 'stu' has a Primary KeY 'id'.

 

 

 

 

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:

The insert into is used to add the records or rows 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_example.shtml:

The PHP code is executed on the server side and sent the HTML result code to the browser. Before access the database records from table 'stu', you need to establish a connection with database. The PHP code include the host, user and database from which the table 'stu'  records are retrieved. Once your connection is built, it returns the result obtain from select query in variable sql_result. The While Loop is used to execute the loop till the condition remains true. Otherwise it exists from the loop. The echo is used to print the records to the output text. To run the PHP code, the file must be saved with php extension. 

<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: January 23, 2009

Ask Questions?    Discuss: PHP SQL Example  

Post your Comment


Your Name (*) :
Your Email :
Subject (*):
Your Comment (*):
  Reload Image
 
 
Comments
bhatt
May 2, 2012
hi

Thanks...it has helped a lot.
DMCA.com