系统架构
- 前台展示:文章列表、文章详情
- 后台管理:登录、文章CRUD
- 数据库:文章表、管理员表
核心代码
``
php
$sql = "SELECT id, title, created_at FROM posts ORDER BY id DESC";
$result = $conn->query($sql);
while($row = $result->fetch_assoc()){
// 输出文章
}
`` php
$sql = "SELECT id, title, created_at FROM posts ORDER BY id DESC";
$result = $conn->query($sql);
while($row = $result->fetch_assoc()){
// 输出文章
}
``