Building RESTful Web Services with PHP 7

Creating a database schema

We are going to create endpoints for two resources/entities, which are :

• Blog post
• Post comments

So, we will be creating a database schema for these two resources.

Here is how we will design a database schema for a blog having posts and comments. A post can have multiple comments and a comment always belongs to post. Here, we have SQL for the database schema. You will first need to create a database and you will need to run the following SQL to have posts and comments tables. If you haven't created the database, then create it now. You can create it via some DB UI tool, or you can run the following SQL query:

create DATABASE blog;

This will create a database with the name blog.

Before creating a blog posts table ...