CRUD Operations in PHP

PHPMyAdmin is a powerful tool for managing databases. In this tutorial, we will demonstrate CRUD (Create, Read, Update, Delete) operations using PHP and MySQL.

First, let's create a database named `php_oop_crud_level_1`. We will also include sample data in our database.

Creating Tables

To create tables, we will use SQL statements. Let's start by creating the `categories` table:

```sql

INSERT INTO `categories` (`id`, `name`, `created`, `modified`) VALUES

(1, 'Electronics', NOW(), NOW()),

(2, 'Clothing', NOW(), NOW());

```

Next, we will create the `products` table:

```sql

INSERT INTO `products` (`id`, `name`, `description`, `price`, `category_id`, `created`, `modified`) VALUES

(1, 'Samsung TV', 'A high definition TV from Samsung', 500.00, 1, NOW(), NOW()),

(2, 'Nike Shoes', 'A pair of comfortable shoes from Nike', 100.00, 2, NOW(), NOW());

```

CRUD Operations

Now that we have created our tables and sample data, let's move on to CRUD operations.

### Create Operation

To create a new record, we will use the `insert()` method:

```php

$product = new Product();

$product->name = 'Apple Watch';

$product->description = 'A smartwatch from Apple';

$product->price = 200.00;

$product->category_id = 1;

if ($product->save()) {

echo 'Product created successfully!';

} else {

echo 'Error creating product!';

}

```

### Read Operation

To read a record, we will use the `readOne()` method:

```php

$product = Product::readOne(1);

echo $product->name;

```

This will retrieve the product with ID 1 and display its name.

### Update Operation

To update a record, we will use the `update()` method:

```php

$product = Product::readOne(1);

$product->description = 'A high definition TV from Samsung';

$product->price = 600.00;

if ($product->save()) {

echo 'Product updated successfully!';

} else {

echo 'Error updating product!';

}

```

### Delete Operation

To delete a record, we will use the `delete()` method:

```php

$product = Product::readOne(2);

$product->delete();

echo 'Product deleted successfully!';

```

This will retrieve the product with ID 2 and delete it from the database.

In this tutorial, we have demonstrated CRUD operations using PHP and MySQL. We created a database named `php_oop_crud_level_1`, included sample data, and performed various CRUD operations such as creating, reading, updating, and deleting records. This is just the beginning of our journey with CRUD operations in PHP. In future tutorials, we will explore more advanced topics and best practices for building robust and scalable applications.

Crud operations in php