Latest Tutorials| Questions and Answers|Ask Questions?|Site Map




Related Tutorials


 
 

Share on Google+Share on Google+

SQL PHP

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

SQL PHP

     

SQL PHP is used to execute 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.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

If you enjoyed this post then why not add us on Google+? Add us to your Circles



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

Related Tutorials

Discuss: SQL PHP  

Post your Comment


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