PHP友情链接表如何设计(构建高效的友情链接表)
## 1. 创建数据库表
```sql
CREATE TABLE friend_links (
id INT AUTO_INCREMENT PRIMARY KEY,
site_name VARCHAR(255) NOT NULL,
site_url VARCHAR(255) NOT NULL,
logo_url VARCHAR(255),
description TEXT
## 2. 连接数据库
```php
$host = 'localhost';
$username = 'root';
$password = 'password';
$database = 'dbname';
$conn = new mysqli($host, $username, $password, $database);
if ($conn->connect_error) {
die("Connection failed: " . $conn->connect_error);
在上面的代码中,我们使用`mysqli`扩展连接了MySQL数据库,如果连接失败则输出错误信息并终止脚本执行。
在`config.php`文件中添加如下代码:
```php
function addFriendLink($site_name, $site_url, $logo_url, $description) {
global $conn;
$sql = "INSERT INTO friend_links (site_name, site_url, logo_url, description) VALUES ('$site_name', '$site_url', '$logo_url', '$description')";
}
在`config.php`文件中添加如下代码:
```php
function deleteFriendLink($id) {
global $conn;
$sql = "DELETE FROM friend_links WHERE id = $id";
}
在`config.php`文件中添加如下代码:
```php
function editFriendLink($id, $site_name, $site_url, $logo_url, $description) {
global $conn;
$sql = "UPDATE friend_links SET site_name = '$site_name', site_url = '$site_url', logo_url = '$logo_url', description = '$description' WHERE id = $id";
}
在`config.php`文件中添加如下代码:
```php
function getFriendLinks() {
global $conn;
$sql = "SELECT * FROM friend_links";
$result = $conn->query($sql);
$friendLinks = [];
if ($result->num_rows > 0) {
while($row = $result->fetch_assoc()) {
$friendLinks[] = $row;
}
}
return $friendLinks;
```php
$friendLinks = getFriendLinks();
foreach ($friendLinks as $link) {
echo '';
echo '';
推荐与本文相关的好文: