使用codeigniter显示大量数据

Question

I use this code to display data according to the user who is logged in, and display their data. but with this syntax the data that appears does not match the defined data, and also other user data sometimes appears too.

$id=$this->session->userdata('ses_id');

    $this->db->SELECT('*');
    $this->db->from('doc_priv_std');

    $this->db->join('acc',' doc_priv_std.id_acc=acc.id_acc');

    $this->db->where('doc_priv_std.id_acc ',$id,('and 
    type_doc LIKE "%.doc%" 
    or "%.docx%" 
    or "%.pdf" 
    or "%.xls%" 
    or "%.xlsx%" 
    or "%.ppt%" 
    or "%.pptx%" 
    or "%.zip%" 
    or "%.rar%"'));

    $query = $this->db->get();
    return $query->result_array();

please help so that the data that appears as defined.

Answer 1

Your syntax is wrong - you can't do this with your way - you have to organise your Query properly - try the following

$id=$this->session->userdata('ses_id');

$arrExtension = ['.docx', '.pdf', '.xls', '.xlsx', '.ppt', '.pptx', '.zip', '.rar'];

$this->db
    ->select('*')
    ->from('doc_priv_std')
    ->join('acc',' doc_priv_std.id_acc=acc.id_acc')
    ->where('acc.id_acc', $id)
    ->group_start();

foreach($arrExtension AS $strExtension)
{
    $this->db->or_like('type_doc', $strExtension);
}
$query = $this->db->group_end()->get();
return $query->result_array();