Home Sql Mysql-example sql php code
Questions:Ask|Latest


 
 

Share on Google+Share on Google+

sql php code

Advertisement
SQL PHP code executes the statement using the mysql_query ( ) function. The function is used to send a query or command to a MySQL connection.

sql php code

     

SQL PHP code executes the statement using the mysql_query ( ) function. The function is used to send a query or command to a MySQL connection.

Understand with Example

The Tutorial illustrate an example from 'SQL PHP'. To understand and elaborate the example we have a PHP server scripting code that includes host, user, password and database to access the records from table 'stu' in Mysql database. Once the connection is built, PHP server side scripting is used to execute the statement of mysql_query function. The server side script retrieve the records from database and print on your supporting browser.sql_php_code.php.

 

<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());
$array = array(1,2,3,4);
foreach ($array as $value){
	$sql="Select * from stu where id =".$value;
	$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>";
	echo "</tr>";
	while($sql_row=mysql_fetch_array($sql_result)) {
		$id=$sql_row["id"];
		$name=$sql_row["name"];
		echo "<tr><td>".$id."</td>";
		echo "<td>".$name."</td>";
	}	
	echo "</table><br>";
}
?>
</body>
</html>

Output

Id Name
1 komal

Id Name
2 ajay

Id Name
3 santosh

Id Name
4 rakesh

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: sql php code  

Post your Comment


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