|
![](/images/resource/spacer.gif) |
|
มีปัญหาการ import file excel 2010 แล้วข้อมูลมันออกมาแค่ record เดียว |
|
![](/images/resource/viewboard_01.gif?v=1001) |
|
|
![](/images/resource/viewboard_03.gif?v=1001) |
![](/images/resource/viewboard_04.gif?v=1001) |
|
Code (PHP)
<?
$objConnect = mysql_connect("localhost","root","root") or die("Error Connect to Database");
$objDB = mysql_select_db("sellin");
$objcsv=fopen("Amorn.csv","r");
while(($objResult=fgetcsv($objcsv,1000,","))!==FALSE){
$strSQL = "INSERT INTO master ";
$strSQL .="(Dealercode1,Dealercode2,Dealercode3,Dealercode4,Name,Province) VALUES ('".$objResult[0]."','".$objResult[1]."','".$objResult[2]."','".$objResult[3]."','".$objResult[4]."','".$objResult[5]."')";
}
$objQuery = mysql_query($strSQL);
fclose($objcsv);
echo "Import Done"
?>
จากcode ด้านบนครับ พอผมทำแล้วมันมีข้อมูลมาแค่ record เดียวคือ record สุดท้ายครับ อยากรบกวนด้วยครับ
Tag : PHP
![](/images/adv.jpg?v=1001)
|
|
![](/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 :
2012-11-09 14:09:51 |
By :
theyounggun |
View :
927 |
Reply :
1 |
|
![](/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/resource/viewboard_01.gif?v=1001) |
|
|
![](/images/resource/viewboard_03.gif?v=1001) |
![](/images/resource/viewboard_04.gif?v=1001) |
|
เป็นเพราะ key ซ้ำหรือเปล่าครับ ลองดูนี่ครับ
Code (PHP)
$objQuery = mysql_query($strSQL) or die(mysql_error());
|
![](/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 :
2012-11-10 20:36:23 |
By :
mr.win |
|
![](/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 00
|