   #PHP Manual Improved MySQL Extension mysqli_execute mysqli_fetch_assoc

   PHP Manual
   Prev  Next
   ______________________________________________________________________

                              mysqli_fetch_array

   (PHP 5 CVS only)
   mysqli_fetch_array -- Fetch a result row as an associative, a numeric
   array, or both.

Description

   array mysqli_fetch_array ( resource result [, int resulttype])

   Returns an array that corresponds to the fetched row or FALSE if there
   are no more rows for the database connection represented by the link
   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.

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

   If two or more columns of the result have the same field names, the
   last column will take precedence and overwrite the earlier data. In
   order to access multiple columns with the same name, the numerically
   indexed version of the row must be used.

   The optional second argument result_type is a constant indicating what
   type of array should be produced from the current row data. The
   possible values for this parameter are the constants MYSQLI_ASSOC,
   MYSQLI_NUM, or MYSQLI_BOTH. By default the mysqli_fetch_array()
   function will assume MYSQLI_BOTH for this parameter.

   By using the MYSQLI_ASSOC constant this function will behave
   identically to the mysqli_fetch_assoc(), while MYSQLI_NUM will behave
   identically to the mysqli_fetch_row() function. The final option
   MYSQLI_BOTH will create a single array with the attributes of both.

   Example 1. mysqli_fetch_array with MYSQLI_NUM
   <?php
       mysqli_connect("localhost", "mysql_user", "mysql_password") or
           die("Could not connect: " . mysqli_error());
       mysqli_select_db("mydb");
       $result = mysqli_query("SELECT id, name FROM mytable");
       while ($row = mysqli_fetch_array($result, MYSQLI_NUM)) {
           printf("ID: %s  Name: %s", $row[0], $row[1]);
       }
       mysqli_free_result($result);
   ?>

   Example 2. mysqli_fetch_array with MYSQLI_ASSOC
   <?php
       mysqli_connect("localhost", "mysql_user", "mysql_password") or
           die("Could not connect: " . mysqli_error());
       mysqli_select_db("mydb");
       $result = mysqli_query("SELECT id, name FROM mytable");
       while ($row = mysqli_fetch_array($result, MYSQLI_ASSOC)) {
           printf ("ID: %s  Name: %s", $row["id"], $row["name"]);
       }
       mysqli_free_result($result);
   ?>

   Example 3. mysqli_fetch_array with MYSQLI_BOTH
   <?php
       mysqli_connect("localhost", "mysql_user", "mysql_password") or
           die("Could not connect: " . mysqli_error());
       mysqli_select_db("mydb");
       $result = mysqli_query("SELECT id, name FROM mytable");
       while ($row = mysqli_fetch_array($result, MYSQLI_BOTH)) {
           printf ("ID: %s  Name: %s", $row[0], $row["name"]);
       }
       mysqli_free_result($result);
   ?>

   See also mysqli_fetch_assoc(), mysqli_fetch_row() and
   mysqli_fetch_object().
   ______________________________________________________________________

   Prev           Home               Next
   mysqli_execute  Up  mysqli_fetch_assoc
