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

SQL PHP

SQL PHP

SQL PHP

Tutorials