'Codeigniter: Import Excel Display data duplicates

Hi Good Evening I'm Using Phpspreadsheet codeigniter. After the import of excel file i need to check the data in the excel if the data is already exist in the database and display it. My problem is it already work but sadly it only display 1 duplicate i want to display all duplicates

Simple output only 1 duplicate

The Excel File with data

The Table

Controller:

public function spreadsheet_import()
{
    $upload_file=$_FILES['upload_file']['name'];
    $extension=pathinfo($upload_file,PATHINFO_EXTENSION);
    if($extension=='csv')
    {
        $reader= new \PhpOffice\PhpSpreadsheet\Reader\Csv();
    } else if($extension=='xls')
    
    {
        $reader= new \PhpOffice\PhpSpreadsheet\Reader\Xls();
    } else

    {
        $reader= new \PhpOffice\PhpSpreadsheet\Reader\Xlsx();
    }
    $spreadsheet=$reader->load($_FILES['upload_file']['tmp_name']);
    $sheetdata=$spreadsheet->getActiveSheet()->toArray();
    $sheetcount=count($sheetdata);
    $ben=$this->Nlfo_models->product_list();
    if($sheetcount>1)
    
       {
        $data=array();
        for ($i=1; $i < $sheetcount; $i++) { 
            $f_name=$sheetdata[$i][1];
            $m_name=$sheetdata[$i][2];
            $l_name=$sheetdata[$i][3];
            $data[]=array(
                'f_name'=>$f_name,
                'm_name'=>$m_name,
                'l_name'=>$l_name,
            );
            
            
            $this->db->where('f_name',$f_name);
            $this->db->where('m_name',$m_name);
            $this->db->where('l_name',$l_name);
            $query = $this->db->get('tbl_benificary');
            if ($query->num_rows() > 0){
                $display=$this->db->select('*')
                    ->from('tbl_benificary')
                    ->where('f_name',$f_name)
                    ->where('m_name',$m_name)
                    ->where('l_name',$l_name)
                    ->get()
                    ->result_array();
                foreach ($display as $value) {
                    var_dump($value['f_name']);
                }
                return true;
            }
             else{
                echo "cute";
                return false;
                  }
        }
    }
}


Sources

This article follows the attribution requirements of Stack Overflow and is licensed under CC BY-SA 3.0.

Source: Stack Overflow

Solution Source