php - error handling

[sateeshsv]

how to handle error in php.

for example: i am executing a query "select * from emp". suppose the table "emp" is not found in database error rises. how to handle the error and display a valid message.

[Anon]

You could get some ideas reading the manuals, and after that is said, the example for mysql "mysql_error()" could come in handy...

[ashbai]

the value of the query is $q as examlpe ..

u can say then :

if (!$q){
echo("<p> ... and type here the message u like to have ... </p>");
exit();
}

place it after the query

[Anon]

u can use mysql_errno() or mysql_error() to dispaly your error messages.
If u want to disply customised message u can follow as mr. Baroudi response.

Hope it will helpful for u.

[sgbalsekar]

hi,

try using the @ symbol as a prefix to the statement that u feel like may produce errors...

@statement;

this doesnt show the errors...also theres a provision in php.ini file am not too sure about it..which can hide errors...

regarding handling of errors is concerned,u cud get some help from this,

<?php
mysql_connect("marliesle");
echo mysql_errno().": ".mysql_error()."<BR>";
mysql_select_db("nonexistentdb");
echo mysql_errno().": ".mysql_error()."<BR>";
$conn = mysql_query("SELECT * FROM nonexistenttable");
echo mysql_errno().": ".mysql_error()."<BR>";
?>

this is from php manual....so just refer it..

regs,
sgb.