PHP を使用して動的コンテンツ管理システムを構築する

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

$servername = "localhost";
$username = "root";
$password = "";
$dbname = "my_cms";

// Create connection
$conn = new mysqli($servername, $username, $password, $dbname);

// Check connection
if ($conn->connect_error) {
  die("Connection failed: " . $conn->connect_error);
}

class CreateController {
  public function store() {
    $title = $_POST['title'];
    $content = $_POST['content'];

    $sql = "INSERT INTO articles (title, content) VALUES (?, ?)";
    $stmt = $this->conn->prepare($sql);
    $stmt->bind_param("ss", $title, $content);
    $stmt->execute();

    header("Location: /");
    exit;
  }
}

class ReadController {
  public function index() {
    $sql = "SELECT * FROM articles ORDER BY created_at DESC";
    $stmt = $this->conn->prepare($sql);
    $stmt->execute();

    $articles = $stmt->get_result()->fetch_all(MYSQLI_ASSOC);

    return view('articles/index', ['articles' => $articles]);
  }
}

class UpdateController {
  public function edit($id) {
    $sql = "SELECT * FROM articles WHERE id = ?";
    $stmt = $this->conn->prepare($sql);
    $stmt->bind_param("i", $id);
    $stmt->execute();

    $article = $stmt->get_result()->fetch_assoc();

    return view('articles/edit', ['article' => $article]);
  }

  public function update($id) {
    $title = $_POST['title'];
    $content = $_POST['content'];

    $sql = "UPDATE articles SET title = ?, content = ? WHERE id = ?";
    $stmt = $this->conn->prepare($sql);
    $stmt->bind_param("ssi", $title, $content, $id);
    $stmt->execute();

    header("Location: /");
    exit;
  }
}

class DeleteController {
  public function destroy($id) {
    $sql = "DELETE FROM articles WHERE id = ?";
    $stmt = $this->conn->prepare($sql);
    $stmt->bind_param("i", $id);
    $stmt->execute();

    header("Location: /");
    exit;
  }
}