'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
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 |
|---|
