This is a simple blog system in PHP in which you can create posts and comments. Before you start posting you must create a new account, then login with your username and password combination.
In this project I used MySQL database. There are 3 tables in the database: posts, comments, users.
Users table:
| Attribute name | type |
|---|---|
| id (PK) | INT |
| username | VARCHAR(255) |
| password | VARCHAR(255) |
| VARCHAR(255) |
Posts table:
| Attribute name | type |
|---|---|
| id (PK) | INT |
| title | VARCHAR(255) |
| description | TEXT |
| content | TEXT |
| user_id (FK) | INT |
| created | DATE |
Comments table:
| Attribute name | type |
|---|---|
| id (PK) | INT |
| content | TEXT |
| user_id (FK) | INT |
| post_id (FK) | INT |
| created | DATETIME |
I used this rich text editor in my project: https://www.tiny.cloud/