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