PHP development: How to implement the friendly link function

PHP development: How to implement the friendly link function, specific code examples are required

Friendly links are a common feature on websites, which allow webmasters to communicate with other websites Exchange links to increase website connectivity and traffic. In PHP development, it is not complicated to implement the friendly link function. This article will introduce how to use PHP code to implement the friendly link function and provide specific code examples.

1. Create a database table

First, we need to create a database table to store the information of friendly links. You can create a table named links in the database using the following SQL statement:

CREATE TABLE `links` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `title` varchar(255) NOT NULL,
  `url` varchar(255) NOT NULL,
  `status` tinyint(1) NOT NULL DEFAULT '1',
  `created_at` datetime NOT NULL,
  `updated_at` datetime NOT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

The table contains the following fields:

• id: The unique identifier of the link, auto-incremented primary key.
• title: The title of the link.
• url: URL address of the link.
• status: The status of the link, 1 means enabled, 0 means disabled.
• created_at: The creation time of the link.
• updated_at: The update time of the link.

2. Create a link list page

Next, we need to create a page to display the list of friendly links in the website. A file named links.php can be created using the following code:

<?php
// 连接数据库
$pdo = new PDO('mysql:host=localhost;dbname=your_database', 'username', 'password');

// 查询所有启用的链接
$stmt = $pdo->prepare('SELECT * FROM links WHERE status = 1');
$stmt->execute();
$links = $stmt->fetchAll(PDO::FETCH_ASSOC);

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

In the code, first we connect to the database using the PDO class. We then query the database for all links with a status of enabled and store the results in the $links variable. Finally, we use foreach to loop through the $links array, displaying the title and URL of the link.

3. Create a link management page

In order to facilitate the website administrator to manage friendly links, we also need to create a link management page. A file called admin.php can be created using the following code:

<?php
// 连接数据库
$pdo = new PDO('mysql:host=localhost;dbname=your_database', 'username', 'password');

// 处理表单提交
if ($_SERVER['REQUEST_METHOD'] === 'POST') {
  $title = $_POST['title'];
  $url = $_POST['url'];

  // 插入链接到数据库
  $stmt = $pdo->prepare('INSERT INTO links (title, url, created_at, updated_at) VALUES (?, ?, NOW(), NOW())');
  $stmt->execute([$title, $url]);

  echo '链接添加成功！';
}
?>

<form method="POST" action="admin.php">
  <input type="text" name="title" placeholder="链接标题" required><br>
  <input type="url" name="url" placeholder="链接URL" required><br>
  <input type="submit" value="添加链接">
</form>

In the code, we first connect to the database using the PDO class. Then, we determine whether the form has been submitted by checking the $_SERVER['REQUEST_METHOD'] variable. If the form has been submitted, we get the link title and URL from the form and insert it into the database. Finally, we display a form on the page for the administrator to add new links.

4. Run and test

After completing the above code, we can visit the links.php page in the browser to display the list of friendly links. At the same time, the administrator can visit the admin.php page to add links.

In order to ensure that the code runs normally, we need to replace localhost in the code with your database host name, your_database with your database name, Replace username with your database username and password with your database password.

Summary

This article introduces how to use PHP code to implement the friend link function and provides specific code examples. By creating database tables, displaying link list pages and adding link management pages, we can easily implement the friendly link function. I hope this article will be helpful to readers who are learning PHP development.

The above is the detailed content of PHP development: How to implement the friendly link function. For more information, please follow other related articles on the PHP Chinese website!