Gain insights into building a modern, production-ready PHP app. Delve into CRUD operations, I/O security, routing, and more. Discover how to effectively use PHP and MySQL for database applications.

Build a CRUD Database App with PHP & MySQL-01.png

lamp.tar.gz

lamp

lamp-copy

lamp-new

Learning a programming language is one thing and using it to build something great is another. I've been teaching code newbies and aspiring developers for a long time and I see many of them struggling to put into practice their newly acquired skills. I've also noticed that many resources on the Internet are out-of-date, misleading, or don't provide real hands-on practice.

I've built this course to fix the issues above. You'll learn a better way to build a modern and production-ready PHP app connected to a database like a pro. The app, a CRUD one, will also have some more advanced features like I/O security, router, and more. 

At the end of this course, you'll be well equipped to build database apps with PHP.

Hands-on PHP & MySQL: Build a CRUD Application

Slowly but surely, our project is expanding. Now, let’s create a basic landing page for it.
## Landing page
In the `index.php` file, we’ll add the following code snippet into the body:

```html
<h2> theTrackerApp </h2>
 <nav>
        <ul>
            <li><a href="./project_list.php">Projects list</a></li>
            <li><a href="./task_list.php">Tasks list</a></li>
        </ul>
 </nav>
 <div>
     <p>tracks time spent on your projects and tasks</p>
 </div>
```

Now we can fetch the tasks’ data from our database. This won’t be difficult because we’ll be conducting the same operation from the previous lesson, which we used for fetching all the projects in the database.




Slowly but surely, our project is expanding. Now, let’s create a basic landing page for it.
# Landing page
In the `index.php` file, we’ll add the following code snippet into the body:

```html
<h2> theTrackerApp </h2>
 <nav>
        <ul>
            <li><a href="./project_list.php">Projects list</a></li>
            <li><a href="./task_list.php">Tasks list</a></li>
        </ul>
 </nav>
 <div>
     <p>tracks time spent on your projects and tasks</p>
 </div>
```

Now we can fetch the tasks’ data from our database. This won’t be difficult because we’ll be conducting the same operation from the previous lesson, which we used for fetching all the projects in the database.




Learn how to use the “SELECT” statement to read data from the database and how we can use the “foreach” to loop over selected data and display it to the user.

Introduction

App Initialization

Create and Read Records

Refactor the Application

PHP Data Validation

Generate Reports

Update and Delete Records

PHP Router

Conclusion

Appendix

List All Tasks

Landing page