How to Retrieve and Access Multiple MySQL Rows in PHP Using Nested Arrays?

Retrieving Multiple MySQL Rows in PHP Using Nested Arrays

To retrieve multiple MySQL rows and access them in PHP, you can utilize the repeated calls to the mysql_fetch_assoc() function. As specified in the PHP documentation:

mysql_fetch_assoc() retrieves the next row from the result set as an associative array. The array keys are the field names, and the array values are the corresponding field values.

To access the data from multiple rows, you can use a nested array. Here's an example:

<code class="php"><?php
// Establish database connection and execute query to select rows with number1 = 1

// Repeatedly call mysql_fetch_assoc() to retrieve each row as an associative array
while ($row = mysql_fetch_assoc($result)) {
    // Store each row in a nested array
    $multidimensionalArray[] = $row;
}

// Access data from the nested array using the following syntax:
$firstRowData = $multidimensionalArray[0];
$secondRowData = $multidimensionalArray[1];
echo $firstRowData['number2']; // Prints the number2 value for the first row
echo $secondRowData['number2']; // Prints the number2 value for the second row
?></code>

This approach allows you to iterate through the rows and access the specific data you need, even from multiple rows, using the nested array structure.

The above is the detailed content of How to Retrieve and Access Multiple MySQL Rows in PHP Using Nested Arrays?. For more information, please follow other related articles on the PHP Chinese website!