How to use PHP to develop website navigation menu function

How to use PHP to develop website navigation menu function

The navigation menu is a very important part of website development, it can help users quickly navigate to various pages of the website. In PHP development, you can implement a simple yet powerful website navigation menu by writing code. This article will introduce how to use PHP to develop website navigation menu functions and provide code examples.

1. Create a database table

First, we need to create a database table to store the data of the navigation menu. You can use the following SQL statement to create a table named "navigation":

CREATE TABLE navigation (

id INT AUTO_INCREMENT PRIMARY KEY,
title VARCHAR(255) NOT NULL,
url VARCHAR(255) NOT NULL,
parent_id INT DEFAULT 0

);

This table contains four fields: id, title , url and parent_id. The id field is the primary key, and the AUTO_INCREMENT attribute is used to ensure that each record has a unique identifier. The title field is used to store the title of the navigation menu, the url field is used to store the link address of the navigation menu, and the parent_id field is used to store the parent menu ID of the navigation menu. If there is no parent menu, the default value 0 is used.

2. Add menu data

Next, we need to add menu data to the navigation table. You can use the following SQL statement to add some sample data:

INSERT INTO navigation (title, url) VALUES

('首页', '/'),
('新闻', '/news'),
('产品', '/products'),
('关于我们', '/about'),
('联系我们', '/contact');

These sample data include five menu items, namely "Home", "News" ", "Products", "About Us" and "Contact Us", each menu item has a corresponding title and link address.

3. Display the navigation menu

Next, we need to write PHP code to display the navigation menu. You can use the following code example:

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

// Query menu data
$result = mysqli_query($connection, 'SELECT * FROM navigation ORDER BY id');

// Process menu data
$menus = array( );
while ($row = mysqli_fetch_assoc($result)) {

$menus[$row['id']] = array(
    'title' => $row['title'],
    'url' => $row['url'],
    'parent_id' => $row['parent_id']
);

}

// Recursively generate navigation menu
function createMenu($parent_id, $menus) {

$html = '<ul>';
foreach ($menus as $menu) {
    if ($menu['parent_id'] == $parent_id) {
        $html .= '<li><a href="' . $menu['url'] . '">' . $menu['title'] . '</a>';
        $html .= createMenu($menu['id'], $menus);
        $html .= '</li>';
    }
}
$html .= '</ul>';
return $html;

}

//Display navigation menu
echo createMenu(0, $menus);

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

This code first connects to the database, then queries all menu data in the navigation table and processes it into a nested array. Next, use the recursive function createMenu to recursively generate the HTML code for the navigation menu. Finally, the generated navigation menu is displayed on the page.

Through the above steps, we can use PHP to develop a simple and powerful website navigation menu. Using a database to store menu data and using PHP code to dynamically generate navigation menus can improve the maintainability and scalability of the website. Hope this article is helpful to you!

The above is the detailed content of How to use PHP to develop website navigation menu function. For more information, please follow other related articles on the PHP Chinese website!