lib/class.debugmysqli.php

   1 <?php
   2 /**
   3  * Debug MySQLi class
   4  *
   5  * @author Anthony Parsons (xmpp:ant@specialops.ath.cx)
   6  * @license file://../COPYING
   7  * @version $Id$
   8  */
   9 class debugmysqli extends so2mysqli
  10 {
  11         public $c; // query counter
  12         private $d = false; // debug next query flag
  13
  14         public function query($q)
  15         {
  16                 if ( $this->d ) {
  17                         mysqli_report(MYSQLI_REPORT_ALL);
  18                 }
  19
  20                 $result = parent::query($q);
  21
  22                 if ( $this->error ) {
  23                         throw new RuntimeException("MySQLi query() error!\n".$this->error."\nQuery given was: \n".$q, E_USER_ERROR);
  24                 }
  25
  26                 if ( $this->warning_count ) {
  27                         $result2 = $this->query('SHOW WARNINGS');
  28                         $out = '';
  29
  30                         while ( $row = $result2->fetch_row() ) {
  31                                 $out .= vsprintf("%s #%s: %s\n", $row);
  32                         }
  33
  34                         throw new RuntimeException("MySQLi query() warning(s)\n".$out."\nQuery given was: \n".$q, E_USER_WARNING);
  35                 }
  36
  37                 $this->c++;
  38
  39                 if ( $this->d ) {
  40                         $this->d = false;
  41                         mysqli_report(MYSQLI_REPORT_OFF);
  42                 }
  43
  44                 return $result;
  45         }
  46
  47         public function prepare($q)
  48         {
  49                 $result = parent::prepare($q);
  50
  51                 if ( $this->error ) {
  52                         throw new RuntimeException("MySQLi prepare() error\n".$this->error."\nQuery given was: \n".$q, E_USER_ERROR);
  53                 }
  54
  55                 $this->c++;
  56
  57                 return $result;
  58         }
  59
  60         public function debugnext()
  61         {
  62                 $this->d = true;
  63         }
  64 }
  65
  66 /**
  67  * Make sure mysqli_report setting doesn't linger across requests
  68  */
  69 register_shutdown_function('mysqli_report', MYSQLI_REPORT_OFF);
  70 ?>