What are some tips for improving code readability and efficiency when using PHP to sort and display grouped data from a database?

When sorting and displaying grouped data from a database in PHP, it's important to write clean and efficient code to ensure readability and performance. One tip is to use SQL queries to group and order the data directly from the database before processing it in PHP. Another tip is to use functions like `mysqli_fetch_assoc()` to fetch data row by row and then organize it into groups using associative arrays. Finally, consider using loops and conditional statements to display the grouped data in a structured and easy-to-read format. 

// Connect to the database
$connection = mysqli_connect('localhost', 'username', 'password', 'database');

// Query to fetch grouped and sorted data from the database
$query = "SELECT category, name FROM products ORDER BY category, name";
$result = mysqli_query($connection, $query);

// Initialize an empty array to store grouped data
$groupedData = array();

// Fetch data row by row and organize it into groups
while ($row = mysqli_fetch_assoc($result)) {
    $category = $row['category'];
    $name = $row['name'];
    
    $groupedData[$category][] = $name;
}

// Display the grouped data
foreach ($groupedData as $category => $products) {
    echo "<h2>$category</h2>";
    echo "<ul>";
    foreach ($products as $product) {
        echo "<li>$product</li>";
    }
    echo "</ul>";
}

// Close the database connection
mysqli_close($connection);

Keywords

PHP database sorting efficiency readability

Related Questions