What are common methods for implementing database query results into an array in PHP?

When retrieving data from a database using PHP, it is common to store the results in an array for easier manipulation and display. One common method for implementing database query results into an array is to loop through the results and push each row into the array. Another method is to use PHP's fetch functions to fetch rows from the result set and store them in an array.

// Assuming $conn is the database connection and $query is the SQL query
$result = mysqli_query($conn, $query);

// Method 1: Loop through the results and push each row into an array
$data = array();
while ($row = mysqli_fetch_assoc($result)) {
    $data[] = $row;
}

// Method 2: Use fetch functions to store rows in an array
$data = mysqli_fetch_all($result, MYSQLI_ASSOC);