Home Sql Mysql-example PHP SQL close connection

PHP SQL close connection
Posted on: January 24, 2009 at 12:00 AM

PHP SQL close connection is used to close a connection between the PHP and SQL.

PHP SQL close connection

PHP SQL close connection is used to close a connection between the PHP and SQL.

Understand with Example

The Tutorial illustrate an example from 'PHP SQL close Connection'. To understand and grasp the example we include a server side scripting code that include the usename, password, host and database to connect with the database in the backend. Once the connection is built successfully between the PHP and SQL. You can retrieve the records from SQL and send it to browser as output. The connection is closed automatically when the scripts end. To close connection we use mysql_close ( ) function.

php_sql_close_connection.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());

$sql="Select * from stu";

$sql_result=mysql_query($sql,$connection) 
	or exit("Sql Error".mysql_error());

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>";
}	s
echo "</table>";
mysql_close($connection);
echo "<br><b>Connection closed</b>";
?>
</body>
</html>

Output

Id	Name
1	komal
2	ajay
3	santosh
4	rakesh

Connection closed

Related Tags for PHP SQL close connection:
php, sql, c, io, connection, sed, close, connect, to, between, e, use, tween, os, os, cl, hp, s, ee, etw, is, and, clos, tw, s, s, th, nd, on, o

«Previous Index Next»