How to use PHP to develop simple online navigation functions-PHP Tutorial-php.cn

How to use PHP to develop simple online navigation functions

WBOY

Release： 2023-09-21 13:30:01

Original

1030 people have browsed it

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
);

Copy after login

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);
}

?>

Copy after login

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>

Copy after login

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();

?>

Copy after login

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!