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

Advertisement

Posted on: January 23, 2009 If you enjoyed this post then why not add us on Google+? Add us to your Circles

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.

Comments:0