How can alternating row colors be implemented in a table generated from a database query in PHP?

To implement alternating row colors in a table generated from a database query in PHP, you can use a simple conditional statement to switch between different CSS classes for each row. This can be achieved by checking if the current row number is odd or even and applying a different background color accordingly. 

```php
// Database query to fetch data
$query = "SELECT * FROM your_table";
$result = mysqli_query($connection, $query);

// Initialize row number
$row_num = 0;

// Loop through the query results and display data in a table
echo "<table>";
while($row = mysqli_fetch_assoc($result)) {
    // Alternate row colors using CSS classes
    $row_class = ($row_num % 2 == 0) ? 'even_row' : 'odd_row';
    
    echo "<tr class='$row_class'>";
    echo "<td>" . $row['column1'] . "</td>";
    echo "<td>" . $row['column2'] . "</td>";
    // Add more columns as needed
    echo "</tr>";
    
    $row_num++;
}
echo "</table>";
```
In the above code snippet, we use the `$row_num` variable to keep track of the current row number. We then use a ternary operator to assign a CSS class (`even_row` or `odd_row`) based on whether the row number is even or odd. Finally, we apply this CSS class to each `<tr>` element in the table to achieve alternating row colors.

Keywords

PHP database query table alternating row colors implementation

Related Questions