Skip to main content

PHP CRUD Application Development Full Series - #41


Like what you see, support the channel.

Published: November 16, 2020


Estimated Reading Time
3 minutes
Video Duration
4:24:03 minutes

Become a Patreon to show support and get exclusive access to content: https://www.patreon.com/devdrawer

Learn how to start a simple PHP + MySQLi CRUD (Create, Read, Update, Delete) application. Go step-by-step on how to get started with PHP and MySQLi the right way using your own local installation of WAMP.

As a new developer, you need to learn how to create a CRUD application. WordPress is essentially a layered CRUD application. If you are a PHP developer, learning how to build a CRUD application can be the difference between using WordPress forever or creating your own dynamic content management system.

Taking what we learned about creating a PHP + MySQLi CRUD (Create, Read, Update, Delete) application and making it more functional with a bit of style.

Now we can introduce Bootstrap, FontAwesome, and DataTables. I use Bootstrap because it easy to get started with and includes most of the CRUD application look we are needing. You can use other frameworks but I have found using Bootstrap as a basis is a great way to start your CRUD application development.

Next, we will use jQuery to populate our data with AJAX and will integrate jQuery Validation.

We will also take our 3rd party scripts and download, combine, minify, and optimize the workflow to make the CRUD application faster and more efficient.

Now that we have form validation, we are going to use PHP and Bootstrap to display update, delete, and create alerts that are stored as sessions.

I also have my first big issue recording while I code and discuss how I fix the issue as well as present my recording setup better.

We can now create custom styles to modify the presentation view for Bootstrap and DataTables.net.

Next, we will be setting up security and limiting access to only registered users.

In this part, we will be showing different interfaces based on security permissions.

By the end of this video, you will have completed the CRUD application development series and you will have a fully working, yet basic CRUD application that you can modify as you see fit.

Individual Series Videos

1. Database and Getting Started: https://youtu.be/fxlrWGjXZI8

2. Bootstrap, FontAwesome, and DataTables: https://youtu.be/HeAh1emQWkM

3. AJAX and Form Validation: https://youtu.be/nXgFyQkrefY

4. Sessions and Customization: https://youtu.be/OAQ8A1hHW5M

5. Security and Login: https://youtu.be/hfJBcxsOckc

6. Page and User Authentication: https://youtu.be/__xq2ZKEhwg

Download this project:

You can download the complete PHP CRUD application project using the following link. Please remember this was built as a tutorial and I do not warranty this project if you choose to use it on your own project. It was created for usage within this video series.

Download here: https://github.com/thedevdrawer/Simple-PHP-CRUD-Application

Applications Used

Visual Studio Code v1.43: https://code.visualstudio.com/

WAMP v3.2.0: http://www.wampserver.com/en/

Computer Hardware:

Windows 10 Pro: https://amzn.to/3q5TyZw (Amazon)

Samsung 500GB External SSD: https://amzn.to/2ViAAAF (Amazon)

Samsung 970 EVO Plus SSD 1TB - M.2 NVMe: https://amzn.to/36jDwDy (Amazon)

Rosewill Hive-750S R750W PSU: https://amzn.to/36jiDbs (Amazon)

Phanteks Eclipse Tempered Glass Case: https://amzn.to/39qou0B (Amazon)

MSI Arsenal Gaming AMD Ryzen Motherboard: https://amzn.to/36hpAKm (Amazon)

MSI Gaming GeForce RTX 2060 Super 8GB: https://amzn.to/36hMyRm (Amazon)

LG 34UM69G-B 34-Inch 21:9 UltraWide IPS Monitor: https://amzn.to/2HSRxyI (Amazon)

Corsair 64GB (4 x 16GB) DDR4 Memory: https://amzn.to/3mlmQkI (Amazon)

AMD Ryzen 7 2700X Processor: https://amzn.to/3qdQIBF (Amazon)

Dell XPS 15 9500 15.6" Laptop / Windows: https://amzn.to/3fKEz2w (Amazon)

Lenovo ThinkPad T15 15.6" Laptop / Linux: https://amzn.to/2Jnmn33 (Amazon)

Camera:

Fujifilm X-T3: https://amzn.to/3llKBb5 (Amazon)

Fujinon XF18-55mmF2.8-4: https://amzn.to/3mfTkNb (Amazon)

Audio:

Audio Technica AT2020: https://amzn.to/2VgxU6K (Amazon)

Blue Snowball iCE: https://amzn.to/3lo1jGC (Amazon)

DISCLAIMERS:

I am a participant in the Amazon Services LLC Associates Program, an affiliate advertising program designed to provide a means for us to earn fees by linking to Amazon.com and affiliated sites.