How can I retrieve and process multiple rows from a MySQL database in PHP?

Retrieving Multiple MySQL Rows for PHP Processing

When dealing with relational databases like MySQL, it's often necessary to retrieve multiple records in a single query. This can be achieved through a simple but effective method using mysql_fetch_assoc() in PHP.

Selecting Multiple Rows

The first step involves selecting the desired rows from your database. For instance, if you have a table with columns number1 and number2, and you wish to select all rows where number1 equals 1, you would use the following query:

<code class="sql">SELECT * FROM table_name WHERE number1 = 1;</code>

Iterating Over Results

Once you have executed the query, use mysql_fetch_assoc() to iterate over the results. This function retrieves the next row from the query result and returns it as an associative array, where column names are the array keys.

<code class="php">$result = mysql_query($query);
while ($row = mysql_fetch_assoc($result)) {
    // Process the row here
}</code>

Creating Dynamic Arrays

To store multiple rows in an easily navigable structure, consider creating a multidimensional array using the while loop mentioned above. This allows you to access the rows by their index within the array.

<code class="php">$rows = array();
while ($row = mysql_fetch_assoc($result)) {
    array_push($rows, $row);
}

// Get the second row
$row2 = $rows[1];</code>

Conclusion

By leveraging repeated calls to mysql_fetch_assoc(), PHP developers can efficiently retrieve multiple rows from MySQL and store them in convenient array structures for further processing. This technique provides an easy and flexible way to work with relational data in your PHP applications.

The above is the detailed content of How can I retrieve and process multiple rows from a MySQL database in PHP?. For more information, please follow other related articles on the PHP Chinese website!