Question 250319 in PHP Question posted in
Official manual can be found here.

Php – Model->insert($data) not inserting data into database

I’m using CodeIgniter v4.4.1. I’m trying to insert Customers into my MySQL database. My Customer table has only two columns for now (for testing): idcustomer (primary key, not null, auto increment), and name (varchar(45)). That’s working fine.

My Customer model looks like this:

<?php namespace AppModels;

use CodeIgniterModel;

class Customer extends Model
{
    protected $table = 'customers';
    protected $primaryKey = 'idcustomer';
    protected $returnType = 'array';
    protected $useTimestamps = false;
    protected $allowedFields = ['name'];
}

In my controller,

<?php

namespace AppControllers;

use AppControllersBaseController;
// use CodeIgniterController;
use AppModelsCustomer;

class CustomerController extends BaseController
{
//...
    public function store()
    {
        $customerData = $this->request->getPost();

        // return view('customer/test', $customerData);
        // I used this line above to test if I had any data in $customerData, and I was able to access the data from the post request there. So up to here, everything is working fine.

        $customer = model('Customer');
    
        $customer->save([
            'name' => $customerData['name'],
        ]);

        return redirect()->to('/customers');
    }
//...
}

When I submit a form, the post request is submitted successfully, and I am even redirected to the /customers route (as indicated in the controller’s store() method. However, when I check my database, the new customer is not inserted. The database remains the same as it was before… I would have expected the new record to be created in the customer table.

I removed all validation to test, and it still is not working. I am not getting any errors, exceptions, or anything in the writable/logs.

So, I tried doing this in my controller:

public function store()
    {
        $customerData = $this->request->getPost();
        $customer = model('Customer');
    
        $customer->save([
            'idcustomer' => 22, // that is, an ID number that does not exist yet in my database (the highest existing ID is 5)
            'name' => $customerData['name'],
        ]);

        return redirect()->to('/customers');
    }

When I submit the form again, now a new entry is created, but, it is created with the idcustomer = 6.

Now, when I do:

$customer->save([
            'idcustomer' => 3, // an existing ID
            'name' => $customerData['name'],
        ]);

Then, the entry with idcustomer = 3 is modified (as expected).

I also tried the $customer->insert(...) and it’s not working either.

So, bottom line, my question is, why is a new record not inserted into the database when I do not pass in the idcustomer?

Tags:

2

Answers


  1. 0

    Try to change it like this:

        public function store()
{
    $customerData = $this->request->getPost();
    $customer = new Customer(); // Instantiate the Customer model

    $customer->insert([
        'name' => $customerData['name'],
    ]);

    return redirect()->to('/customers');
}
    Login or Signup to reply.
  2. 0

    $useAutoIncrement:
    Specifies if the table uses an auto-increment feature for $primaryKey. If set to false then you are responsible for providing primary key value for every record in the table. This feature may be handy when we want to implement 1:1 relation or use UUIDs for our model. The default value is true.

    You have to set this in your model-file (if this represents your db-schema) or you have to explicitly provide the primary key for every query.

    Login or Signup to reply.
Please signup or login to give your own answer.

Back To Top
Search