[eluser]chiquitta[/eluser]
I am new in Codeigniter!
I use PHPexcel to upload , read and insert data to my database
but i don't know how to use [view] i only use [model] and [controller]
i cant understand how to separate the code into [view].
so I did a stupid way to deal with, but it's very ugly without any css.
please help me!
Code:
function read()
{
$rows = array('id','sku','name','description','created_on','enabled');
$KeyWord_sku = 'sku';
$KeyWord_mac = 'name';
$KeyWord_des = 'description';
$fileName = EXCELFILE_PATH.'MyExcel.xlsx';
$filename = $_FILES['userfile']['name'];
$Exsel_data = $this->excel->read($fileName,$rows);
//$this->FilterExsel($Exsel_data,$KeyWord_sku);
$DB_data = $this->mexcel->selUsers();
if(!empty($DB_data))
{
//$this->load->view('preview_form',$Exsel_data);
$DataKeyArray = $this->getKeyValue($DB_data,$KeyWord_sku,$KeyWord_mac,$KeyWord_des);
$dataChange = $this->dataChange($DB_data,$KeyWord_sku,$KeyWord_mac,$KeyWord_des);
}
echo '<table border=1>
<tr>
<th colspan=4>'.$filename.'</th>
</tr>
<tr>
<th>Serial Number</th>
<th>mac</th>
<th>description</th>
<th>status</th>
</tr>';
foreach($Exsel_data as $Ekey =>$Evalue)
{
if(!$this->arrayEmpty($Evalue))
{
if(!empty($DB_data) && $this->isExist($Evalue,$KeyWord_sku,$DataKeyArray))
{
if(!$this->isChange($Evalue,$dataChange,$KeyWord_sku))
{
echo '<td>'.$Evalue[$KeyWord_sku].'</td><td>'.$Evalue[$KeyWord_mac].'</td><td><center>'.$Evalue[$KeyWord_des].'</center></td><td>Already exist.<tr>';
}
}
else
{
if($this->addExcel($Evalue))
echo 'add dataļ¼'.$Evalue[$KeyWord_sku].' '.$Evalue[$KeyWord_mac].' '.$Evalue[$KeyWord_des].' success'.'<br>';
}
}
}
echo '</table>';
//echo 'data import success';
}