PHP 7 Programming Blueprints

Chapter 4. Build a Simple Blog with Search Capability using Elasticsearch

In this chapter, we will create a simple blog that can create and delete posts. Then we will work on adding some features to our blog such as the following:

• Implement a very simple blog with CRUD and admin features
• Work and install Elasticsearch and Logstash
• Try out the PHP client of Elasticsearch
• Learn to build a tool for working with Elasticsearch
• Build a cache for searches to our database
• Build a chart based on our Elasticsearch information

Creating the CRUD and admin system

First, let's build the SQL of our posts. The database table should contain at the very least the post title, post content, post date, and modified and published dates.

This is what the SQL should look like: ...