Hands-on PHP & MySQL: Build a CRUD Application

Database Definition

Discover how to define a MySQL database schema by creating projects and tasks tables and populating them with initial data. Understand how to structure and initialize your database for a PHP CRUD app.

We'll cover the following...

Database schema
Execute .sql commands

1.Introduction

2.App Initialization

3.Create and Read Records

4.Refactor the Application

5.PHP Data Validation

6.Generate Reports

7.Update and Delete Records

8.PHP Router

9.Conclusion

10.Appendix

Database Definition