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

As human beings, we often make mistakes or end up changing our minds. A good application is one that is flexible and allows users to modify what’s already been saved in the database.  

Now, let’s learn how we can update a project record.

# Getting started

These are the steps that we’ll follow:
- The user will click on the project that they want to edit from the list of projects.
- They will be redirected to the project form that’s pre-populated with the information of the project they selected.
- They’ll click the “Update” button, once the project has been modified.
- They’ll be redirected back to the project list.


>**Note:** This lesson will consist of two parts. This is the first one and it focuses on the view.
Let's make our list items clickable.

Going to `views/project_list.php`, we’ll change the code so that it looks like this:

```
<li>
     <a href="../controllers/project.php?id= <?php echo $project['id']; ?>"
     >
        <?php echo escape($project["title"]) ?>
     </a>
</li>
```
Now we can click and be redirected to the “Add project” form from the project list. We’ll notice that we’re passing the project `id` in the URL.

Next, let’s go to the project view: `views/project.php`.

# Implement code for the view

Our current view is set to “Add a project”. That’s why we have `$title = 'Add Project'`. Now that we want the same file to handle the update feature, we’ll add this code snippet just after the title:

```
if (!empty($_GET['id'])) {
    $title = "Update project";
}
``` 

In the form, we want the default values to be what the user chose from the project list. For instance, ifthe user clicks the “Learn Laravel” title, this should be the value of the input title and its category in the category field of the form.

In the form, we’ll replace the title input with this:


```
<input type="text" placeholder="New project" name="title" id="title" value="<?php                   echo $project_title; ?>">
```  
The `$project_title` variable will be taken from the controller. For now, nothing will happen.

For the category, we’ll replace the form under the first `<option>` with this:


As human beings, we often make mistakes or end up changing our minds. A good application is one that is flexible and allows users to modify what’s already been saved in the database.  

Now, let’s learn how we can update a project record.

# Getting started

These are the steps that we’ll follow:
- The user will click on the project that they want to edit from the list of projects.
- They will be redirected to the project form that’s pre-populated with the information of the project they selected.
- They’ll click the “Update” button, once the project has been modified.
- They’ll be redirected back to the project list.


>**Note:** This lesson will consist of two parts. This is the first one and it focuses on the view.
Let's make our list items clickable.

Going to `views/project_list.php`, we’ll change the code so that it looks like this:

```
<li>
     <a href="../controllers/project.php?id= <?php echo $project['id']; ?>"
     >
        <?php echo escape($project["title"]) ?>
     </a>
</li>
```
Now we can click and be redirected to the “Add project” form from the project list. We’ll notice that we’re passing the project `id` in the URL.

Next, let’s go to the project view: `views/project.php`.

# Implement code for the view

Our current view is set to “Add a project”. That’s why we have `＄title = 'Add Project'`. Now that we want the same file to handle the update feature, we’ll add this code snippet just after the title:

```
if (!empty($_GET['id'])) {
    $title = "Update project";
}
``` 

In the form, we want the default values to be what the user chose from the project list. For instance, ifthe user clicks the “Learn Laravel” title, this should be the value of the input title and its category in the category field of the form.

In the form, we’ll replace the title input with this:


```
<input type="text" placeholder="New project" name="title" id="title" value="<?php                   echo $project_title; ?>">
```  
The `＄project_title` variable will be taken from the controller. For now, nothing will happen.

For the category, we’ll replace the form under the first `<option>` with this:


Learn how to modify a database record in PHP.

Introduction

App Initialization

Create and Read Records

Refactor the Application

PHP Data Validation

Generate Reports

Update and Delete Records

PHP Router

Conclusion

Appendix

Update Records

Getting started