一步步教你如何用PHP开发新闻发布网站

<?php
$db_host = 'localhost';
$db_username = 'root';
$db_password = 'password';
$db_name = 'news';

$conn = new mysqli($db_host, $db_username, $db_password, $db_name);

if ($conn->connect_error) {
    die("数据库连接失败：" . $conn->connect_error);
}

<?php
include 'db_connect.php';

$category = $_GET['category'];

$sql = "SELECT * FROM news_articles WHERE category='$category'";
$result = $conn->query($sql);

if ($result->num_rows > 0) {
    while ($row = $result->fetch_assoc()) {
        echo "<h3>" . $row['title'] . "</h3>";
        echo "<p>" . $row['content'] . "</p><p><span>立即学习</span>“<a href="https://pan.quark.cn/s/7fc7563c4182" style="text-decoration: underline !important; color: blue; font-weight: bolder;" rel="nofollow" target="_blank">PHP免费学习笔记（深入）</a>”；</p>
                    <div class="aritcle_card">
                        <a class="aritcle_card_img" href="/xiazai/code/11174">
                            <img src="https://img.php.cn/upload/webcode/000/000/009/176520600832184.jpg" alt="天天团购系统">
                        </a>
                        <div class="aritcle_card_info">
                            <a href="/xiazai/code/11174">天天团购系统</a>
                            <p>天天团购系统是一套强大的开源团购程序，采用PHP+mysql开发，系统内置支付宝、财付通、GOOGLE地图等接口，支持短信发送团购券和实物团购快递发货等；另外可通过Ucenter模块，与网站已有系统无缝整合，实现用户同步注册、登陆、退出。 天天团购系统是一套创新的开源团购程序，拥有多达10项首创功能，同时支持虚拟和实物团购，内置类似淘宝的快递配送体系，并提供强大的抽奖、邀请返利等营销功能，让您轻松</p>
                            <div class="">
                                <img src="/static/images/card_xiazai.png" alt="天天团购系统">
                                <span>0</span>
                            </div>
                        </div>
                        <a href="/xiazai/code/11174" class="aritcle_card_btn">
                            <span>查看详情</span>
                            <img src="/static/images/cardxiayige-3.png" alt="天天团购系统">
                        </a>
                    </div>
                ";
    }
} else {
    echo "暂无新闻";
}

$conn->close();

<?php
include 'db_connect.php';

$id = $_GET['id'];

$sql = "SELECT * FROM news_articles WHERE id='$id'";
$result = $conn->query($sql);

if ($result->num_rows > 0) {
    $row = $result->fetch_assoc();
    echo "<h1>" . $row['title'] . "</h1>";
    echo "<p>" . $row['content'] . "</p><p><span>立即学习</span>“<a href="https://pan.quark.cn/s/7fc7563c4182" style="text-decoration: underline !important; color: blue; font-weight: bolder;" rel="nofollow" target="_blank">PHP免费学习笔记（深入）</a>”；</p>";
} else {
    echo "新闻不存在";
}

$conn->close();

<?php
include 'db_connect.php';

$sql = "SELECT * FROM news_articles ORDER BY timestamp 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><p><span>立即学习</span>“<a href="https://pan.quark.cn/s/7fc7563c4182" style="text-decoration: underline !important; color: blue; font-weight: bolder;" rel="nofollow" target="_blank">PHP免费学习笔记（深入）</a>”；</p>";
    }
} else {
    echo "暂无新闻";
}

$conn->close();

<?php
include 'db_connect.php';

if ($_SERVER['REQUEST_METHOD'] === 'POST') {
    $category = $_POST['category'];
    $title = $_POST['title'];
    $content = $_POST['content'];
    $timestamp = date('Y-m-d H:i:s');

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

$conn->close();
?>

<form method="POST" action="admin.php">
    <input type="text" name="category" placeholder="分类" required>
    <input type="text" name="title" placeholder="标题" required>
    <textarea name="content" placeholder="内容" required></textarea>
    <button type="submit">发布新闻</button>
</form>