How to call Database Class in Expression Engine?

Question

I started to learn Expression Engine.

I want to get some data from the database. How do I have to use the database class to achieve that?

I would be glad to get a very detailed example.

Answer 1

Refer this site for details of data base related doubts regarding Expression Engine.

Database class

Selecting the active recod

    $query = ee()->db->select('username,email,mobile_number')
    ->from('members')
    ->get(); 

*It’s highly recommended that you use CodeIgniter’s Active Record because queries will be easier to read and edit *