Home Sql Mysql-example PHP SQL Die

PHP SQL Die
Posted on: January 23, 2009 at 12:00 AM

PHP SQL Die results when there is a connection failure. The die( ) function prints a message and exists from the current script.

PHP SQL Die

PHP SQL Die results when there is a connection failure. The die( ) function prints a message and exists from the current script.

Understand with Example

The Tutorial illustrate an example from 'PHP SQL Die'. To understand and grasp the example we create a table 'stu' that has required fieldnames and datatypes respectively.

Create table Stu:

CREATE TABLE `stu` (                     
          `id` int(11) NOT NULL ,  
          `name` varbinary(10) default NULL,     
          `class` int(11) default NULL,          
          PRIMARY KEY  (`id`)                    
        );

Insert data into Stu:

The insert into is used to add the records or rows to the table 'Stu'.

INSERT INTO `stu` VALUES (1,'Ajay',12);
INSERT INTO `stu` VALUES (2,'Bhanu',12);
INSERT INTO `stu` VALUES (3,'Komal',12);
INSERT INTO `stu` VALUES (4,'Rakesh',12);
INSERT INTO `stu` VALUES (5,'Santosh',12);
INSERT INTO `stu` VALUES (6,'Tanuj',12);

php_sql_group_by.php:

The PHP code include server side scripting that include the host, user, password and database. The mysql_connect accept the host, user and password that result in the connection between the database and PHP on the server side. The Mysql php die function prints a user defined message when there is a connection failure. The die ( ) prints a message and exists from the current page.

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

$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> <td><b>Class</b></td>";
echo "</tr>";
while($sql_row=mysql_fetch_array($sql_result))
{
	$id=$sql_row["id"];
	$name=$sql_row["name"];
	$class=$sql_row["class"];

	echo "<tr><td>".$id."</td>";
	echo "<td>".$name."</td>";
	echo "<td>".$class."</td></tr>";
}	
echo "</table>"
?>
</body>
</html>

Result

Id	Name	Class
1	Ajay	12
2	Bhanu	12
3	Komal	12
4	Rakesh	12
5	Santosh	12
6	Tanuj	12

Related Tags for PHP SQL Die:
php, sql, c, function, script, fun, io, connection, print, ip, int, message, ai, connect, ie, unc, exists, results, failure, e, il, ul, result, from, current, in, m, nt, sage, es, sts, func, age, me, hp, when, s, su, ssa, ess, is, lts, and, sa, xi, scr, s, s, ri, rip, ren, th, st, exi, pr, nd, on, om, o

«Previous Index Next»