public function __construct($host, $user, $password, $database = "mysqlslideshow", $table = "mysqlslideshow")
 {
     $database = is_null($database) ? 'mysqlslideshow' : $database;
     $table = is_null($table) ? 'mysqlslideshow' : $table;
     $this->table = $table;
     // Call the Database constructor
     parent::__construct($host, $user, $password, $database);
     // open the database
 }
 /**
  * query()
  * Query database table
  * @param string $query SQL statement.
  * @return mixed result-set for select etc, true/false for insert etc.
  * On error calls SqlError() and exits.
  */
 public function query($query)
 {
     $db = $this->opendb();
     self::$lastQuery = $query;
     // for debugging
     $result = $db->query($query);
     if ($result === false) {
         throw new SqlException($query, $this);
     }
     if ($result === true) {
         // did not return a result object
         $numrows = $db->affected_rows;
         self::$lastNonSelectResult = $result;
     } else {
         // NOTE: we don't change result for inserts etc. only for selects etc.
         $this->result = $result;
         $numrows = $result->num_rows;
     }
     return $numrows;
 }