Cari Lihat Baca Pelajari Praktik Simpan

Untuk menggunakan query kita gunakan perintah seperti ini

        $this->db->query();
    

Berikut Format perintahnya

        $this->db->query('YOUR QUERY HERE');
    

Contoh lebih komplit dengan mengambil seluruh field yang ada < span class=text-warning>*)Tidak disarankan< /span>

        $query = $this->db->query(select * from tbl_user);
    

Atau bisa juga dengan perintah seperti ini

        $sql = SELECT * FROM tbl_user WHERE name = ? AND type = ?; 
        $this->db->query($sql, array('code', 'php'));
    

Weeh ... udah mulai puyeng ya... Baik kita lanjutkan beberapa cara pengambilan record dengan Aktif Record Query Ex.

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

Metode Pertama

        $this->db->select('name'); 
        $query = $this->db->get('tbl_user');
    

Atau

        $query = $this->db->select('name')
                    ->from('tbl_user')
                    ->get();
    

Query dengan limit 1

        $limit=10;
        $query = $this-> db-> get('tbl_user',$limit); 
    

Query dengan limit 2 Ex. limit 5 record

        $this->db->select('id, name');
        $this->db->from('tbl_user');
        $limit=5;
        $query = $this->db->get('tbl_user',$limit); 
    

Query dengan limit 3 dengan offset

        $this->db->select('id, name');
        $this->db->from('tbl_user');
        $limit=5;
        $offset	= 20;
        $query = $this->db->get('tbl_user',$offset,$limit); 
    

Query menggunakan select from

        $this->db->select('id, name');
        $this->db->from('tbl_user');
        $query = $this->db->get();
    

Query dengan optain Where, Or_Where, Where_In, or_where_in, where_not_in Code 1

        $this->db->select('username');
        $this->db->from('tbl_user');
        $this->db->where('userid',11);
        $this->db->where(usertype,admin);
        $query=$this->db->get();
    

Code 2

        $this->db->select('username');
        $this->db->from('tbl_user');
        $this->db->where('userid',11);
        $this->db->where(usertype !=,admin);
        $query=$this->db->get();
    

Code 3

        $this->db->select('username');
        $this->db->from('tbl_user');
        $this->db->where(userid > 11 AND usertype='user');
        $query=$this->db->get();
    

Code 4

        $this->db->from('tbl_user');
        $this->db->where('username !=', $name);
        $this->db->or_where('userid >', $userid);
    

Code 5

        $names = array('name1', 'name2', 'name3');
        $this->db->from('tbl_user');
        $this->db->where('status !=', $status);
        $this->db->or_where_in('username', $names);
    

Code 6

        $names = array('name1', 'name2', 'name3');
        $this->db->from('tbl_user');
        $this->db->where_not_in('username', $names);
    

Code 7

        $names = array('name1', 'name2', 'name3');
        $this->db->from('tbl_user');
        $this->db->where('status !=', $status);
        $this->db->or_where_not_in('username', $names);
    

Tambahan lebih njlimet lagi ..... Contoh Code

        $status='admin';
        $options=array('usertype'=>$status);
        $query =  $this->db->get_where('tbl_user',$options);
        $limit=10;
        $query =  $this->db->get_where('tbl_user',$options,$limit);
    

Query untuk Like, or_like, not_like, or_not_like Code 1

        $this->db->select('username');
        $this->db->from('tbl_user');
        $this->db->like(username,code);
        $query=$this->db->get();
    

Code 2

        $this->db->select('username,userid');
        $this->db->from('tbl_user');
        $this->db->like('username','code');
        $this->db->or_like('usertype','admin');
        $query=$this->db->get();
    

Code 3

        $this->db->select('username,userid');
        $this->db->from('tbl_user');
        $this->db->not_like('username','code');
        $this->db->or_like('usertype','admin');
        $query=$this->db->get();
    

Code 4

        $this->db->select('username,userid');
        $this->db->from('tbl_user');
        $this->db->where('status','active');
        $this->db->or_not_like('username','code');
        $query=$this->db->get();
    

Query dengan Grouping .... Group_By

        $this->db->select('*');
        $this->db->from('tbl_user');
        $this->db->group_by(states); 
    

Query dengan having

        $this->db->select('*');
        $this->db->from('tbl_user');
        $this->db->having(states=1);
        //SELECT * FROM (`tbl_user`) HAVING states=1
    

Query dengan order_by Kode 1

        $this->db->select('username');
        $this->db->from('tbl_user');
        $this->db->order_by('username');
        $query=$this->db->get();
        //SELECT `username` FROM (`tbl_user`) ORDER BY `username`
    

Kode tambahan opsi untuk asc dan desc

        $this->db->select('username');
        $this->db->from('tbl_user');
        $this->db->order_by('username','desc');
        $query=$this->db->get();
        //SELECT `username` FROM (`tbl_user`) ORDER BY `username` desc
    

Query - Fungsi matematik

        $this->db->select_max('age');
        $query = $this->db->get('tbl_user');
        //SELECT MAX(age) as age FROM tbl_user
    

        $this->db->select_max('age', 'userage');
        $query = $this->db->get('tbl_user');
        //SELECT MAX(age) as userage FROM tbl_user
    

        $this->db->select_min('age');
        $query = $this->db->get('tbl_user');
        //SELECT MIN(age) as age FROM tbl_user
    

        $this->db->select_sum('age');
        $query = $this->db->get('tbl_user');
        //SELECT SUM(age) as age FROM tbl_user
    

Query - Join table seperti left, right, outer, inner, left outer, and right outer Kode standart

        $this->db->select('*');
        $this->db->from('comments');
        $this->db->join('tbl_user', 'tbl_user.id = comments.id');

        $query = $this->db->get();
        // SELECT * FROM comments
        // JOIN tbl_user ON tbl_user.id = comments.id
    

Query - Hitung jumlah record

        $query_str=SELECT * FROM tbl_user t limit 50;
        $query=$this->db->query($query_str);
        if(query->num_rows()){
        // work process
        }
    

Query - Hitung jumlah Field dalam tabel

        $query = $this->db->query('SELECT * FROM tbl_user');
        echo $query->num_fields();
    

Implementasi Query dengan result()

        $query_str=SELECT * FROM tbl_user t limit 50;
        $query=$this->db->query($query_str);
        foreach ($query- >result() as $row)
        {  
        echo $row- > name;  
        echo $row- > age;  
        echo $row- > groupname; 
        } 
    

Implementasi Query dengan result_array()

        $query_str=SELECT * FROM tbl_user t limit 50;
        $query=$this->db->query($query_str);

        foreach ($query->result_array() as $row)
        {  
        echo $row['name'];
        echo $row['gag'];
        echo $row['groupname'];
        }
    

Implementasi Query dengan single result()

        $query_str=SELECT * FROM tbl_user t limit 50;
        $query=$this->db->query($query_str);
        // fetch one row data
        $record=$query->row();
        echo $record->name;
        echo $record->age;
        echo $record->groupname;
        // alternative method 
        $record=$query->row_array();
        echo $record['name'];
        echo $record['age'];
        echo $record['groupname'];
    

Query jumlah record

        echo $this->db->count_all('tbl_user');
        // Produces an integer, like 280174
    

.

Pencarian Serupa di Google untuk Komplet MySQL Query