How to create a CRUD system in WordPress – 2022

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. On the web, it would most probably mean a piece of software that manages entries in your database. Usually, it refers to MySQL, PostgreSQL, MS SQL, or other DB engines.

Heatmap table examples and how to create one in WordPress

Whenever you see a heatmap table online, you must think it’s quite a fancy and complicated thing to create, right?

Not really, actually.

From afar, it looks like you need to play with lots of numerical data and do complicated technical things to create cells for a table heatmap.

Yet, that’s far from reality if you have the proper tool.

In this article, I’ll go over creating a heatmap table with wpDataTables, the #1 WordPress plugin for creating tables and charts.