What are the potential benefits of using a function to retrieve menu items from a database in PHP?

Using a function to retrieve menu items from a database in PHP can provide several benefits such as code reusability, easier maintenance, and improved readability. By encapsulating the database query within a function, you can easily call it whenever you need to display the menu items without duplicating code. Additionally, any changes to the database query or logic can be made in one central location, making it easier to update and maintain. 

<?php
// Function to retrieve menu items from a database
function getMenuItems() {
    // Database connection
    $conn = new mysqli('localhost', 'username', 'password', 'dbname');
    
    // Check connection
    if ($conn->connect_error) {
        die("Connection failed: " . $conn->connect_error);
    }
    
    // Query to retrieve menu items
    $sql = "SELECT * FROM menu_items";
    $result = $conn->query($sql);
    
    // Check if there are any menu items
    if ($result->num_rows > 0) {
        // Fetch menu items as an associative array
        $menuItems = $result->fetch_all(MYSQLI_ASSOC);
        return $menuItems;
    } else {
        return array();
    }
    
    // Close database connection
    $conn->close();
}

// Example of how to use the getMenuItems function
$menuItems = getMenuItems();

// Display menu items
foreach ($menuItems as $item) {
    echo $item['name'] . "<br>";
}
?>

Keywords

PHP function database menu items benefits

Related Questions