How to create a CRUD system in WordPress – 2018

This article on creating a CRUD system in WordPress was published back in 2014. However we noticed that this topic became even more actual, so we decided to give it a fresh look.

What is a CRUD system, how to integrate a CRUD system for MySQL in your WordPress site, what are the pros and cons of using different approaches?

Table of contents

What is a CRUD system?
Why would you need a CRUD system in WordPress?
How to integrate a CRUD system in WordPress site?
The easiest solution – try to find a suitable plugin
Start a new WordPress plugin
Create editor back-end (PHP classes)
Create a front-end interface (HTML, JS, PHP)
Connect front-end with back-end with AJAX calls (JS)
Test, refine and debug

CRUD vs REST: What’s the difference
How does REST work?
How Does CRUD work?
The Foundation and Principles of REST

What is a CRUD system?

The abbreviation CRUD comes from Create, Read, Update, Delete. Which, in other words, means a data management system. In web, it would most probably mean a piece of software which manages entries in your database. Usually, it refers to MySQL, PostgreSQL, MS SQL, or other DB engines.

How to create a product catalog in WordPress in a table

Not sure about the best way to create a product catalog in WordPress? Publishing your catalog and not sure how to do it better without any coding?

A lot of beginner developers get confused when they need publish a product table catalog, or price list: the HTML markup is confusing; some of them can do the markup, but aren’t satisfied with the look, or would like to have some solution which would be sortable, which could divide the data in pages, wouldn’t be too hard to update. Indeed: updating HTML table every time the product price changes, or when you add a new product, or when the quantity changes is frustrating.