Reading Time: 5 minutes

2,817 Views

Inside this tutorial we will see CakePHP 4 Insert Table Row using model and entity. We will use the concept of Model and entity of CakePHP and see how to insert a table row. Article contains classified information about this insert concept.

There are several ways to insert data into database table – Using Query Builder, Using Model & Entity, etc.

Suppose we have a table called products into database. Table products have these columns – ( id, name, cost, description, status ). We will create model and entity for this table and see how to insert a new row into it.

Learn More –

Let’s get started.

CakePHP 4 Installation

To create a CakePHP project, run this command into your shell or terminal. Make sure composer should be installed in your system.

$ composer create-project --prefer-dist cakephp/app:~4.0 mycakephp

Above command will creates a project with the name called mycakephp.

Create Database

To create a database, either we can create via Manual tool of PhpMyadmin or by means of a mysql command.

CREATE DATABASE mydatabase;

Successfully, we have created a database.

Database Connection

Open app_local.php file from /config folder. Search for Datasources. Go to default array of it.

You can add your connection details here to connect with your database. It will be like this –

//...

'Datasources' => [
        'default' => [
            'host' => 'localhost',
            /*
             * CakePHP will use the default DB port based on the driver selected
             * MySQL on MAMP uses port 8889, MAMP users will want to uncomment
             * the following line and set the port accordingly
             */
            //'port' => 'non_standard_port_number',

            'username' => 'root',
            'password' => 'sample@123',

            'database' => 'mydatabase',
            /*
             * If not using the default 'public' schema with the PostgreSQL driver
             * set it here.
             */
            //'schema' => 'myapp',

            /*
             * You can use a DSN string to set the entire configuration
             */
            'url' => env('DATABASE_URL', null),
        ],
  
     //...

//...

You can pass host, username, password and database.

Successfully, you are now connected with the database.

Create Model & Entity

Open project into terminal and run this bake console command –

$ bin/cake bake model Products --no-rules --no-validation

It will create several files like Model, Entity, Test & Fixture.

Model class file ProductsTable.php is inside /src/Model/Table folder. Entity class file Product.php is inside /src/Model/Entity folder.

Code for Model class file.

<?php
declare(strict_types=1);

namespace App\Model\Table;

use Cake\ORM\Table;

class ProductsTable extends Table
{
    /**
     * Initialize method
     *
     * @param array $config The configuration for the Table.
     * @return void
     */
    public function initialize(array $config): void
    {
        parent::initialize($config);

        $this->setTable('products');
        $this->setPrimaryKey('id');
    }
}

Code for Entity class file.

<?php
declare(strict_types=1);

namespace App\Model\Entity;

use Cake\ORM\Entity;

/**
 * Product Entity
 *
 * @property int $id
 */
class Product extends Entity
{
    protected $_accessible = [
        'name' => true,
        'cost' => true,
        'description' => true,
        'status' => true,
    ];
}

Create Controller

To create controller we will use bake console command –

$ bin/cake bake controller Sites --no-actions

It will create a file SitesController.php inside /src/Controller folder.

Next,

To use model into controller we need to load it first.

$this->loadModel("Products");

Let’s see the complete code of controller –

<?php

declare(strict_types=1);

namespace App\Controller;

class SitesController extends AppController
{
    public function initialize(): void
    {
        parent::initialize();
        $this->loadModel("Products");
        $this->autoRender = false;
    }

    public function addProduct()
    {
        $queryObject = $this->Products->query();

        $queryObject->insert(["name", "cost", "description", "status"])
        ->values([
            "name" => "Sample Product 1003",
            "cost" => 800,
            "description" => "Sample product content",
            "status" => 1
        ])
        ->execute();
    }
}

Method #1

To insert data into database table we can see this concept. Here only model has been used to insert.

public function addProduct()
{
    $queryObject = $this->Products->query();

    $queryObject->insert(["name", "cost", "description", "status"])
    ->values([
        "name" => "Sample Product 1003",
        "cost" => 800,
        "description" => "Sample product content",
        "status" => 1
    ])
    ->execute();
}

We have also two more ways to insert data.

Method #2

Insert row using Model and Entity, we use this code.

public function addProduct()
{
    $productEntity = $this->Products->newEmptyEntity();

    $productEntity->name = "Sample Product 1001";
    $productEntity->cost = 500;
    $productEntity->description = "Sample Product content";
    $productEntity->status = 1;

    $this->Products->save($productEntity);
}

Method #3

Insert row using Model and Entity, again we can use this code.

public function addProduct()
{
    $productEntity = $this->Products->newEmptyEntity();

    $product_data = [
        "name" => "Sample Product 1002",
        "cost" => 750,
        "description" => "Sample product content",
        "status" => 1
    ];

    $productEntity = $this->Products->patchEntity($productEntity, $product_data);

    $this->Products->save($productEntity);
}

So, here we can see we have these above options by which we can insert row into database table. This is only using model and entity. Query builder is a different way than this.

We hope this article helped you to learn about CakePHP 4 Insert Table Row Using Model And Entity Tutorial in a very detailed way.

Online Web Tutor invites you to try Skillshike! Learn CakePHP, Laravel, CodeIgniter, Node Js, MySQL, Authentication, RESTful Web Services, etc into a depth level. Master the Coding Skills to Become an Expert in PHP Web Development. So, Search your favourite course and enroll now.

If you liked this article, then please subscribe to our YouTube Channel for PHP & it’s framework, WordPress, Node Js video tutorials. You can also find us on Twitter and Facebook.