CRUD Tech Demo with PHP, PDO, and MySQL

This Tech Demo is based on CodeShack's CRUD Application Tutorial and comes with several enhancements:

• Remodeled from a procedural to an object-oriented Implementation
• Normalized Database with Foreign Keys
• Triggers to cleanup orphaned data for Database Integrity
• Usage of libphonenumber-for-php-lite for Phone Number verification
• Full Dark Mode Support
• Dedicated Status Class for Error Handling
• A TaskBoard for logged-in Users

Requirements

Windows:

• XAMPP
• Composer

Fedora Linux:

• PHP
• • Composer
• • PDO
• MariaDB/MySQL
• • Optional: phpMyAdmin

Setting up the Database

Create a crud database with your preferred method and a crud_user that is granted all privileges for it. Import crud.sql into the crud database, rename sqlauth.conf.php.template to sqlauth.conf.php and replace the authentication data.

Notes

• Never use this on a Production Server, only on a Development Server like XAMPP or PHP's Development Server.
• The sample passwords from crud.sql are all 123456 in form of distinct bcrypt hashes. They can be replaced with proper passwords.

License

This Application is available under the terms of the Apache 2.0 License.

Many Thanks to David Adams for writing the Original Tutorial and for giving permission to publish my refactored version under an open-source license 🐧

Check out CodeShack.io for more interesting learning resources (including a PHP Login System)!