PHP를 사용하여 개발된 블로그 시스템에 대한 자세한 설명

CREATE TABLE posts ( id INT PRIMARY KEY AUTO_INCREMENT, title VARCHAR(255) NOT NULL, content TEXT NOT NULL, author_id INT NOT NULL, created_at TIMESTAMP DEFAULT CURRENT_TIMESTAMP, updated_at TIMESTAMP DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP ); CREATE TABLE users ( id INT PRIMARY KEY AUTO_INCREMENT, username VARCHAR(50) NOT NULL, password VARCHAR(255) NOT NULL, email VARCHAR(255) NOT NULL, created_at TIMESTAMP DEFAULT CURRENT_TIMESTAMP ); CREATE TABLE comments ( id INT PRIMARY KEY AUTO_INCREMENT, content TEXT NOT NULL, post_id INT NOT NULL, user_id INT NOT NULL, created_at TIMESTAMP DEFAULT CURRENT_TIMESTAMP ); CREATE TABLE categories ( id INT PRIMARY KEY AUTO_INCREMENT, name VARCHAR(50) NOT NULL, description VARCHAR(255) );

// index.php connect_error) { die("数据库连接失败：" . $conn->connect_error); } // 检查用户是否登录 if (!isLoggedIn()) { header('Location: login.php'); exit(); } // 显示博客文章列表 $query = "SELECT posts.id, posts.title, posts.created_at, users.username FROM posts INNER JOIN users ON posts.author_id = users.id ORDER BY created_at DESC"; $result = $conn->query($query); // 输出博客文章列表 if ($result->num_rows > 0) { while ($row = $result->fetch_assoc()) { echo "
" . $row["title"] . "
"; echo "
作者：" . $row["username"] . " 发布于：" . $row["created_at"] . "
"; echo "查看"; echo "
"; } } else { echo "暂无博客文章"; } // 关闭数据库连接 $conn->close(); ?>

// login.php  
 用户名：  
 密码：  
 登录 

// create_post.php  
 标题：  
 内容：  
 发布 

// view_post.php " . $post["title"] . ""; echo "
作者：" . $post["username"] . " 发布于：" . $post["created_at"] . "
"; echo "
" . $post["content"] . "
"; } else { echo "文章不存在"; } // 显示评论列表 $comments = getCommentsByPostId($post_id); if ($comments) { foreach ($comments as $comment) { echo "
" . $comment["content"] . "
"; echo "
评论者：" . $comment["username"] . " 发布于：" . $comment["created_at"] . "
"; echo "
"; } } else { echo "暂无评论"; } ?> 
 评论：  
 发布评论