<?php
class Extend_PDO extends PDO {

   private $fetch_mode = PDO::FETCH_ASSOC;

   function __construct($dsn, $user = NULL, $pass = NULL, $options = NULL) {
      parent::__construct($dsn, $user, $pass, $options);
   }

   function setFetchMode($fetch_mode) {
      $this->fetch_mode = $fetch_mode;
   }

   function tableStatus($table) {
      $query = 'SHOW TABLE STATUS LIKE "'.$table.'"';
      $stmt = parent::prepare($query);
      $result = $stmt->execute();
      $rtval = $stmt->fetch(PDO::FETCH_ASSOC);
      $stmt->closeCursor();
      return $rtval;
   }

   function query($sql) {
      // Not sure yet if we truly need to extend PDOStatement
      # $stmt = parent::prepare($sql, array(PDO::ATTR_STATEMENT_CLASS=>array('Extend_PDOStatement')));
      # $stmt->execute();
      $stmt = parent::query($sql);
      if($stmt) {
         $stmt->setFetchMode($this->fetch_mode);
      }
      return $stmt;
   }

}

class Extend_PDOStatement extends PDOStatement {}

?>