Skip to main content

PHP CRUD - Database and Getting Started, Part 1 - #1

Published: March 06, 2020 | DevDrawer

Estimated Reading Time
3 minutes
Video Duration
45:27 minutes

Become a Patreon to show support and get exclusive access to content:


Part One. 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.

This video uses WAMP instead of a full server, but you can use either and accomplish the same purpose.

Get started using a simple connection to your database and build the basic structure for a CRUD application. This is part one of a video series. Once you have the basics down we can make it look pretty and function better.


View other videos in this series:

1. Database and Getting Started:

2. Bootstrap, FontAwesome, and DataTables:

3. AJAX and Form Validation:

4. Sessions and Customization:

5. Security and Login:

6. Page and User Authentication:

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:

Computer Hardware:

Windows 10 Pro: (Amazon)

Samsung 500GB External SSD: (Amazon)

Samsung 970 EVO Plus SSD 1TB - M.2 NVMe: (Amazon)

Rosewill Hive-750S R750W PSU: (Amazon)

Phanteks Eclipse Tempered Glass Case: (Amazon)

MSI Arsenal Gaming AMD Ryzen Motherboard: (Amazon)

MSI Gaming GeForce RTX 2060 Super 8GB: (Amazon)

LG 34UM69G-B 34-Inch 21:9 UltraWide IPS Monitor: (Amazon)

Corsair 64GB (4 x 16GB) DDR4 Memory: (Amazon)

AMD Ryzen 7 2700X Processor: (Amazon)

Dell XPS 15 9500 15.6" Laptop / Windows: (Amazon)

Lenovo ThinkPad T15 15.6" Laptop / Linux: (Amazon)


Fujifilm X-T3: (Amazon)

Fujinon XF18-55mmF2.8-4: (Amazon)


Audio Technica AT2020: (Amazon)

Blue Snowball iCE: (Amazon)


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 and affiliated sites.