note 54123 added to function.mysql-query

From: 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

« previous php.notes (#90887) next »