1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31 32 33 34 35 36 37 38 39 40 41 42 43 44 45 46 47 48 49 50 51 52 53 54 55 56 57 58 59 60 61 62 63 64 65 66 67 68 69 70 71 72 73 74 75 76
|
<?php
// ouverture du fichier
$fichier = @fopen("easypopulate.csv", "r");
if ($fichier) {
// lecture de la premiere ligne 4096
$buffer = fgets($fichier, 10096);
// lecture des lignes suivantes
while (!feof($fichier)){
$buffer = fgets($fichier, 10096);
// suppression des guillemets
$buffers=str_replace('"','',$buffer);
//
@list($val1, $val2, $val3, $val4, $val5, $val6, $val7, $val8, $val9, $val10, $val11, $val12, $val13, $val14, $val15, $val16, $val17, $val18, $val19, $val20, $val21) = explode(";", $buffers);
//les valeurs de la table product_description
$products_id="";
$products_model="$val2";
$products_image="$val3";
$products_name="$val4";
$products_description="$val5";
$products_image2="$val6";
$products_image3="$val7";
$products_image4="$val8";
$products_image5="$val9";
$products_price_label="$val10";
$products_ppc="$val11";
$products_weight="$val12";
$products_date_available="$val13";
$products_date_added="$val14";
$products_quantity="$val15";
$products_last_modified="";
$products_status="";
$manufacturers_id="";
$products_ordered="";
$language_id=4;
// TVA 19.6
if ($val19="TVA 19.6 Tout Produit"){
$products_price=$products_price_label/1.196;
$products_tax_class_id="1";
}
// TVA 2.10
if ($val19=="TVA 2.10 Tout Produit"){
$products_price=$products_price_label/1.021 ;
$products_tax_class_id="2";
}
// TVA 5.5
if ($val19=="TVA 5.5 Tout Produit"){
$products_price=$products_price_label/1.055 ;
$products_tax_class_id="3";
}
include "config.php";
//
$sql= "INSERT INTO products(products_id, products_quantity, products_model, products_image, products_price, products_price_label, products_date_added, products_last_modified, products_date_available, products_weight, products_status, products_tax_class_id, manufacturers_id, products_ordered, products_ppc, products_image2, products_image3, products_image4, products_image5) VALUES ('', '$products_quantity', '$products_model', '$products_image', '$products_price', '$products_price_label', '$products_date_added', '$products_last_modified', '$products_date_available', '$products_weight', '$products_status', '$products_tax_class_id', '$manufacturers_id', '$products_ordered', '$products_ppc', '$products_image2', '$products_image3', '$products_image4', '$products_image5')";
mysql_query($sql) or die('Erreur SQL !'.$sql.'<br>'.mysql_error());
//
$sql = "INSERT INTO products_description(products_id, language_id, products_name, products_description) VALUES('','$language_id','$products_name','$products_description')";
mysql_query($sql) or die('Erreur SQL !'.$sql.'<br>'.mysql_error());
}
// fermeture du fichier
fclose($fichier);
}
?> |
Partager