| Bastien Koert 2004-12-24, 3:55 pm |
| function db_get_member_data($dbh, $member_id) {
$stmnt = "SELECT * FROM Member WHERE MEM_MEM_ID='" . $member_id . "'";
$sthdl = ibase_query($stmnt,$dbh);
if ( ibase_errcode != 0 ){
//call some function to tell the user there is an error
}else{
return $sthdl;
}//end if
}
bastien
>From: Todd Cary <todd@aristesoftware.com>
>To: php-db@lists.php.net
>Subject: [PHP-DB] Handling DB query errors
>Date: Fri, 24 Dec 2004 08:40:40 -0800
>
>I am not sure about how to properly handle DB Query errors. Here is a
>typical query where the possible is NOT handled. Any suggestions are
>welcomed e.g. how to code the query; how to have an error page; how to
>handle errors produced by the Interbase server.
>
> /* Get member data */
> function db_get_member_data($dbh, $member_id) {
> $stmnt = "SELECT * FROM Member WHERE MEM_MEM_ID='" . $member_id . "'";
> $sthdl = ibase_query($stmnt,$dbh);
> return $sthdl;
> }
>
>Todd
>--
>
>--
>PHP Database Mailing List (http://www.php.net/)
>To unsubscribe, visit: http://www.php.net/unsub.php
>
|