Working with Custom Database Tables in WordPress

Опубликовано: 03 Август 2023
на канале: SmallTownDev
2,955
41

Learn how to Create a Custom Database Table in WordPress. We will also see how you can Insert Data into these Tables via AJAX Forms and fetch the Data back to Output at the front end. Hopefully, this helps you improve/build your WordPress Plugin for the better.

Code shown/used in this video -
https://github.com/smalltowndev/tutor...

Want to know my current PHP/WordPress Development Workflow? Here it is -    • BEST PHP and WordPress Development Wo...  

WPDB Class Documentation from WordPress Developer Handbook -
https://developer.wordpress.org/refer...

Creating or Updating tables in WordPress (A bit outdated doc) -
https://codex.wordpress.org/Creating_...

Learn how to create AJAX Forms -
   • WordPress AJAX Forms and jQuery Magic...  

PHP/WordPress Code formatting and linting -
   • Using PHP Code Sniffer with WordPress...  

Learn Placeholder syntax from PHP vsprintf Documentation -
https://www.php.net/vsprintf

Character Sets and Collations in MySQL -
https://dev.mysql.com/doc/refman/8.0/...

MySQL Syntax guides from W3Schools -
https://www.w3schools.com/mysql/mysql...


=== Timestamps ===
00:00 - Intro
00:19 - Initial Setup
01:15 - Register Custom Table and SQL Schema
10:05 - Running the Plugin Activation to Register Table
12:55 - An Extra Tip
14:30 - Inserting Data into Custom Table from AJAX Forms
19:55 - Outputting the Data from the Custom Table
29:32 - Upgrading Table Schema with Plugin Updates
30:41 - Cleaning up the Database before Plugin Uninstall
34:47 - Final Remarks

=== Music Credits ===
Music track: Coffee Time by Pufino
Source: https://freetouse.com/music/
Copyright Free Music (Free Download)

Music track: Creamy by Aylex
Source: https://freetouse.com/music/
Vlog Music for Videos (Free Download)

=== Related Keywords ===

Build WordPress Plugins
Manage WordPress Database
WordPress Database Tables
Create Database Table in WordPress
Build WordPress Plugin
Create a WordPress Plugin
WordPress Theme Development
Create WordPress Themes
WordPress development
PHP Development


Смотрите видео Working with Custom Database Tables in WordPress онлайн без регистрации, длительностью часов минут секунд в хорошем качестве. Это видео добавил пользователь SmallTownDev 03 Август 2023, не забудьте поделиться им ссылкой с друзьями и знакомыми, на нашем сайте его посмотрели 2,95 раз и оно понравилось 4 людям.