/**
* Internal method to fetch the next row from the result set
*
* @return array|null
*/
protected function getNextRow()
{
# If the result resource is invalid then don't bother trying to fetch
if (!$this->result) {
return;
}
switch ($this->mode) {
case "mysql":
$row = $this->result->fetch_assoc();
break;
case "postgres":
case "redshift":
$row = pg_fetch_assoc($this->result);
break;
case "odbc":
$row = odbc_fetch_array($this->result, $this->position + 1);
break;
case "sqlite":
$row = $this->result->fetchArray(SQLITE3_ASSOC);
break;
case "mssql":
$row = mssql_fetch_assoc($this->result);
break;
}
# If the fetch fails then there are no rows left to retrieve
if (!$row) {
return;
}
$this->position++;
return $row;
}
/**
* {@inheritdoc}
*/
public function nextRecord()
{
if (is_object($this->handle) && ($data = $this->handle->fetch_assoc())) {
return $data;
} else {
return false;
}
}
/**
* Get the nextRecord from the query.
* @param string $result_type
* @return resource
*/
public function nextRecord($result_type = "both")
{
if (!$this->query_id) {
$this->halt("next_record() called with no pending query.");
return false;
}
if ($this->db_type == "mysqli") {
switch ($result_type) {
case "assoc":
$this->record = $this->query_id->fetch_assoc();
break;
case "num":
$this->record = $this->query_id->fetch_fetch_row();
break;
case "both":
$this->record = $this->query_id->fetch_array();
break;
}
} else {
if ($this->db_type == "mysql") {
switch ($result_type) {
case "assoc":
$this->record = mysql_fetch_assoc($this->query_id);
break;
case "num":
$this->record = mysql_fetch_row($this->query_id);
break;
case "both":
$this->record = mysql_fetch_array($this->query_id);
break;
}
}
}
if ($this->db_type == "mysqli") {
$this->errno = $this->link_id->errno;
$this->error = $this->link_id->error;
} else {
if ($this->db_type == "mysql") {
$this->errno = mysql_errno($this->link_id);
$this->error = mysql_error($this->link_id);
}
}
$status = is_array($this->record);
if (!$status && $this->auto_free) {
$this->freeResult();
}
return $status;
}
/**
* Fetch a result row as an associative array.
*
* @param resource $query
* The result resource that is being evaluated. This result comes from a call to mysql_query().
* @return array
* Returns an associative array that corresponds to the fetched row and moves the internal data pointer ahead.
*/
function fetch_assoc($query)
{
if ($query instanceof mysqli_result) {
return $query->fetch_assoc();
}
return FALSE;
}
/**
* Gets an associative array from a SQL result (as returned by Database::query).
* This method is equivalent to calling Database::fetch_array() with 'ASSOC' value for the optional second parameter.
* @param resource $result The result from a call to sql_query (e.g. Database::query).
* @return array Returns an associative array that corresponds to the fetched row and moves the internal data pointer ahead.
*/
public static function fetch_assoc($result)
{
return $result->fetch_assoc();
}
/**
* Fetches a record from the database using the given result resource.
*
* @param resource $resultCursor The result resource returned by executeStatement() or executeTextStatement().
* @param int $type The type the returned data should have. Use the static *_FETCH_MODE constants.
*
* @return string[] The associative result array. Returns false if no row was found.
*
* @author Christian Achatz
* @version
* Version 0.1, 09.03.2010<br />
* Version 0.2, 30.07.2010 (Changed return value to false if no row was found, in order to follow the interface definition)<br />
* Version 0.3, 08.08.2010 (Added optional second parameter) <br />
*/
public function fetchData($resultCursor, $type = self::ASSOC_FETCH_MODE)
{
if ($resultCursor == null) {
return false;
}
if ($type === self::ASSOC_FETCH_MODE) {
$return = $resultCursor->fetch_assoc();
} elseif ($type === self::OBJECT_FETCH_MODE) {
$return = $resultCursor->fetch_object();
} else {
$return = $resultCursor->fetch_row();
}
if ($return === null) {
return false;
}
return $return;
}
/**
* Fetch an array from a database result set
*
* @param resource $res
* @return array
*/
protected function _fetch($res)
{
return $res->fetch_assoc();
// $res->fetch_assoc();
}
/**
* Return reference to next row in result set.
* @param mysqli_result|resource|PDOStatement $result
* @return array
*/
public function nextRow($result)
{
return $result->fetch_assoc();
}
/**
* 针对query和execute的结果,进行数组话输出
*
* 仅对select查询有效
*
* @param resource $result
*
* @return array
*/
public function fetchAll($result)
{
$ret = array();
while ($row = $result->fetch_assoc()) {
$ret[] = $row;
}
return $ret;
}
/**
* The result set setter
*
* @access public
* @param resource $rs A valid MySQLi result resource identifier
*/
public function setResult($rs = false)
{
// A result identifier is a must have
if (empty($rs)) {
return false;
}
// Get multiple result sets from the MySQL query result if we can
$recordSet = array();
while ($row = $rs->fetch_assoc()) {
$recordSet[] = $row;
}
// Add the record sets into the result set
$this->_resultSet[] = $recordSet;
}
/**
* Devolvemos el array con los datos de la consulta
* @param string $field Campo objetivo.
* @param string $default Valor a retornar si el campo no existe o está vacío.
* @return array|string Todos los campos o sólo uno
*/
public function fetch($field = null, $default = null)
{
$this->result = $this->data->fetch_assoc();
if ($field !== null) {
return isset($this->result[$field]) ? $this->result[$field] : $default;
} else {
return $this->result;
}
}
