Error handling

Sometimes your PHP-script won't work due to a sql meltdown. If this happens it won't output the error but rather just die. Enter mysql_error().

This function will come in handy when you want the error outputted either directly on your screen or to a textfile.

The mysql_error() function has a best friend, mysql_errno() that gives you the correct number for the error.

PHP.NET

http://www.php.net/mysql_error

Syntax:

string mysql_error ([ resource $link_identifier ] )
string mysql_errno ([ resource $link_identifier ] )

Example:

<?php

//Create a connection

$link = mysql_connect("localhost", "username", "password");

//Select database

mysql_select_db("examples", $link);

//Create a query

$sql = "SELECT * FOM Person"; //Faulty query....

//Execute the query

$result = mysql_query($sql, $link);



if($result)

{

	//If correct, do something here...

	echo "The query worked!!!";

}

else

{

	//If the query was unsucceful, we will output the error

	echo "<b>Error ".mysql_errno($link).":</b> ".mysql_error($link);

}

//Close the connection

mysql_close($link);

?>

Output:

Error 1064: You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'FOM Person' at line 1

Since the query sent in was faulty(FOM instead of FROM) we now get the error-output that first tells us which number the error has, 1064, then the reason for this error. If you want to look into the error even more go here to see a list of all mysql errors..

It's as simple as that.

There are no comments on this article.

Leave a message!

If you have any question or just want to leave a message, just fill out the form below!

Your e-mail will not be visible in your post, it is for validation reasons only

Name:
E-mail:
Comment: