/**
* 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);
}
