How can PHP be effectively used to create collapsible menus from database outputs?

To create collapsible menus from database outputs using PHP, you can retrieve the menu items from the database and dynamically generate the HTML code for the collapsible menu structure. You can use JavaScript or CSS to add the collapsible functionality to the menu items. By combining PHP with front-end technologies, you can create interactive and dynamic collapsible menus based on database data.

<?php
// Assuming you have a database connection established

// Retrieve menu items from the database
$query = "SELECT * FROM menu_items";
$result = mysqli_query($conn, $query);

// Generate HTML code for collapsible menu
echo '<div class="menu">';
while($row = mysqli_fetch_assoc($result)) {
    echo '<button class="collapsible">' . $row['menu_name'] . '</button>';
    echo '<div class="content">';
    // Output submenu items here
    echo '</div>';
}
echo '</div>';
?>