本文整理汇总了PHP中mysqli::fetch方法的典型用法代码示例。如果您正苦于以下问题：PHP mysqli::fetch方法的具体用法？PHP mysqli::fetch怎么用？PHP mysqli::fetch使用的例子？那么, 这里精选的方法代码示例或许可以为您提供帮助。您也可以进一步了解该方法所在类mysqli的用法示例。
在下文中一共展示了mysqli::fetch方法的2个代码示例，这些例子默认根据受欢迎程度排序。您可以为喜欢或者感觉有用的代码点赞，您的评价将有助于系统推荐出更棒的PHP代码示例。
示例1: loadDataFromMysqliStatement
/**
* Mysqli's binding and returning of statement values
* Mysqli requires you to bind variables to the extension in order to
* get data out. These values have to be references:
*
* @see http://php.net/manual/en/mysqli-stmt.bind-result.php
* @throws Exception\RuntimeException
* @return bool
*/
protected function loadDataFromMysqliStatement()
{
$data = null;
// build the default reference based bind structure, if it does not already exist
if ($this->statementBindValues['keys'] === null) {
$this->statementBindValues['keys'] = array();
/* @var $resultResource \mysqli_result */
$resultResource = $this->resource->result_metadata();
foreach ($resultResource->fetch_fields() as $col) {
$this->statementBindValues['keys'][] = $col->name;
}
$this->statementBindValues['values'] = array_fill(0, count($this->statementBindValues['keys']), null);
$refs = array();
foreach ($this->statementBindValues['values'] as $i => &$f) {
$refs[$i] =& $f;
}
call_user_func_array(array($this->resource, 'bind_result'), $this->statementBindValues['values']);
}
if (($r = $this->resource->fetch()) === null) {
if (!$this->isBuffered) {
$this->resource->close();
}
return false;
} elseif ($r === false) {
throw new Exception\RuntimeException($this->resource->error);
}
// dereference
for ($i = 0, $count = count($this->statementBindValues['keys']); $i < $count; $i++) {
$this->currentData[$this->statementBindValues['keys'][$i]] = $this->statementBindValues['values'][$i];
}
$this->currentComplete = true;
$this->nextComplete = true;
$this->position++;
return true;
}示例2: create_table_PDO
/**
* @param mysqli $result le pasamos el resultado de la consulta de la base de datos realizada con PDO.
* @param array $col_names, array de strings que tiene como valor por defecto un array vacio, si está vacio los nombres de las columnas serán los nombres de las columnas de la base de datos, si queremos darles nombres mas representativos podemos rellenar este campo (ej['nombre','apellido','email'])
* @return string $table devuelve el string formado que contiene la tabla.
*/
function create_table_PDO($result, $col_names = array())
{
$table = '';
$rows = array();
while ($row = $result->fetch(PDO::FETCH_ASSOC)) {
array_push($rows, $row);
}
$table .= '<table>';
$table .= '<tr>';
if (count($col_names) !== 0) {
for ($i = 0; $i < count($col_names); $i++) {
$table .= '<th>' . $col_names[$i] . '</th>';
}
} else {
foreach ($rows as $row) {
$count = 0;
foreach ($row as $key => $value) {
$table .= ' <th>' . $key . '</th>';
if ($count > count($row)) {
break;
}
$count++;
}
break;
}
}
$table .= '</tr>';
foreach ($rows as $row) {
$table .= '<tr>';
foreach ($row as $key => $value) {
$table .= ' <td>' . $value . '</td>';
}
$table .= '</tr>';
}
$table .= '</table>';
return $table;
}