indem du deine Schleife ein wenig umbaust - Achtung ich hab noch etwas geändert, damit die erste Zeile aus der csv mit den Spaltenköpfen ignoriert wird
PHP-Code:
$query = "INSERT INTO dtg_shop
(Shop,
ProductId,
ProgramId,
MerchantProductNumber,
ProductName,
ProductPrice,
ProductLongDescription,
Status,
MerchantProductCategory,
ZanoxProductCategory,
ImageSmallURL,
ImageMediumURL,
ProductManufacturerBrand,
ZanoxProductLink,
ZanoxProductCategoryNumber,
MerchantProductCategoryNumber,
DeliveryTime,
TermsOfContract,
ProductEAN,
ProductPriceOld,
CurrencySymbolOfPrice,
UpdateDate,
ValidFromDate,
ValidToDate,
ProductShortDescription,
ImageLargeURL) VALUES ";
$cc=0;
while( !feof($fp) ) {
$zeile = fgetcsv ( $fp , 4096 , ";" );
if ($cc>0) {
$values = " ('".mysql_real_escape_string($zeile[Shop])."',
'".mysql_real_escape_string($zeile[ProductId])."',
".mysql_real_escape_string($zeile[ProgramId]).",
".mysql_real_escape_string($zeile[MerchantProductNumber]).",
'".mysql_real_escape_string($zeile[ProductName])."',
'".mysql_real_escape_string($zeile[ProductPrice])."',
'".mysql_real_escape_string($zeile[ProductLongDescription])."',
".mysql_real_escape_string($zeile[Status]).",
'".mysql_real_escape_string($zeile[MerchantProductCategory])."',
'".mysql_real_escape_string($zeile[ZanoxProductCategory])."',
'".mysql_real_escape_string($zeile[ImageSmallURL])."',
'".mysql_real_escape_string($zeile[ImageMediumURL])."',
'".mysql_real_escape_string($zeile[ProductManufacturerBrand])."',
'".mysql_real_escape_string($zeile[ZanoxProductLink])."',
'".mysql_real_escape_string($zeile[ZanoxProductCategoryNumber])."',
'".mysql_real_escape_string($zeile[MerchantProductCategoryNumber])."',
'".mysql_real_escape_string($zeile[DeliveryTime])."',
'".mysql_real_escape_string($zeile[TermsOfContract])."',
'".mysql_real_escape_string($zeile[ProductEAN])."',
'".mysql_real_escape_string($zeile[ProductPriceOld])."',
'".mysql_real_escape_string($zeile[CurrencySymbolOfPrice])."',
'".mysql_real_escape_string($zeile[UpdateDate])."',
'".mysql_real_escape_string($zeile[ValidFromDate])."',
'".mysql_real_escape_string($zeile[ValidToDate])."',
'".mysql_real_escape_string($zeile[ProductShortDescription])."',
'".mysql_real_escape_string($zeile[ImageLargeURL])."' )";
echo $query.$values."<br>";
mysql_unbuffered_query($query.$values) or die(mysql_error());
}
$cc++;
}
Kommentar