PHP Development Guide: Implementing Simple Friends Link Function-Mysql Tutorial-php.cn

PHP Development Guide: Implementing Simple Friends Link Function

WBOY

Release： 2023-07-03 17:33:10

Original

943 people have browsed it

PHP Development Guide: Implementing a simple friendly link function

Friendly links are a common function of websites. Through friendly links, mutual recommendations and mutual friendship relationships can be established with other websites, increasing the traffic and users of the website. Conversion rate. In this article, we will introduce how to use PHP to develop a simple friendly link function.

Create database table
First, we need to create a table in the database to store friendly link information. You can use the following SQL statement to create a table structure:

CREATE TABLE `links` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `name` varchar(255) NOT NULL,
  `url` varchar(255) NOT NULL,
  `description` text,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

Copy after login

In this table, we define four fields: id (link ID), name (link name), url (link address), description (link description). You can add or modify fields according to actual needs.

Create a link list page
On a certain page of the website, we need to display a list of friendly links. Create a PHP page, named links.php, and write the following code:

<?php
// 连接数据库
$conn = new PDO('mysql:host=localhost;dbname=your_database_name;charset=utf8', 'your_username', 'your_password');

// 查询链接列表
$stmt = $conn->query('SELECT * FROM links');
$links = $stmt->fetchAll(PDO::FETCH_ASSOC);

// 输出链接列表
foreach ($links as $link) {
    echo '<a href="' . $link['url'] . '">' . $link['name'] . '</a><br>';
}
?>

Copy after login

In the above code, we first connect to the database through PDO and execute the query statement to obtain the link list. Then, use a foreach loop to traverse the linked list and output the link name and address.

Create the add link page
We also need to create a page for adding new friendly links. Create a PHP page, named add_link.php, and write the following code:

<html>
<body>
    <form action="create_link.php" method="post">
        <label for="name">链接名称：</label>
        <input type="text" name="name"><br>

        <label for="url">链接地址：</label>
        <input type="text" name="url"><br>

        <label for="description">链接描述：</label>
        <textarea name="description"></textarea><br>

        <input type="submit" value="添加链接">
    </form>
</body>
</html>

Copy after login

In the above code, we create a form containing name, address, and description input boxes. The form's action attribute points to create_link.php, a page used to handle requests to add links.

Create the create link page
Finally, we need to create a page that handles the add link request. Create a PHP page, named create_link.php, and write the following code:

<?php
// 连接数据库
$conn = new PDO('mysql:host=localhost;dbname=your_database_name;charset=utf8', 'your_username', 'your_password');

// 获取表单提交的数据
$name = $_POST['name'];
$url = $_POST['url'];
$description = $_POST['description'];

// 插入链接数据
$stmt = $conn->prepare('INSERT INTO links(name, url, description) VALUES(:name, :url, :description)');
$stmt->execute(array(':name' => $name, ':url' => $url, ':description' => $description));

// 返回链接列表页面
header('Location: links.php');
?>

Copy after login

In the above code, we first connect to the database through PDO. Then, obtain the data submitted by the form through the $_POST global variable. Next, use the prepare method and execute method to insert the linked data into the database. Finally, use the header function to jump back to the linked list page.

Through the above steps, we have completed the development of a simple friendly link function. Users can enter the name, address and description of the link on the add link page. After submission, the link will be saved in the database and then displayed on the link list page.

Conclusion
Friendly links are a simple but practical function that can help websites establish connections with other websites and recommend each other. PHP, as a popular server-side scripting language, can be used to develop a variety of powerful web applications. Through the method introduced in this article, it has become simple and easy to implement the friendly link function in PHP. I hope this article will be helpful to you in implementing the friendly link function in PHP development.

The above is the detailed content of PHP Development Guide: Implementing Simple Friends Link Function. For more information, please follow other related articles on the PHP Chinese website!