How to develop a blog website using PHP and CGI

How to use PHP and CGI to develop a blog website

Overview:
Blog website is a very popular website form in the Internet era. It allows users to create and publish their own blog posts, and communicate and comment with other users. This article will introduce how to use PHP and CGI to develop a simple blog website and provide corresponding code examples.

1. Environment preparation:
Before we start, we need to ensure that the PHP interpreter and CGI have been installed. Typically, PHP is installed with Apache or Nginx, and an integrated environment like XAMPP or WAMP can be used. If it is not installed, you can download and install it from the PHP official website as needed.

2. Create a database:
The blog website needs a database to store articles and user information. MySQL or other relational databases can be used. First, make sure the database service is installed and started. Then, create a database named "blog" and create two tables "posts" and "users". The following is a simple example:

CREATE DATABASE blog;
USE blog;

CREATE TABLE posts (
  id INT AUTO_INCREMENT PRIMARY KEY,
  title VARCHAR(255) NOT NULL,
  content TEXT,
  created_at TIMESTAMP DEFAULT CURRENT_TIMESTAMP
);

CREATE TABLE users (
  id INT AUTO_INCREMENT PRIMARY KEY,
  username VARCHAR(255) NOT NULL,
  password VARCHAR(255) NOT NULL
);

3. Create a front-end page:
In a blog website, users need to be able to browse articles, register new users and log in. First, create an index.php file as the entry file. Here is a simple example:

<?php
  // index.php

  // 查询所有文章
  $query = "SELECT * FROM posts ORDER BY created_at DESC";
  $result = mysqli_query($conn, $query);

  // 循环输出文章列表
  while ($row = mysqli_fetch_assoc($result)) {
    echo "<h2>" . $row["title"] . "</h2>";
    echo "<p>" . $row["content"] . "</p>";
    echo "<p>" . $row["created_at"] . "</p>";
    echo "<hr>";
  }
?>

Next, create a register.php file for user registration. The following is a simple example:

<?php
  // register.php

  if ($_SERVER["REQUEST_METHOD"] == "POST") {
    $username = $_POST["username"];
    $password = $_POST["password"];

    // 将用户信息插入数据库
    $query = "INSERT INTO users (username, password) VALUES ('$username', '$password')";
    mysqli_query($conn, $query);

    echo "注册成功！";
  }
?>

<form method="POST" action="register.php">
  <input type="text" name="username" placeholder="用户名"><br>
  <input type="password" name="password" placeholder="密码"><br>
  <input type="submit" value="注册">
</form>

Similarly, create a login.php file for user login. The following is a simple example:

<?php
  // login.php

  session_start();

  if ($_SERVER["REQUEST_METHOD"] == "POST") {
    $username = $_POST["username"];
    $password = $_POST["password"];

    // 查询用户信息
    $query = "SELECT * FROM users WHERE username='$username' AND password='$password'";
    $result = mysqli_query($conn, $query);

    if (mysqli_num_rows($result) > 0) {
      $_SESSION["username"] = $username;
      echo "登录成功！";
    } else {
      echo "用户名或密码错误！";
    }
  }
?>

<form method="POST" action="login.php">
  <input type="text" name="username" placeholder="用户名"><br>
  <input type="password" name="password" placeholder="密码"><br>
  <input type="submit" value="登录">
</form>

4. Connect to the database:
In order to access the database in the front-end page, we need to add the database connection code to each page. The following is a simple example:

<?php
  // connection.php

  $host = "localhost";
  $username = "root";
  $password = "password";
  $database = "blog";

  $conn = mysqli_connect($host, $username, $password, $database);

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

Add the following code at the top of each page:

<?php
  include "connection.php";
?>

5. Add functions:
In actual development, more can be added according to needs function. For example, add article publishing and comment functions, user management and permission control, etc.

Summary:
This article introduces how to use PHP and CGI to develop a simple blog website. On this basis, it can be expanded and optimized as needed. Hope this article is helpful to you!

The above is the detailed content of How to develop a blog website using PHP and CGI. For more information, please follow other related articles on the PHP Chinese website!