PHP를 사용하여 간단한 뉴스 릴리스 시스템을 개발하는 방법

CREATE TABLE news (
  id INT(11) NOT NULL AUTO_INCREMENT PRIMARY KEY,
  title VARCHAR(255) NOT NULL,
  content TEXT NOT NULL,
  author VARCHAR(50) NOT NULL,
  publish_time DATETIME NOT NULL
);

<?php
// 连接数据库
$servername = "localhost";
$username = "root";
$password = "";
$dbname = "news_database";

$conn = new mysqli($servername, $username, $password, $dbname);
if ($conn->connect_error) {
    die("数据库连接失败：" . $conn->connect_error);
}

// 查询新闻列表
$sql = "SELECT * FROM news ORDER BY publish_time DESC";
$result = $conn->query($sql);

if ($result->num_rows > 0) {
    // 输出数据
    while($row = $result->fetch_assoc()) {
        echo "<h3>".$row["title"]."</h3>";
        echo "<p>".$row["content"]."</p>";
        echo "<p><strong>作者：</strong>".$row["author"]."</p>";
        echo "<p><strong>发布时间：</strong>".$row["publish_time"]."</p>";
        echo "<hr>";
    }
} else {
    echo "暂无新闻";
}

$conn->close();
?>

<?php
// 连接数据库
$servername = "localhost";
$username = "root";
$password = "";
$dbname = "news_database";

$conn = new mysqli($servername, $username, $password, $dbname);
if ($conn->connect_error) {
    die("数据库连接失败：" . $conn->connect_error);
}

// 获取新闻ID
$id = $_GET["id"];

// 查询新闻详情
$sql = "SELECT * FROM news WHERE id = ".$id;
$result = $conn->query($sql);

if ($result->num_rows > 0) {
    // 输出数据
    $row = $result->fetch_assoc();
    echo "<h3>".$row["title"]."</h3>";
    echo "<p>".$row["content"]."</p>";
    echo "<p><strong>作者：</strong>".$row["author"]."</p>";
    echo "<p><strong>发布时间：</strong>".$row["publish_time"]."</p>";
} else {
    echo "找不到该新闻";
}

$conn->close();
?>

<?php
// 连接数据库
$servername = "localhost";
$username = "root";
$password = "";
$dbname = "news_database";

$conn = new mysqli($servername, $username, $password, $dbname);
if ($conn->connect_error) {
    die("数据库连接失败：" . $conn->connect_error);
}

// 添加新闻
if ($_SERVER["REQUEST_METHOD"] == "POST" && isset($_POST["submit"])) {
    $title = $_POST["title"];
    $content = $_POST["content"];
    $author = $_POST["author"];
    $publish_time = date("Y-m-d H:i:s");

    $sql = "INSERT INTO news (title, content, author, publish_time) VALUES ('$title', '$content', '$author', '$publish_time')";
    
    if ($conn->query($sql) === TRUE) {
        echo "新闻发布成功";
    } else {
        echo "新闻发布失败：" . $conn->error;
    }
}

$conn->close();
?>

<form method="POST" action="">
    <label for="title">新闻标题：</label><br>
    <input type="text" id="title" name="title" required><br><br>
    
    <label for="content">新闻内容：</label><br>
    <textarea id="content" name="content" required></textarea><br><br>
    
    <label for="author">作者：</label><br>
    <input type="text" id="author" name="author" required><br><br>
    
    <input type="submit" name="submit" value="发布新闻">
</form>