Skip to content

CommonModel for CodeIgniter 4: A reusable model to streamline common database operations in CodeIgniter 4. Simplifies tasks like selecting, inserting, updating, and deleting records. Supports JOINs, WHERE conditions, LIKE queries, and more, making database management efficient and straightforward.

Notifications You must be signed in to change notification settings

bertugfahriozer/ci4commonModel

Folders and files

NameName
Last commit message
Last commit date

Latest commit

 

History

23 Commits
 
 
 
 
 
 
 
 
 
 

Repository files navigation

CommonModel is a versatile and reusable model for CodeIgniter 4, designed to simplify common database operations such as selecting, inserting, updating, and deleting records. This library provides methods that support common SQL features like JOINs, WHERE conditions, LIKE filters, and ordering.

To use CommonModel in your CodeIgniter 4 project, follow these steps:

  1. Install with Composer into your project:

    composer require bertugfahriozer/ci4commonmodel
  2. Load the model in your controller:

    use ci4commonmodel\Models\CommonModel;
    
    class ExampleController extends BaseController
    {
        protected $commonModel;
    
        public function __construct()
        {
            $this->commonModel = new CommonModel();
        }
    }

The lists method allows you to fetch records from a database table with flexible filters such as WHERE, OR WHERE, LIKE, JOIN, and ordering. Optionally, limit and pagination can be applied.

$data = [
    'name' => 'John Doe',
    'email' => '[email protected]',
    'status' => 1
];

$insertId = $this->commonModel->create('users', $data);

Insert a single record into the database and return the newly inserted ID.

$data = [
    'name' => 'John Doe',
    'email' => '[email protected]',
    'status' => 1
];

$insertId = $this->commonModel->create('users', $data);

Insert multiple records at once with the createMany method.

$data = [
    ['name' => 'Alice', 'email' => '[email protected]'],
    ['name' => 'Bob', 'email' => '[email protected]']
];

$this->commonModel->createMany('users', $data);

Update existing records by specifying the WHERE conditions and the new data.

$data = ['status' => 2];
$where = ['id' => 1];

$this->commonModel->edit('users', $data, $where);

Delete records from a table based on WHERE conditions.

$where = ['id' => 1];
$this->commonModel->remove('users', $where);

Count the number of records that match a given condition.

$where = ['status' => 1];
$count = $this->commonModel->count('users', $where);

Check whether a record exists in a table with a specified condition.

$where = ['id' => 1];
$isExist = $this->commonModel->isHave('users', $where);

Use research for searching records using LIKE queries and filtering by conditions.

$like = ['name' => 'John'];
$where = ['status' => 1];

$results = $this->commonModel->research('users', $like, '*', $where);

This project is licensed under the MIT License. See the LICENSE file for more details.

Bertuğ Fahri ÖZER

About

CommonModel for CodeIgniter 4: A reusable model to streamline common database operations in CodeIgniter 4. Simplifies tasks like selecting, inserting, updating, and deleting records. Supports JOINs, WHERE conditions, LIKE queries, and more, making database management efficient and straightforward.

Topics

Resources

Stars

Watchers

Forks

Languages