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.

sql php code

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