How can PHP be used to automatically update a menu based on database entries?

To automatically update a menu based on database entries in PHP, you can retrieve the menu items from the database and dynamically generate the menu using PHP code. This way, any changes in the database will automatically reflect in the menu without the need for manual updates. 

<?php
// Connect to the database
$servername = "localhost";
$username = "username";
$password = "password";
$dbname = "menu_db";

$conn = new mysqli($servername, $username, $password, $dbname);

// Check connection
if ($conn->connect_error) {
    die("Connection failed: " . $conn->connect_error);
}

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

// Generate the menu dynamically
echo "<ul>";
if ($result->num_rows > 0) {
    while($row = $result->fetch_assoc()) {
        echo "<li><a href='" . $row["url"] . "'>" . $row["name"] . "</a></li>";
    }
} else {
    echo "0 results";
}
echo "</ul>";

$conn->close();
?>

Keywords

PHP database menu automatic update entries

Related Questions