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

# The task form
We’ll create a new file called `task.php` from `project.php`. Let’s add the form:

```html
 <label for="project">Project</label>
 <select name="project" id="project">
   <option value="">Select a project</option>
   
 </select>
 <label for="title">Title</label>
 <input type="text" placeholder="New task" name="title" id="title">
 <label for="date">Date</label>
 <input type="date" placeholder="New task" name="date" id="date">
<label for="time">Time</label>
<input type="number" name="time" id="time">
```
`` will be replaced by the project titles, which will be fetched from the `projects` table.

On top of the file, inside the  `try/catch` block, we will fetch data like this:

```php
$sql = 'SELECT * FROM projects ORDER BY title';
$get_project_list = $connection->query($sql)->fetchAll();
```

We will replace the comment written above with this:

```php
<?php foreach ($get_project_list as $item) { ?>
<option value="<?php echo $item['id'] ?>"><?php echo $item['title'] ?></option>
<?php } ?>
```

# Form handling
Next, we’ll handle the form submission.

The full code after `$get_project_list` should look like this:

```php
if (isset($_POST['submit'])) {
            $id = trim($_POST['project']);
            $title = trim($_POST['title']);
            $date = $_POST['date'];
            $time = $_POST['time'];

            $sql =  'INSERT INTO tasks(project_id, title, date_task, time_task) VALUES(:id, :title, :date, :time)';
            $statement = $connection->prepare($sql);

            if (empty($id) || empty($title) || empty($date) || empty($time)) {
                $error_message = "One or more fields empty";
            } else {
                $new_project = array(
                    'id' => $id,
                    'title' => $title,
                    'date' => $date,
                    'time' => $time
                );

                $statement->execute($new_project);

                $confirm_message = 'Added successfully';
            }}
```

# Run the application 
Now let’s run our code.

In case of success, we’ll get this image:

# The task form
We’ll create a new file called `task.php` from `project.php`. Let’s add the form:

```html
 <label for="project">Project</label>
 <select name="project" id="project">
   <option value="">Select a project</option>
   
 </select>
 <label for="title">Title</label>
 <input type="text" placeholder="New task" name="title" id="title">
 <label for="date">Date</label>
 <input type="date" placeholder="New task" name="date" id="date">
<label for="time">Time</label>
<input type="number" name="time" id="time">
```
`` will be replaced by the project titles, which will be fetched from the `projects` table.

On top of the file, inside the  `try/catch` block, we will fetch data like this:

```php
$sql = 'SELECT * FROM projects ORDER BY title';
$get_project_list = $connection->query($sql)->fetchAll();
```

We will replace the comment written above with this:

```php
<?php foreach ($get_project_list as $item) { ?>
<option value="<?php echo $item['id'] ?>"><?php echo $item['title'] ?></option>
<?php } ?>
```

# Form handling
Next, we’ll handle the form submission.

The full code after `＄get_project_list` should look like this:

```php
if (isset($_POST['submit'])) {
            $id = trim($_POST['project']);
            $title = trim($_POST['title']);
            $date = $_POST['date'];
            $time = $_POST['time'];

            $sql =  'INSERT INTO tasks(project_id, title, date_task, time_task) VALUES(:id, :title, :date, :time)';
            $statement = $connection->prepare($sql);

            if (empty($id) || empty($title) || empty($date) || empty($time)) {
                $error_message = "One or more fields empty";
            } else {
                $new_project = array(
                    'id' => $id,
                    'title' => $title,
                    'date' => $date,
                    'time' => $time
                );

                $statement->execute($new_project);

                $confirm_message = 'Added successfully';
            }}
```

# Run the application 
Now let’s run our code.

In case of success, we’ll get this image:

Introduction

App Initialization

Create and Read Records

Refactor the Application

PHP Data Validation

Generate Reports

Update and Delete Records

PHP Router

Conclusion

Appendix

Add a Task

The task form