SQL Error handling

[siri_suresh]

Hi All,

Can i have a error handling of database like in java using php. If so how can i handle?
Thanks in advance.

Suresh.

[matto]

there's no try - catch in php 🙁

the db functions usually return false on error, you can handle that. see db functions reference. (with oracle it's a hassle, but I assume you'll use mysql.)

besides, you can suppress error messages using the @ in front of functions you call. that's no error handling, though.

[van__]

yes there is a mysql error catch in PHP.
it's a simple function called mysql_error()
I use it like so:

$this->result = @($stmt, $this->linkID) or $this->onError(mysql_error());

which then sends me a lovely email rather than popping some ungodly message with happy DB query info for others to see.

[siri_suresh]

Hi Matto,

Thanks a lot.
I am using ORACLE. Can u suggist error handling with oracle? Can i get the exact error by returning-information from db function?

Thanks
Suresh.