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



Home Sql Mysql-example PHP SQL close connection

Related Tutorials


 
 

Share on Google+Share on Google+

PHP SQL close connection

Advertisement
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
1komal
2ajay
3santosh
4rakesh

Connection closed
Advertisement

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 24, 2009

Related Tutorials

Discuss: PHP SQL close connection  

Post your Comment


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