PHP mysqli_fetch_array()Function

PHP MySQLi 参考手册PHP MySQLi Reference Manual

Fetch a row from a result set as a numeric array or an associative array:

mysqli_fetch_array()

<?php //Assume database username: root, password: 123456, database: EXAMPLE $con=mysqli_connect("localhost","root","123456","EXAMPLE"); if (mysqli_connect_errno($con)) { echo "Connection to MySQL failed:" . mysqli_connect_error(); } $sql="SELECT name,url FROM websites ORDER BY alexa"; $result=mysqli_query($con,$sql); //Numeric array $row=mysqli_fetch_array($result,MYSQLI_NUM); printf ("%s : %s",$row[0],$row[1]); //Associative array $row=mysqli_fetch_array($result,MYSQLI_ASSOC); printf ("%s : %s",$row["name"],$row["url"]); //Free result set mysqli_free_result($result); mysqli_close($con); ?>

Definition and Usage

The mysqli_fetch_array() function fetches a row from a result set as an associative array, a numeric array, or both.

Note:The field names returned by this function are case-sensitive.

Syntax

mysqli_fetch_array(result,resulttype);

Parameters Description
result Required. Specifies the result set identifier returned by mysqli_query(), mysqli_store_result(), or mysqli_use_result().
resulttype Optional. Specifies which type of array should be produced. Can be one of the following values:
  • MYSQLI_ASSOC
  • MYSQLI_NUM
  • MYSQLI_BOTH

Technical Details

Return value: Returns an array of strings that corresponds to the fetched row. Returns NULL if there are no more rows in the result set.
PHP Version: 5+

PHP MySQLi 参考手册PHP MySQLi Reference Manual Other Extensions