How can a flexible menu be created in PHP that retrieves entries from a MySQL table?

To create a flexible menu in PHP that retrieves entries from a MySQL table, you can query the database to fetch the menu items and dynamically generate the menu using a loop. This allows you to easily update the menu items in the database without having to modify the code. 

<?php
// Connect to MySQL database
$connection = mysqli_connect("localhost", "username", "password", "database");

// Check connection
if (!$connection) {
    die("Connection failed: " . mysqli_connect_error());
}

// Query to retrieve menu items from database
$sql = "SELECT * FROM menu_items";
$result = mysqli_query($connection, $sql);

// Generate menu items dynamically
echo '<ul>';
while ($row = mysqli_fetch_assoc($result)) {
    echo '<li><a href="' . $row['link'] . '">' . $row['name'] . '</a></li>';
}
echo '</ul>';

// Close connection
mysqli_close($connection);
?>

Keywords

PHP MySQL menu flexible retrieval

Related Questions