Simple Blog System

Database (blogdb):

CREATE DATABASE blogdb;
USE blogdb;

CREATE TABLE posts (
  id INT AUTO_INCREMENT PRIMARY KEY,
  title VARCHAR(255),
  content TEXT
);

Add Post (add.php):

<?php
$conn = new mysqli("localhost", "root", "", "blogdb");

if($_SERVER["REQUEST_METHOD"] == "POST"){
$title = $_POST&#91;'title'];
$content = $_POST&#91;'content'];
$sql = "INSERT INTO posts (title, content) VALUES ('$title', '$content')";
$conn-&gt;query($sql);
header("Location: index.php");}
?>

<form method="post">
  Title: <input type="text" name="title" required><br>
  Content:<br>
  <textarea name="content" required></textarea><br>
  <input type="submit" value="Add Post">
</form>

Show Posts (index.php):

<?php
$conn = new mysqli("localhost", "root", "", "blogdb");
$result = $conn->query("SELECT * FROM posts");

while($row = $result->fetch_assoc()){
echo "&lt;h2&gt;".$row&#91;'title']."&lt;/h2&gt;";
echo "&lt;p&gt;".$row&#91;'content']."&lt;/p&gt;";
echo "&lt;a href='edit.php?id=".$row&#91;'id']."'&gt;Edit&lt;/a&gt; | ";
echo "&lt;a href='delete.php?id=".$row&#91;'id']."'&gt;Delete&lt;/a&gt;&lt;hr&gt;";}
?>
<a href="add.php">Add New Post</a>

Edit Post (edit.php):

<?php
$conn = new mysqli("localhost", "root", "", "blogdb");

if(isset($_GET['id'])){
$id = $_GET&#91;'id'];
$post = $conn-&gt;query("SELECT * FROM posts WHERE id=$id")-&gt;fetch_assoc();}

if($_SERVER["REQUEST_METHOD"] == "POST"){
$title = $_POST&#91;'title'];
$content = $_POST&#91;'content'];
$id = $_POST&#91;'id'];
$conn-&gt;query("UPDATE posts SET title='$title', content='$content' WHERE id=$id");
header("Location: index.php");}
?>

<form method="post">
  <input type="hidden" name="id" value="<?php echo $post['id']; ?>">
  Title: <input type="text" name="title" value="<?php echo $post['title']; ?>" required><br>
  Content:<br>
  <textarea name="content" required><?php echo $post['content']; ?></textarea><br>
  <input type="submit" value="Update Post">
</form>

Delete Post (delete.php):

<?php
$conn = new mysqli("localhost", "root", "", "blogdb");
if(isset($_GET['id'])){
$id = $_GET&#91;'id'];
$conn-&gt;query("DELETE FROM posts WHERE id=$id");}
header("Location: index.php");
?>

Explanation:

A CRUD project (Create, Read, Update, Delete).
Blog posts stored in MySQL.
Admin can manage posts.

Comments