How can the modulo function in PHP be utilized to control the layout of MySQL query results displayed in multiple columns per row?

To control the layout of MySQL query results displayed in multiple columns per row, you can use the modulo (%) function in PHP to determine when to start a new row in your output. By using the modulo operator with a specific number (e.g., 3 for 3 columns per row), you can conditionally add HTML markup to start a new row after every third result. 

// Assuming $results is an array of query results from MySQL
$numColumns = 3; // Number of columns per row

echo '<div class="row">';

foreach ($results as $index => $result) {
    if ($index % $numColumns == 0 && $index > 0) {
        echo '</div><div class="row">'; // Start a new row
    }

    // Output your result data here
    echo '<div class="column">' . $result['column_name'] . '</div>';
}

echo '</div>';

Keywords

PHP modulo function MySQL query multiple columns layout control

Related Questions