Articles → PHP CODEIGNITER → Active Records In Codeigniter

Active Records In Codeigniter

In this article, we will discuss active record in codeigniter.

Purpose

Active records is a concise way of writing database code.

Example

See the following example

<?php
class mymodel extends CI_Model
{
    public function GetUsers()
    {
        $this
            ->load
            ->database();

        $q = $this
            ->db
            ->get_where("Class", array(
            'classCode' => 'LKG'
        ));
        $result = $q->result();

        return $result;
    }
}

In the above code, we have only mentioned the table and column name but not the complete query.

Here is the output

Picture showing the output of active records in codeigniter

Click to Enlarge

Advantages Of Active Record

Following are advantages of active records

Less code writing.
Database independent.
Safe against SQL injection.

Posted By -	Karan Gupta

Posted On -	Friday, July 17, 2020

Query/Feedback

Your Email Id		**

Subject		*

Query/Feedback	Characters remaining 250	**