/** * Run a query * * @param resource $connection DB Connection * @param string $sql * @throws Exception MySQL error */ public function __construct($sql, $connection) { parent::__construct($sql); $this->connection = $connection; $resource = mysql_query($sql, $this->connection); if (false === $resource) { $this->throwError(); } elseif (!is_bool($resource)) { $this->resource = $resource; $this->setNumberOfRows(mysql_num_rows($resource)); $this->columns = $this->getColumnTypes(); } else { $this->rowsAffected = mysql_affected_rows($this->connection); $this->lastId = mysql_insert_id($this->connection); } }
/** * Run a query * * @param string $sql * @param resource $connection DB Connection * @throws Exception MySQL error */ public function __construct($sql, $connection) { parent::__construct($sql); $this->connection = $connection; $errorMessage = ''; // Overwritten by sqlite_query $resource = sqlite_query($this->connection, $sql, SQLITE_ASSOC, $errorMessage); if (false === $resource) { throw new Exception('SQLite Error: ' . $errorMessage); } else { $this->resource = $resource; $this->setNumberOfRows(sqlite_num_rows($resource)); $this->columns = $this->getColumnTypes(); $this->rowsAffected = sqlite_changes($this->connection); $this->lastId = sqlite_last_insert_rowid($this->connection); } }
/** * Class constructor * * @param Q\DB|Q\DB_Table $source * @param mysqli_result $native The native result object or resource * @param string $statement The query statement which created this result */ function __construct($source, \mysqli_result $native, $statement) { parent::__construct($source, $native, $statement); }