Active Records

1. To query a table, type:

    $query = $this->db->get('table_name');

    foreach($query->result() as $row)

    {

        echo $row->id;

        echo $row->name;

    }

2.To insert data to a table,use:

    $data = array(

        'id'=>'1',

        'name'=>'lady gaga'

    );

    $this->db->insert('table_name',$data);