/SQL/Creating a comment and reply system PHP and MySQL

Creating a comment and reply system PHP and MySQL

+----+-----------+--------------+------------+
|     field      |     type     | specs      |
+----+-----------+--------------+------------+
|  id            | INT(11)      |            |
|  title         | VARCHAR(255) |            |
|  slug          | VARCHAR(255) | UNIQUE     |
|  body          | TEXT         |            |
|  created_at    | TIMESTAMP    |            |
|  updated_at    | TIMESTAMP    |            |
+----------------+--------------+------------+

Source: codewithawa.com

Creating a comment and reply system PHP and MySQL

+----+-----------+--------------+------------+
|     field      |     type     | specs      |
+----+-----------+--------------+------------+
|  id            | INT(11)      |            |
|  user_id       | INT(11)      |            |
|  post_id       | INT(11)      |            |
|  body          | TEXT         |            |
|  created_at    | TIMESTAMP    |            |
|  updated_at    | TIMESTAMP    |            |
+----------------+--------------+------------+

Source: codewithawa.com

Creating a comment and reply system PHP and MySQL

+----+-----------+------------------------+------------+
|     field      |     type               | specs      |
+----+-----------+------------------------+------------+
|  id            | INT(11)                |            |
|  username      | VARCHAR(255)           | UNIQUE     |
|  email         | VARCHAR(255)           | UNIQUE     |
|  password      | VARCHAR(255)           |            |
|  created_at    | TIMESTAMP              |            |
+----------------+--------------+---------+------------+

Source: codewithawa.com

Creating a comment and reply system PHP and MySQL

+----+-----------+--------------+------------+
|     field      |     type     | specs      |
+----+-----------+--------------+------------+
|  id            | INT(11)      |            |
|  user_id       | INT(11)      |            |
|  comment_id    | INT(11)      |            |
|  body          | TEXT         |            |
|  created_at    | TIMESTAMP    |            |
|  updated_at    | TIMESTAMP    |            |
+----------------+--------------+------------+

Source: codewithawa.com

Similar codes

3 votes157 views1 answer
Apex call duration
SQL
0 vote95 views1 answer
Lister les index d'une table oracle
SQL
0 vote117 views1 answer
Sparql list all graphs
SQL
0 vote113 views1 answer
UNION ALL LEFT JOIN
SQL
0 vote109 views1 answer
Search db for table name
SQL
0 vote182 views1 answer
"inspanel" intitle:"login" -"cannot" "Login ID" -site:luckyfish.io
SQL
3 votes114 views2 answers
Sql select data from last week
SQL
0 vote101 views1 answer
View acl table oracle
SQL
0 vote107 views1 answer
How to check replication lag in mySQL
SQL
0 vote118 views1 answer
Illuminate/Database/QueryException with message 'SQLSTATE[42S02]
SQL