mysqli_result::fetch_array -- mysqli_fetch_array — Fetch a result row as an associative（关联数组）, a numeric array（索引数组）, or both
面向对象风格
[mixed]mysqli_result::fetch_array ([ int $resulttype
= MYSQLI_BOTH ] )
过程化风格
[mixed]mysqli_fetch_array ( mysqli_result $result
[, int $resulttype
= MYSQLI_BOTH ] )
Returns an array that corresponds to the fetched row or **NULL
** if there are no more rows for the resultset represented by the result
parameter.
mysqli_fetch_array() is an extended version of the mysqli_fetch_row() function. In addition to storing the data in the numeric indices of the result array, the mysqli_fetch_array() function can also store the data in associative indices, using the field names of the result set as keys.
例子：
<?php
$mysql = new mysqli('localhost','root','root','magicsuggest', 3306);
$result = $mysql->query("select * from countries");
while($row = $result->fetch_array(MYSQL_ASSOC)) {
?>
<div class="checkbox">
<label>
<input type="checkbox" name="countries[]" value="<?php echo $row['idCountry']?>">
<img src="<?php echo 'img/flags/png/' . strtolower($row['countryCode']) . '.png' ?>" />
<?php echo $row['countryName'] .' ' . $row['population'] . ' ' . $row['capital'] . ' ' . $row['continentName']; ?>
</label>
</div>
<?php
}
$result->close();
$mysql->close();
?>
