PHP CRUD Application Development Full Series - #41

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