note 54123 added to function.mysql-query
| From: | ek2 at ek2 dot org | Date: | Fri, 24 Jun 2005 11:36:10 +0000 |
| Subject: | note 54123 added to function.mysql-query | ||
| Groups: | php.notes | ||
| Request: | Send a blank email to php-notes+get-90887@lists.php.net to get a copy of this message | ||
Hi!
I use a small wrapper-function that adds some error-reporting capabilities to mysql_query(). If you
add these, reportError() will be called upon each failed query. By modifying reportError, you may
easily add powerful logging capabilities to your script (or just get rid of putting echo
mysql_error(); behind each query for debugging purposes ;) ).
Using it is fairly easy - just replace each occurence of "mysql_query ($myquery);" with
"extendedMysqlQuery ($myquery);".
<?php
function reportError ( $error, $debugLevel=0 ) {
echo "<br>" . $error . "<br>";
}
function extendedMysqlQuery ( $query ) {
$result = mysql_query ( $query );
if ( $result === false ) {
reportError ( "MySQL-Error:\n" . mysql_error() . "\nQuery:\n$query", 0 )
return false;
}
else return $result;
}
?>
----
Manual Page -- http://www.php.net/manual/en/function.mysql-query.php
Edit -- http://master.php.net/manage/user-notes.php?action=edit+54123
Delete: added to the manual -- http://master.php.net/manage/user-notes.php?action=delete+54123&report=yes&reason=added+to+the+manual
Delete: bad code -- http://master.php.net/manage/user-notes.php?action=delete+54123&report=yes&reason=bad+code
Delete: spam -- http://master.php.net/manage/user-notes.php?action=delete+54123&report=yes&reason=spam
Delete: useless -- http://master.php.net/manage/user-notes.php?action=delete+54123&report=yes&reason=useless
Delete: non-english -- http://master.php.net/manage/user-notes.php?action=delete+54123&report=yes&reason=non-english
Delete: other reasons -- http://master.php.net/manage/user-notes.php?action=delete+54123&report=yes
Reject -- http://master.php.net/manage/user-notes.php?action=reject+54123&report=yes
Search -- http://master.php.net/manage/user-notes.php