J ai besoin d'assistance
pink90
-
Freedomsoul Messages postés 538 Statut Membre -
Freedomsoul Messages postés 538 Statut Membre -
Bonjour, voici mon code sous easyphp5.2.10 et avec php version5 et surtout je vais vous spécifier les erreurs c'est urgents 'il vous plait celui qui a des idées qu'il me vienne en aide
if (file_exists( $filename)){
$fp = fopen("C:/Program Files/EasyPHP-5.3.3.1/www/test/tickets Oceane_jan_mai_20121.csv", "r+");
/* Et Hop on importe */
$i=0;
while (!feof($fp)){ /* Tant qu'on n'atteint pas la fin du fichier */
$ligne[$i] = fgetcsv($fp); /* On lit une ligne ceci en précisant qu'elle est lue jusqu'au dernier caractère */
/* On récupère les champs séparés par ; dans liste*/
$liste[] = explode( ";",$ligne[$i]);
/* On assigne les variables */
$num = $liste[0];
$Etat = $liste[1];
$typequip = $liste[2];
$equip = $liste[3];
$datedeb = $liste[4];
$dateret = $liste[5];
$detail = $liste[6];
$Identifiant_1_ress = $liste[7];
$Libel_imput = $liste[8];
$Identifiant_2_ress = $liste[9];
$Impact_ress = $liste[10];
$Famil_pb = $liste[11];
$Libel_suc = $liste[12];
$Nb_impact = $liste[13];
$Identifiant_1 = $liste[14];
/* Ajouter un nouvel enregistrement dans la table */
echo $typequip;
$query2 = "INSERT INTO oce_orig VALUES('$num','$Etat','$typequip','$equip','$datedeb','$dateret','$detail','$Identifiant_1_ress','$Libel_imput','$Identifiant_2_ress','$Impact_ress','$Famil_pb','$Libel_suc','$Nb_impact','$Identifiant_1')";
$result= MYSQL_QUERY($query2);
$i++;
}
}
else {
/* le fichier n'existe pas */
echo "Fichier introuvable !<br>Importation stoppée.";
exit();
}
les erreurs affichés sont:
Warning: explode() expects parameter 2 to be string, array given in C:\Program Files\EasyPHP-5.3.3.1\www\test\new 2.php on line 33
Notice: Undefined offset: 1 in C:\Program Files\EasyPHP-5.3.3.1\www\test\new 2.php on line 37
Notice: Undefined offset: 2 in C:\Program Files\EasyPHP-5.3.3.1\www\test\new 2.php on line 38
Notice: Undefined offset: 3 in C:\Program Files\EasyPHP-5.3.3.1\www\test\new 2.php on line 39
Notice: Undefined offset: 4 in C:\Program Files\EasyPHP-5.3.3.1\www\test\new 2.php on line 40
Notice: Undefined offset: 5 in C:\Program Files\EasyPHP-5.3.3.1\www\test\new 2.php on line 41
Notice: Undefined offset: 6 in C:\Program Files\EasyPHP-5.3.3.1\www\test\new 2.php on line 42
Notice: Undefined offset: 7 in C:\Program Files\EasyPHP-5.3.3.1\www\test\new 2.php on line 43
Notice: Undefined offset: 8 in C:\Program Files\EasyPHP-5.3.3.1\www\test\new 2.php on line 44
Notice: Undefined offset: 9 in C:\Program Files\EasyPHP-5.3.3.1\www\test\new 2.php on line 45
Notice: Undefined offset: 10 in C:\Program Files\EasyPHP-5.3.3.1\www\test\new 2.php on line 46
Notice: Undefined offset: 11 in C:\Program Files\EasyPHP-5.3.3.1\www\test\new 2.php on line 47
Notice: Undefined offset: 12 in C:\Program Files\EasyPHP-5.3.3.1\www\test\new 2.php on line 48
Notice: Undefined offset: 13 in C:\Program Files\EasyPHP-5.3.3.1\www\test\new 2.php on line 49
Notice: Undefined offset: 14 in C:\Program Files\EasyPHP-5.3.3.1\www\test\new 2.php on line 50
Warning: explode() expects parameter 2 to be string, array given in C:\Program Files\EasyPHP-5.3.3.1\www\test\new 2.php on line 33
Notice: Undefined offset: 2 in C:\Program Files\EasyPHP-5.3.3.1\www\test\new 2.php on line 38
Notice: Undefined offset: 3 in C:\Program Files\EasyPHP-5.3.3.1\www\test\new 2.php on line 39
Notice: Undefined offset: 4 in C:\Program Files\EasyPHP-5.3.3.1\www\test\new 2.php on line 40
Notice: Undefined offset: 5 in C:\Program Files\EasyPHP-5.3.3.1\www\test\new 2.php on line 41
Notice: Undefined offset: 6 in C:\Program Files\EasyPHP-5.3.3.1\www\test\new 2.php on line 42
Notice: Undefined offset: 7 in C:\Program Files\EasyPHP-5.3.3.1\www\test\new 2.php on line 43
Notice: Undefined offset: 8 in C:\Program Files\EasyPHP-5.3.3.1\www\test\new 2.php on line 44
Notice: Undefined offset: 9 in C:\Program Files\EasyPHP-5.3.3.1\www\test\new 2.php on line 45
Notice: Undefined offset: 10 in C:\Program Files\EasyPHP-5.3.3.1\www\test\new 2.php on line 46
Notice: Undefined offset: 11 in C:\Program Files\EasyPHP-5.3.3.1\www\test\new 2.php on line 47
Notice: Undefined offset: 12 in C:\Program Files\EasyPHP-5.3.3.1\www\test\new 2.php on line 48
Notice: Undefined offset: 13 in C:\Program Files\EasyPHP-5.3.3.1\www\test\new 2.php on line 49
Notice: Undefined offset: 14 in C:\Program Files\EasyPHP-5.3.3.1\www\test\new 2.php on line 50
Warning: explode() expects parameter 2 to be string, array given in C:\Program Files\EasyPHP-5.3.3.1\www\test\new 2.php on line 33
Notice: Undefined offset: 3 in C:\Program Files\EasyPHP-5.3.3.1\www\test\new 2.php on line 39
Notice: Undefined offset: 4 in C:\Program Files\EasyPHP-5.3.3.1\www\test\new 2.php on line 40
Notice: Undefined offset: 5 in C:\Program Files\EasyPHP-5.3.3.1\www\test\new 2.php on line 41
Notice: Undefined offset: 6 in C:\Program Files\EasyPHP-5.3.3.1\www\test\new 2.php on line 42
Notice: Undefined offset: 7 in C:\Program Files\EasyPHP-5.3.3.1\www\test\new 2.php on line 43
Notice: Undefined offset: 8 in C:\Program Files\EasyPHP-5.3.3.1\www\test\new 2.php on line 44
Notice: Undefined offset: 9 in C:\Program Files\EasyPHP-5.3.3.1\www\test\new 2.php on line 45
Notice: Undefined offset: 10 in C:\Program Files\EasyPHP-5.3.3.1\www\test\new 2.php on line 46
Notice: Undefined offset: 11 in C:\Program Files\EasyPHP-5.3.3.1\www\test\new 2.php on line 47
Notice: Undefined offset: 12 in C:\Program Files\EasyPHP-5.3.3.1\www\test\new 2.php on line 48
Notice: Undefined offset: 13 in C:\Program Files\EasyPHP-5.3.3.1\www\test\new 2.php on line 49
Notice: Undefined offset: 14 in C:\Program Files\EasyPHP-5.3.3.1\www\test\new 2.php on line 50
Warning: explode() expects parameter 2 to be string, array given in C:\Program Files\EasyPHP-5.3.3.1\www\test\new 2.php on line 33
Notice: Undefined offset: 4 in C:\Program Files\EasyPHP-5.3.3.1\www\test\new 2.php on line 40
Notice: Undefined offset: 5 in C:\Program Files\EasyPHP-5.3.3.1\www\test\new 2.php on line 41
Notice: Undefined offset: 6 in C:\Program Files\EasyPHP-5.3.3.1\www\test\new 2.php on line 42
Notice: Undefined offset: 7 in C:\Program Files\EasyPHP-5.3.3.1\www\test\new 2.php on line 43
Notice: Undefined offset: 8 in C:\Program Files\EasyPHP-5.3.3.1\www\test\new 2.php on line 44
Notice: Undefined offset: 9 in C:\Program Files\EasyPHP-5.3.3.1\www\test\new 2.php on line 45
Notice: Undefined offset: 10 in C:\Program Files\EasyPHP-5.3.3.1\www\test\new 2.php on line 46
Notice: Undefined offset: 11 in C:\Program Files\EasyPHP-5.3.3.1\www\test\new 2.php on line 47
Notice: Undefined offset: 12 in C:\Program Files\EasyPHP-5.3.3.1\www\test\new 2.php on line 48
Notice: Undefined offset: 13 in C:\Program Files\EasyPHP-5.3.3.1\www\test\new 2.php on line 49
Notice: Undefined offset: 14 in C:\Program Files\EasyPHP-5.3.3.1\www\test\new 2.php on line 50
Warning: explode() expects parameter 2 to be string, array given in C:\Program Files\EasyPHP-5.3.3.1\www\test\new 2.php on line 33
Notice: Undefined offset: 5 in C:\Program Files\EasyPHP-5.3.3.1\www\test\new 2.php on line 41
Notice: Undefined offset: 6 in C:\Program Files\EasyPHP-5.3.3.1\www\test\new 2.php on line 42
Notice: Undefined offset: 7 in C:\Program Files\EasyPHP-5.3.3.1\www\test\new 2.php on line 43
Notice: Undefined offset: 8 in C:\Program Files\EasyPHP-5.3.3.1\www\test\new 2.php on line 44
Notice: Undefined offset: 9 in C:\Program Files\EasyPHP-5.3.3.1\www\test\new 2.php on line 45
Notice: Undefined offset: 10 in C:\Program Files\EasyPHP-5.3.3.1\www\test\new 2.php on line 46
Notice: Undefined offset: 11 in C:\Program Files\EasyPHP-5.3.3.1\www\test\new 2.php on line 47
Notice: Undefined offset: 12 in C:\Program Files\EasyPHP-5.3.3.1\www\test\new 2.php on line 48
Notice: Undefined offset: 13 in C:\Program Files\EasyPHP-5.3.3.1\www\test\new 2.php on line 49
Notice: Undefined offset: 14 in C:\Program Files\EasyPHP-5.3.3.1\www\test\new 2.php on line 50
Warning: explode() expects parameter 2 to be string, array given in C:\Program Files\EasyPHP-5.3.3.1\www\test\new 2.php on line 33
Notice: Undefined offset: 6 in C:\Program Files\EasyPHP-5.3.3.1\www\test\new 2.php on line 42
Notice: Undefined offset: 7 in C:\Program Files\EasyPHP-5.3.3.1\www\test\new 2.php on line 43
Notice: Undefined offset: 8 in C:\Program Files\EasyPHP-5.3.3.1\www\test\new 2.php on line 44
Notice: Undefined offset: 9 in C:\Program Files\EasyPHP-5.3.3.1\www\test\new 2.php on line 45
if (file_exists( $filename)){
$fp = fopen("C:/Program Files/EasyPHP-5.3.3.1/www/test/tickets Oceane_jan_mai_20121.csv", "r+");
/* Et Hop on importe */
$i=0;
while (!feof($fp)){ /* Tant qu'on n'atteint pas la fin du fichier */
$ligne[$i] = fgetcsv($fp); /* On lit une ligne ceci en précisant qu'elle est lue jusqu'au dernier caractère */
/* On récupère les champs séparés par ; dans liste*/
$liste[] = explode( ";",$ligne[$i]);
/* On assigne les variables */
$num = $liste[0];
$Etat = $liste[1];
$typequip = $liste[2];
$equip = $liste[3];
$datedeb = $liste[4];
$dateret = $liste[5];
$detail = $liste[6];
$Identifiant_1_ress = $liste[7];
$Libel_imput = $liste[8];
$Identifiant_2_ress = $liste[9];
$Impact_ress = $liste[10];
$Famil_pb = $liste[11];
$Libel_suc = $liste[12];
$Nb_impact = $liste[13];
$Identifiant_1 = $liste[14];
/* Ajouter un nouvel enregistrement dans la table */
echo $typequip;
$query2 = "INSERT INTO oce_orig VALUES('$num','$Etat','$typequip','$equip','$datedeb','$dateret','$detail','$Identifiant_1_ress','$Libel_imput','$Identifiant_2_ress','$Impact_ress','$Famil_pb','$Libel_suc','$Nb_impact','$Identifiant_1')";
$result= MYSQL_QUERY($query2);
$i++;
}
}
else {
/* le fichier n'existe pas */
echo "Fichier introuvable !<br>Importation stoppée.";
exit();
}
les erreurs affichés sont:
Warning: explode() expects parameter 2 to be string, array given in C:\Program Files\EasyPHP-5.3.3.1\www\test\new 2.php on line 33
Notice: Undefined offset: 1 in C:\Program Files\EasyPHP-5.3.3.1\www\test\new 2.php on line 37
Notice: Undefined offset: 2 in C:\Program Files\EasyPHP-5.3.3.1\www\test\new 2.php on line 38
Notice: Undefined offset: 3 in C:\Program Files\EasyPHP-5.3.3.1\www\test\new 2.php on line 39
Notice: Undefined offset: 4 in C:\Program Files\EasyPHP-5.3.3.1\www\test\new 2.php on line 40
Notice: Undefined offset: 5 in C:\Program Files\EasyPHP-5.3.3.1\www\test\new 2.php on line 41
Notice: Undefined offset: 6 in C:\Program Files\EasyPHP-5.3.3.1\www\test\new 2.php on line 42
Notice: Undefined offset: 7 in C:\Program Files\EasyPHP-5.3.3.1\www\test\new 2.php on line 43
Notice: Undefined offset: 8 in C:\Program Files\EasyPHP-5.3.3.1\www\test\new 2.php on line 44
Notice: Undefined offset: 9 in C:\Program Files\EasyPHP-5.3.3.1\www\test\new 2.php on line 45
Notice: Undefined offset: 10 in C:\Program Files\EasyPHP-5.3.3.1\www\test\new 2.php on line 46
Notice: Undefined offset: 11 in C:\Program Files\EasyPHP-5.3.3.1\www\test\new 2.php on line 47
Notice: Undefined offset: 12 in C:\Program Files\EasyPHP-5.3.3.1\www\test\new 2.php on line 48
Notice: Undefined offset: 13 in C:\Program Files\EasyPHP-5.3.3.1\www\test\new 2.php on line 49
Notice: Undefined offset: 14 in C:\Program Files\EasyPHP-5.3.3.1\www\test\new 2.php on line 50
Warning: explode() expects parameter 2 to be string, array given in C:\Program Files\EasyPHP-5.3.3.1\www\test\new 2.php on line 33
Notice: Undefined offset: 2 in C:\Program Files\EasyPHP-5.3.3.1\www\test\new 2.php on line 38
Notice: Undefined offset: 3 in C:\Program Files\EasyPHP-5.3.3.1\www\test\new 2.php on line 39
Notice: Undefined offset: 4 in C:\Program Files\EasyPHP-5.3.3.1\www\test\new 2.php on line 40
Notice: Undefined offset: 5 in C:\Program Files\EasyPHP-5.3.3.1\www\test\new 2.php on line 41
Notice: Undefined offset: 6 in C:\Program Files\EasyPHP-5.3.3.1\www\test\new 2.php on line 42
Notice: Undefined offset: 7 in C:\Program Files\EasyPHP-5.3.3.1\www\test\new 2.php on line 43
Notice: Undefined offset: 8 in C:\Program Files\EasyPHP-5.3.3.1\www\test\new 2.php on line 44
Notice: Undefined offset: 9 in C:\Program Files\EasyPHP-5.3.3.1\www\test\new 2.php on line 45
Notice: Undefined offset: 10 in C:\Program Files\EasyPHP-5.3.3.1\www\test\new 2.php on line 46
Notice: Undefined offset: 11 in C:\Program Files\EasyPHP-5.3.3.1\www\test\new 2.php on line 47
Notice: Undefined offset: 12 in C:\Program Files\EasyPHP-5.3.3.1\www\test\new 2.php on line 48
Notice: Undefined offset: 13 in C:\Program Files\EasyPHP-5.3.3.1\www\test\new 2.php on line 49
Notice: Undefined offset: 14 in C:\Program Files\EasyPHP-5.3.3.1\www\test\new 2.php on line 50
Warning: explode() expects parameter 2 to be string, array given in C:\Program Files\EasyPHP-5.3.3.1\www\test\new 2.php on line 33
Notice: Undefined offset: 3 in C:\Program Files\EasyPHP-5.3.3.1\www\test\new 2.php on line 39
Notice: Undefined offset: 4 in C:\Program Files\EasyPHP-5.3.3.1\www\test\new 2.php on line 40
Notice: Undefined offset: 5 in C:\Program Files\EasyPHP-5.3.3.1\www\test\new 2.php on line 41
Notice: Undefined offset: 6 in C:\Program Files\EasyPHP-5.3.3.1\www\test\new 2.php on line 42
Notice: Undefined offset: 7 in C:\Program Files\EasyPHP-5.3.3.1\www\test\new 2.php on line 43
Notice: Undefined offset: 8 in C:\Program Files\EasyPHP-5.3.3.1\www\test\new 2.php on line 44
Notice: Undefined offset: 9 in C:\Program Files\EasyPHP-5.3.3.1\www\test\new 2.php on line 45
Notice: Undefined offset: 10 in C:\Program Files\EasyPHP-5.3.3.1\www\test\new 2.php on line 46
Notice: Undefined offset: 11 in C:\Program Files\EasyPHP-5.3.3.1\www\test\new 2.php on line 47
Notice: Undefined offset: 12 in C:\Program Files\EasyPHP-5.3.3.1\www\test\new 2.php on line 48
Notice: Undefined offset: 13 in C:\Program Files\EasyPHP-5.3.3.1\www\test\new 2.php on line 49
Notice: Undefined offset: 14 in C:\Program Files\EasyPHP-5.3.3.1\www\test\new 2.php on line 50
Warning: explode() expects parameter 2 to be string, array given in C:\Program Files\EasyPHP-5.3.3.1\www\test\new 2.php on line 33
Notice: Undefined offset: 4 in C:\Program Files\EasyPHP-5.3.3.1\www\test\new 2.php on line 40
Notice: Undefined offset: 5 in C:\Program Files\EasyPHP-5.3.3.1\www\test\new 2.php on line 41
Notice: Undefined offset: 6 in C:\Program Files\EasyPHP-5.3.3.1\www\test\new 2.php on line 42
Notice: Undefined offset: 7 in C:\Program Files\EasyPHP-5.3.3.1\www\test\new 2.php on line 43
Notice: Undefined offset: 8 in C:\Program Files\EasyPHP-5.3.3.1\www\test\new 2.php on line 44
Notice: Undefined offset: 9 in C:\Program Files\EasyPHP-5.3.3.1\www\test\new 2.php on line 45
Notice: Undefined offset: 10 in C:\Program Files\EasyPHP-5.3.3.1\www\test\new 2.php on line 46
Notice: Undefined offset: 11 in C:\Program Files\EasyPHP-5.3.3.1\www\test\new 2.php on line 47
Notice: Undefined offset: 12 in C:\Program Files\EasyPHP-5.3.3.1\www\test\new 2.php on line 48
Notice: Undefined offset: 13 in C:\Program Files\EasyPHP-5.3.3.1\www\test\new 2.php on line 49
Notice: Undefined offset: 14 in C:\Program Files\EasyPHP-5.3.3.1\www\test\new 2.php on line 50
Warning: explode() expects parameter 2 to be string, array given in C:\Program Files\EasyPHP-5.3.3.1\www\test\new 2.php on line 33
Notice: Undefined offset: 5 in C:\Program Files\EasyPHP-5.3.3.1\www\test\new 2.php on line 41
Notice: Undefined offset: 6 in C:\Program Files\EasyPHP-5.3.3.1\www\test\new 2.php on line 42
Notice: Undefined offset: 7 in C:\Program Files\EasyPHP-5.3.3.1\www\test\new 2.php on line 43
Notice: Undefined offset: 8 in C:\Program Files\EasyPHP-5.3.3.1\www\test\new 2.php on line 44
Notice: Undefined offset: 9 in C:\Program Files\EasyPHP-5.3.3.1\www\test\new 2.php on line 45
Notice: Undefined offset: 10 in C:\Program Files\EasyPHP-5.3.3.1\www\test\new 2.php on line 46
Notice: Undefined offset: 11 in C:\Program Files\EasyPHP-5.3.3.1\www\test\new 2.php on line 47
Notice: Undefined offset: 12 in C:\Program Files\EasyPHP-5.3.3.1\www\test\new 2.php on line 48
Notice: Undefined offset: 13 in C:\Program Files\EasyPHP-5.3.3.1\www\test\new 2.php on line 49
Notice: Undefined offset: 14 in C:\Program Files\EasyPHP-5.3.3.1\www\test\new 2.php on line 50
Warning: explode() expects parameter 2 to be string, array given in C:\Program Files\EasyPHP-5.3.3.1\www\test\new 2.php on line 33
Notice: Undefined offset: 6 in C:\Program Files\EasyPHP-5.3.3.1\www\test\new 2.php on line 42
Notice: Undefined offset: 7 in C:\Program Files\EasyPHP-5.3.3.1\www\test\new 2.php on line 43
Notice: Undefined offset: 8 in C:\Program Files\EasyPHP-5.3.3.1\www\test\new 2.php on line 44
Notice: Undefined offset: 9 in C:\Program Files\EasyPHP-5.3.3.1\www\test\new 2.php on line 45
A voir également:
- J ai besoin d'assistance
- Assistance free - Guide
- Assistance sfr - Guide
- Code assistance ss07 - Forum Snapchat
- Code assistance ss06 - Forum Snapchat
- Compte Snapchat bloqué temporairement ✓ - Forum Snapchat
1 réponse
Il s'agit bien du code du fichier "new 2.php" ?
Pour commencer afficher ce que tu récupères en parcourant ton fichier, pour etre sur que tu as bien ce que tu veux.
Ensuite quand on regarde de plus près la fonction fgetcsv, on voit qu'elle renvoie un tableau, ce qui explique pourquoi ton explode ne fonctionne pas puisqu'il attend une chaine et non un tableau !
Si j'ai bien compris, la tableau renvoyé par ton fgetcsv contient tous les champs de la ligne que tu récupères !
Donc en faite, là, tu n'as pas besoin d'explode parce que fgetcsv fait déjà le travail
remplace la ligne avec ton fgetcsv par:
et enleve ton explode !
Dis moi ce que ça donne
Pour commencer afficher ce que tu récupères en parcourant ton fichier, pour etre sur que tu as bien ce que tu veux.
Ensuite quand on regarde de plus près la fonction fgetcsv, on voit qu'elle renvoie un tableau, ce qui explique pourquoi ton explode ne fonctionne pas puisqu'il attend une chaine et non un tableau !
Si j'ai bien compris, la tableau renvoyé par ton fgetcsv contient tous les champs de la ligne que tu récupères !
Donc en faite, là, tu n'as pas besoin d'explode parce que fgetcsv fait déjà le travail
remplace la ligne avec ton fgetcsv par:
$liste = fgetcsv($fp, 1000, ";"))
et enleve ton explode !
Dis moi ce que ça donne
