Home > Article > Backend Development > How to use PHP to develop simple online navigation functions
How to use PHP to develop simple online navigation functions
Navigation websites are very common in modern society. They help users quickly find the information they need and provide quick links. to other useful websites. Using PHP to develop simple online navigation functions can help us build a customizable and easy-to-maintain navigation website. This article will introduce how to use PHP to write a simple online navigation website and provide specific code examples.
Step 1: Create a database table
First, we need to create a database to store navigation links. Create a database named "navigation" in MySQL, and then create a table named "links" in the database. The table should contain the following fields: id (auto-incrementing primary key), title (link title), url (link address), order (sort).
CREATE DATABASE navigation; USE navigation; CREATE TABLE links ( id INT PRIMARY KEY AUTO_INCREMENT, title VARCHAR(50) NOT NULL, url VARCHAR(100) NOT NULL, order INT NOT NULL );
Step 2: Connect to the database
At the beginning of the PHP file, we need to connect to the database. Create a file called "db_connect.php" and add the following code:
<?php $servername = "localhost"; $username = "root"; $password = "password"; $dbname = "navigation"; $conn = new mysqli($servername, $username, $password, $dbname); if ($conn->connect_error) { die("Connection failed: " . $conn->connect_error); } ?>
Make sure to change "root" and "password" to your database username and password.
Step 3: Add a link to the database
Now we can write a form to add a new link to the database. Create a file called "add_link.php" and add the following code:
<?php include 'db_connect.php'; if ($_SERVER["REQUEST_METHOD"] == "POST") { $title = $_POST["title"]; $url = $_POST["url"]; $order = $_POST["order"]; $sql = "INSERT INTO links (title, url, order) VALUES ('$title', '$url', '$order')"; if ($conn->query($sql) === TRUE) { echo "Link added successfully"; } else { echo "Error adding link: " . $conn->error; } } $conn->close(); ?> <!DOCTYPE html> <html> <head> <title>Add Link</title> </head> <body> <form method="post" action="<?php echo htmlspecialchars($_SERVER["PHP_SELF"]);?>"> Title: <input type="text" name="title" required><br> URL: <input type="text" name="url" required><br> Order: <input type="number" name="order" required><br> <input type="submit" value="Add Link"> </form> </body> </html>
This file will create a form where the user can enter the link's title, URL, and sequence number. When the user submits the form, a new link record is added to the database.
Step 4: Display the linked list
Finally, we need to write a file to display the linked list in the database. Create a file called "index.php" and add the following code:
<?php include 'db_connect.php'; $sql = "SELECT * FROM links ORDER BY order"; $result = $conn->query($sql); if ($result->num_rows > 0) { while($row = $result->fetch_assoc()) { echo "<a href='" . $row["url"] . "'>" . $row["title"] . "</a><br>"; } } else { echo "No links found"; } $conn->close(); ?>
This file will retrieve all links from the database and display them as a list of hyperlinks.
After completing the above steps, you can organize these files into a folder and upload them to your web server. When users visit "index.php" they will see a list of all links in the database. Users can also add new links by visiting "add_link.php".
During development, you can extend and customize the code according to your needs. You can add the ability to edit and delete links, or design a prettier interface. By developing in PHP, you can easily extend and maintain this simple online navigation functionality.
The above is the detailed content of How to use PHP to develop simple online navigation functions. For more information, please follow other related articles on the PHP Chinese website!