|
![](/images/resource/spacer.gif) |
|
รบกวนสอบถามการimport ข้อมูลจากไฟล์ csv ไป mysql หน่อยครับ |
|
![](/images/resource/viewboard_01.gif?v=1001) |
|
|
![](/images/resource/viewboard_03.gif?v=1001) |
![](/images/resource/viewboard_04.gif?v=1001) |
|
ได้ครับ
Code (PHP)
$Sheet = $objPHPExcel->getActiveSheet()->toArray(null,true,true,true);
///////////////////////////////////////////////////////////
$ix = 0;
foreach($Sheet as $i=>$ro){
if($ix){ // บันทัดแรกไม่เอา
$fld = array(
'id'=>$ro['A'],
'sec_id'=>$ro['B'],
'question'=>$ro['C'],
'c1'=>$ro['D'],
'c2'=>$ro['E'],
'c3'=>$ro['F'],
'c4'=>$ro['G'],
'answer'=>$ro['H'],
);
$this->db->replace('hk_test', $fld);
}
$ix++;
}
|
![](/images/resource/blockviewtopic_01.gif?v=1001) |
![](/images/resource/blockviewtopic_02.gif?v=1001) |
![](/images/resource/blockviewtopic_03.gif?v=1001) |
![](/images/resource/blockviewtopic_04.gif?v=1001) |
Date :
2016-09-02 12:08:56 |
By :
Chaidhanan |
|
![](/images/resource/blockviewtopic_06.gif?v=1001) |
![](/images/resource/blockviewtopic_07.gif?v=1001) |
![](/images/resource/blockviewtopic_08.gif?v=1001) |
![](/images/resource/blockviewtopic_09.gif?v=1001) |
|
|
![](/images/resource/viewboard_06.gif?v=1001) |
![](/images/resource/viewboard_07.gif?v=1001) |
|
![](/images/resource/viewboard_08.jpg?v=1001) |
![](/images/resource/viewboard_09.gif?v=1001) |
|
|
|
![](/images/digitalocean-banner.jpg)
|
Load balance : Server 01
|