MySQL创建文章分类表实现文章分类功能的实现方法

CREATE TABLE category (
  id INT AUTO_INCREMENT PRIMARY KEY,
  name VARCHAR(50) NOT NULL
);

INSERT INTO category (name) VALUES 
  ('科技'),
  ('生活'),
  ('娱乐');

CREATE TABLE article (
  id INT AUTO_INCREMENT PRIMARY KEY,
  title VARCHAR(100) NOT NULL,
  content TEXT NOT NULL,
  category_id INT NOT NULL,
  FOREIGN KEY (category_id) REFERENCES category(id)
);

SELECT article.title, article.content
FROM article
INNER JOIN category ON article.category_id = category.id
WHERE category.name = '科技';

<?php
$servername = "localhost";
$username = "root";
$password = "password";
$dbname = "my_database";

// 创建数据库连接
$conn = new mysqli($servername, $username, $password, $dbname);

// 检查连接是否成功
if ($conn->connect_error) {
    die("连接失败: " . $conn->connect_error);
}

// 查询分类为"科技"的文章
$sql = "SELECT article.title, article.content
        FROM article
        INNER JOIN category ON article.category_id = category.id
        WHERE category.name = '科技'";

$result = $conn->query($sql);

if ($result->num_rows > 0) {
    // 输出每个文章的标题和内容
    while($row = $result->fetch_assoc()) {
        echo "标题：" . $row["title"]. "<br>";
        echo "内容：" . $row["content"]. "<br><br>";
    }
} else {
    echo "没有匹配的文章";
}

// 关闭数据库连接
$conn->close();
?>