Forum |  HardWare.fr | News | Articles | PC | S'identifier | S'inscrire | Shop Recherche
1574 connectés 

  FORUM HardWare.fr
  Programmation
  PHP

  problème script export csv php

 



 Mot :   Pseudo :  
 
Bas de page
Auteur Sujet :

problème script export csv php

n°2067633
Fu57
Posté le 01-04-2011 à 23:41:02  profilanswer
 

Bonjour, je souhaiterais faire un export csv de 2 champs de ma table mais mon soucis est le suivant je ne peux pas selectionner que le champs ou les champs que je veux.
Ma table comporte 5 champs et ils s'affichent tous le temps alors que je souhaite en afficher que 2 par rapport à un id de la manière (WHERE a_id='8') par example.
Je pense que c'est un problème d'écriture de la requete mais je n'arrive pas à la faire fonctionner j'ai même essayer de rajouter un $champ='p_data.m_nom' par example mais sans succès :S
Je vous propose donc mon code si quelqu'un aurait une solution ce serait gentille merci d'avance :  
 
<?php
$host = 'localhost';
$user = 'root';
$pass = '';
$db = 'data1';
$table = 'p_data';
$file = 'export';
 
$link = mysql_connect($host, $user, $pass) or die("Can not connect." . mysql_error());
mysql_select_db($db) or die("Can not connect." );
 
$result = mysql_query("SHOW COLUMNS FIELDS FROM ".$table."" );
$i = 0;
if (mysql_num_rows($result) > 0) {
while ($row = mysql_fetch_assoc($result)) {
$csv_output .= $row['Field']."; ";
$i++;
}
}
$csv_output .= "\n";
 
$values = mysql_query("SELECT * FROM ".$table." WHERE m_id ='9' " );
 
while ($rowr = mysql_fetch_row($values)) {
for ($j=0;$j<$i;$j++) {
$csv_output .= $rowr[$j]."; ";
}
$csv_output .= "\n";
}
 
$filename = $file."_".date("Y-m-d_H-i",time());
header("Content-type: application/vnd.ms-excel" );
header("Content-disposition: csv" . date("Y-m-d" ) . ".csv" );
header( "Content-disposition: filename=".$filename.".csv" );
print $csv_output;
exit;
?>

mood
Publicité
Posté le 01-04-2011 à 23:41:02  profilanswer
 

n°2067634
flo850
moi je
Posté le 02-04-2011 à 00:07:00  profilanswer
 

remplace select * par select lenomdunchamp,lenomdunautrechamp


---------------

n°2067780
Fu57
Posté le 03-04-2011 à 20:05:05  profilanswer
 

j'ai essayer cela ne marche pas :s

n°2067782
Fu57
Posté le 03-04-2011 à 20:16:52  profilanswer
 

cela me met plusieurs messages d'erreurs et a la fin le tableau que je souhaite visualiser. Je pense que l'erreur vien du show colomuns
 
 
Notice: Undefined variable: csv_output in C:\Program Files (x86)\EasyPHP5.2.10\www\csv1.php on line 17
 
Notice: Undefined offset: 1 in C:\Program Files (x86)\EasyPHP5.2.10\www\csv1.php on line 27
 
Notice: Undefined offset: 2 in C:\Program Files (x86)\EasyPHP5.2.10\www\csv1.php on line 27
 
Notice: Undefined offset: 3 in C:\Program Files (x86)\EasyPHP5.2.10\www\csv1.php on line 27
 
Notice: Undefined offset: 4 in C:\Program Files (x86)\EasyPHP5.2.10\www\csv1.php on line 27
 
Notice: Undefined offset: 5 in C:\Program Files (x86)\EasyPHP5.2.10\www\csv1.php on line 27
 
Notice: Undefined offset: 1 in C:\Program Files (x86)\EasyPHP5.2.10\www\csv1.php on line 27
 
Notice: Undefined offset: 2 in C:\Program Files (x86)\EasyPHP5.2.10\www\csv1.php on line 27
 
Notice: Undefined offset: 3 in C:\Program Files (x86)\EasyPHP5.2.10\www\csv1.php on line 27
 
Notice: Undefined offset: 4 in C:\Program Files (x86)\EasyPHP5.2.10\www\csv1.php on line 27
 
Notice: Undefined offset: 5 in C:\Program Files (x86)\EasyPHP5.2.10\www\csv1.php on line 27
 
Notice: Undefined offset: 1 in C:\Program Files (x86)\EasyPHP5.2.10\www\csv1.php on line 27
 
Notice: Undefined offset: 2 in C:\Program Files (x86)\EasyPHP5.2.10\www\csv1.php on line 27
 
Notice: Undefined offset: 3 in C:\Program Files (x86)\EasyPHP5.2.10\www\csv1.php on line 27
 
Notice: Undefined offset: 4 in C:\Program Files (x86)\EasyPHP5.2.10\www\csv1.php on line 27
 
Notice: Undefined offset: 5 in C:\Program Files (x86)\EasyPHP5.2.10\www\csv1.php on line 27
 
Notice: Undefined offset: 1 in C:\Program Files (x86)\EasyPHP5.2.10\www\csv1.php on line 27
 
Notice: Undefined offset: 2 in C:\Program Files (x86)\EasyPHP5.2.10\www\csv1.php on line 27
 
Notice: Undefined offset: 3 in C:\Program Files (x86)\EasyPHP5.2.10\www\csv1.php on line 27
 
Notice: Undefined offset: 4 in C:\Program Files (x86)\EasyPHP5.2.10\www\csv1.php on line 27
 
Notice: Undefined offset: 5 in C:\Program Files (x86)\EasyPHP5.2.10\www\csv1.php on line 27
 
Notice: Undefined offset: 1 in C:\Program Files (x86)\EasyPHP5.2.10\www\csv1.php on line 27
 
Notice: Undefined offset: 2 in C:\Program Files (x86)\EasyPHP5.2.10\www\csv1.php on line 27
 
Notice: Undefined offset: 3 in C:\Program Files (x86)\EasyPHP5.2.10\www\csv1.php on line 27
 
Notice: Undefined offset: 4 in C:\Program Files (x86)\EasyPHP5.2.10\www\csv1.php on line 27
 
Notice: Undefined offset: 5 in C:\Program Files (x86)\EasyPHP5.2.10\www\csv1.php on line 27
 
Notice: Undefined offset: 1 in C:\Program Files (x86)\EasyPHP5.2.10\www\csv1.php on line 27
 
Notice: Undefined offset: 2 in C:\Program Files (x86)\EasyPHP5.2.10\www\csv1.php on line 27
 
Notice: Undefined offset: 3 in C:\Program Files (x86)\EasyPHP5.2.10\www\csv1.php on line 27
 
Notice: Undefined offset: 4 in C:\Program Files (x86)\EasyPHP5.2.10\www\csv1.php on line 27
 
Notice: Undefined offset: 5 in C:\Program Files (x86)\EasyPHP5.2.10\www\csv1.php on line 27
 
Notice: Undefined offset: 1 in C:\Program Files (x86)\EasyPHP5.2.10\www\csv1.php on line 27
 
Notice: Undefined offset: 2 in C:\Program Files (x86)\EasyPHP5.2.10\www\csv1.php on line 27
 
Notice: Undefined offset: 3 in C:\Program Files (x86)\EasyPHP5.2.10\www\csv1.php on line 27
 
Notice: Undefined offset: 4 in C:\Program Files (x86)\EasyPHP5.2.10\www\csv1.php on line 27
 
Notice: Undefined offset: 5 in C:\Program Files (x86)\EasyPHP5.2.10\www\csv1.php on line 27
 
Notice: Undefined offset: 1 in C:\Program Files (x86)\EasyPHP5.2.10\www\csv1.php on line 27
 
Notice: Undefined offset: 2 in C:\Program Files (x86)\EasyPHP5.2.10\www\csv1.php on line 27
 
Notice: Undefined offset: 3 in C:\Program Files (x86)\EasyPHP5.2.10\www\csv1.php on line 27
 
Notice: Undefined offset: 4 in C:\Program Files (x86)\EasyPHP5.2.10\www\csv1.php on line 27
 
Notice: Undefined offset: 5 in C:\Program Files (x86)\EasyPHP5.2.10\www\csv1.php on line 27
 
Notice: Undefined offset: 1 in C:\Program Files (x86)\EasyPHP5.2.10\www\csv1.php on line 27
 
Notice: Undefined offset: 2 in C:\Program Files (x86)\EasyPHP5.2.10\www\csv1.php on line 27
 
Notice: Undefined offset: 3 in C:\Program Files (x86)\EasyPHP5.2.10\www\csv1.php on line 27
 
Notice: Undefined offset: 4 in C:\Program Files (x86)\EasyPHP5.2.10\www\csv1.php on line 27
 
Notice: Undefined offset: 5 in C:\Program Files (x86)\EasyPHP5.2.10\www\csv1.php on line 27
 
Notice: Undefined offset: 1 in C:\Program Files (x86)\EasyPHP5.2.10\www\csv1.php on line 27
 
Notice: Undefined offset: 2 in C:\Program Files (x86)\EasyPHP5.2.10\www\csv1.php on line 27
 
Notice: Undefined offset: 3 in C:\Program Files (x86)\EasyPHP5.2.10\www\csv1.php on line 27
 
Notice: Undefined offset: 4 in C:\Program Files (x86)\EasyPHP5.2.10\www\csv1.php on line 27
 
Notice: Undefined offset: 5 in C:\Program Files (x86)\EasyPHP5.2.10\www\csv1.php on line 27
 
Notice: Undefined offset: 1 in C:\Program Files (x86)\EasyPHP5.2.10\www\csv1.php on line 27
 
Notice: Undefined offset: 2 in C:\Program Files (x86)\EasyPHP5.2.10\www\csv1.php on line 27
 
Notice: Undefined offset: 3 in C:\Program Files (x86)\EasyPHP5.2.10\www\csv1.php on line 27
 
Notice: Undefined offset: 4 in C:\Program Files (x86)\EasyPHP5.2.10\www\csv1.php on line 27
 
Notice: Undefined offset: 5 in C:\Program Files (x86)\EasyPHP5.2.10\www\csv1.php on line 27
 
Notice: Undefined offset: 1 in C:\Program Files (x86)\EasyPHP5.2.10\www\csv1.php on line 27
 
Notice: Undefined offset: 2 in C:\Program Files (x86)\EasyPHP5.2.10\www\csv1.php on line 27
 
Notice: Undefined offset: 3 in C:\Program Files (x86)\EasyPHP5.2.10\www\csv1.php on line 27
 
Notice: Undefined offset: 4 in C:\Program Files (x86)\EasyPHP5.2.10\www\csv1.php on line 27
 
Notice: Undefined offset: 5 in C:\Program Files (x86)\EasyPHP5.2.10\www\csv1.php on line 27
 
Notice: Undefined offset: 1 in C:\Program Files (x86)\EasyPHP5.2.10\www\csv1.php on line 27
 
Notice: Undefined offset: 2 in C:\Program Files (x86)\EasyPHP5.2.10\www\csv1.php on line 27
 
Notice: Undefined offset: 3 in C:\Program Files (x86)\EasyPHP5.2.10\www\csv1.php on line 27
 
Notice: Undefined offset: 4 in C:\Program Files (x86)\EasyPHP5.2.10\www\csv1.php on line 27
 
Notice: Undefined offset: 5 in C:\Program Files (x86)\EasyPHP5.2.10\www\csv1.php on line 27
 
Notice: Undefined offset: 1 in C:\Program Files (x86)\EasyPHP5.2.10\www\csv1.php on line 27
 
Notice: Undefined offset: 2 in C:\Program Files (x86)\EasyPHP5.2.10\www\csv1.php on line 27
 
Notice: Undefined offset: 3 in C:\Program Files (x86)\EasyPHP5.2.10\www\csv1.php on line 27
 
Notice: Undefined offset: 4 in C:\Program Files (x86)\EasyPHP5.2.10\www\csv1.php on line 27
 
Notice: Undefined offset: 5 in C:\Program Files (x86)\EasyPHP5.2.10\www\csv1.php on line 27
 
Notice: Undefined offset: 1 in C:\Program Files (x86)\EasyPHP5.2.10\www\csv1.php on line 27
 
Notice: Undefined offset: 2 in C:\Program Files (x86)\EasyPHP5.2.10\www\csv1.php on line 27
 
Notice: Undefined offset: 3 in C:\Program Files (x86)\EasyPHP5.2.10\www\csv1.php on line 27
 
Notice: Undefined offset: 4 in C:\Program Files (x86)\EasyPHP5.2.10\www\csv1.php on line 27
 
Notice: Undefined offset: 5 in C:\Program Files (x86)\EasyPHP5.2.10\www\csv1.php on line 27
 
Notice: Undefined offset: 1 in C:\Program Files (x86)\EasyPHP5.2.10\www\csv1.php on line 27
 
Notice: Undefined offset: 2 in C:\Program Files (x86)\EasyPHP5.2.10\www\csv1.php on line 27
 
Notice: Undefined offset: 3 in C:\Program Files (x86)\EasyPHP5.2.10\www\csv1.php on line 27
 
Notice: Undefined offset: 4 in C:\Program Files (x86)\EasyPHP5.2.10\www\csv1.php on line 27
 
Notice: Undefined offset: 5 in C:\Program Files (x86)\EasyPHP5.2.10\www\csv1.php on line 27
 
Notice: Undefined offset: 1 in C:\Program Files (x86)\EasyPHP5.2.10\www\csv1.php on line 27
 
Notice: Undefined offset: 2 in C:\Program Files (x86)\EasyPHP5.2.10\www\csv1.php on line 27
 
Notice: Undefined offset: 3 in C:\Program Files (x86)\EasyPHP5.2.10\www\csv1.php on line 27
 
Notice: Undefined offset: 4 in C:\Program Files (x86)\EasyPHP5.2.10\www\csv1.php on line 27
 
Notice: Undefined offset: 5 in C:\Program Files (x86)\EasyPHP5.2.10\www\csv1.php on line 27
 
Notice: Undefined offset: 1 in C:\Program Files (x86)\EasyPHP5.2.10\www\csv1.php on line 27
 
Notice: Undefined offset: 2 in C:\Program Files (x86)\EasyPHP5.2.10\www\csv1.php on line 27
 
Notice: Undefined offset: 3 in C:\Program Files (x86)\EasyPHP5.2.10\www\csv1.php on line 27
 
Notice: Undefined offset: 4 in C:\Program Files (x86)\EasyPHP5.2.10\www\csv1.php on line 27
 
Notice: Undefined offset: 5 in C:\Program Files (x86)\EasyPHP5.2.10\www\csv1.php on line 27
 
Notice: Undefined offset: 1 in C:\Program Files (x86)\EasyPHP5.2.10\www\csv1.php on line 27
 
Notice: Undefined offset: 2 in C:\Program Files (x86)\EasyPHP5.2.10\www\csv1.php on line 27
 
Notice: Undefined offset: 3 in C:\Program Files (x86)\EasyPHP5.2.10\www\csv1.php on line 27
 
Notice: Undefined offset: 4 in C:\Program Files (x86)\EasyPHP5.2.10\www\csv1.php on line 27
 
Notice: Undefined offset: 5 in C:\Program Files (x86)\EasyPHP5.2.10\www\csv1.php on line 27
 
Notice: Undefined offset: 1 in C:\Program Files (x86)\EasyPHP5.2.10\www\csv1.php on line 27
 
Notice: Undefined offset: 2 in C:\Program Files (x86)\EasyPHP5.2.10\www\csv1.php on line 27
 
Notice: Undefined offset: 3 in C:\Program Files (x86)\EasyPHP5.2.10\www\csv1.php on line 27
 
Notice: Undefined offset: 4 in C:\Program Files (x86)\EasyPHP5.2.10\www\csv1.php on line 27
 
Notice: Undefined offset: 5 in C:\Program Files (x86)\EasyPHP5.2.10\www\csv1.php on line 27
 
Notice: Undefined offset: 1 in C:\Program Files (x86)\EasyPHP5.2.10\www\csv1.php on line 27
 
Notice: Undefined offset: 2 in C:\Program Files (x86)\EasyPHP5.2.10\www\csv1.php on line 27
 
Notice: Undefined offset: 3 in C:\Program Files (x86)\EasyPHP5.2.10\www\csv1.php on line 27
 
Notice: Undefined offset: 4 in C:\Program Files (x86)\EasyPHP5.2.10\www\csv1.php on line 27
 
Notice: Undefined offset: 5 in C:\Program Files (x86)\EasyPHP5.2.10\www\csv1.php on line 27
 
Notice: Undefined offset: 1 in C:\Program Files (x86)\EasyPHP5.2.10\www\csv1.php on line 27
 
Notice: Undefined offset: 2 in C:\Program Files (x86)\EasyPHP5.2.10\www\csv1.php on line 27
 
Notice: Undefined offset: 3 in C:\Program Files (x86)\EasyPHP5.2.10\www\csv1.php on line 27
 
Notice: Undefined offset: 4 in C:\Program Files (x86)\EasyPHP5.2.10\www\csv1.php on line 27
 
Notice: Undefined offset: 5 in C:\Program Files (x86)\EasyPHP5.2.10\www\csv1.php on line 27
 
Notice: Undefined offset: 1 in C:\Program Files (x86)\EasyPHP5.2.10\www\csv1.php on line 27
 
Notice: Undefined offset: 2 in C:\Program Files (x86)\EasyPHP5.2.10\www\csv1.php on line 27
 
Notice: Undefined offset: 3 in C:\Program Files (x86)\EasyPHP5.2.10\www\csv1.php on line 27
 
Notice: Undefined offset: 4 in C:\Program Files (x86)\EasyPHP5.2.10\www\csv1.php on line 27
 
Notice: Undefined offset: 5 in C:\Program Files (x86)\EasyPHP5.2.10\www\csv1.php on line 27
 
Notice: Undefined offset: 1 in C:\Program Files (x86)\EasyPHP5.2.10\www\csv1.php on line 27
 
Notice: Undefined offset: 2 in C:\Program Files (x86)\EasyPHP5.2.10\www\csv1.php on line 27
 
Notice: Undefined offset: 3 in C:\Program Files (x86)\EasyPHP5.2.10\www\csv1.php on line 27
 
Notice: Undefined offset: 4 in C:\Program Files (x86)\EasyPHP5.2.10\www\csv1.php on line 27
 
Notice: Undefined offset: 5 in C:\Program Files (x86)\EasyPHP5.2.10\www\csv1.php on line 27
 
Notice: Undefined offset: 1 in C:\Program Files (x86)\EasyPHP5.2.10\www\csv1.php on line 27
 
Notice: Undefined offset: 2 in C:\Program Files (x86)\EasyPHP5.2.10\www\csv1.php on line 27
 
Notice: Undefined offset: 3 in C:\Program Files (x86)\EasyPHP5.2.10\www\csv1.php on line 27
 
Notice: Undefined offset: 4 in C:\Program Files (x86)\EasyPHP5.2.10\www\csv1.php on line 27
 
Notice: Undefined offset: 5 in C:\Program Files (x86)\EasyPHP5.2.10\www\csv1.php on line 27
 
Notice: Undefined offset: 1 in C:\Program Files (x86)\EasyPHP5.2.10\www\csv1.php on line 27
 
Notice: Undefined offset: 2 in C:\Program Files (x86)\EasyPHP5.2.10\www\csv1.php on line 27
 
Notice: Undefined offset: 3 in C:\Program Files (x86)\EasyPHP5.2.10\www\csv1.php on line 27
 
Notice: Undefined offset: 4 in C:\Program Files (x86)\EasyPHP5.2.10\www\csv1.php on line 27
 
Notice: Undefined offset: 5 in C:\Program Files (x86)\EasyPHP5.2.10\www\csv1.php on line 27
 
Notice: Undefined offset: 1 in C:\Program Files (x86)\EasyPHP5.2.10\www\csv1.php on line 27
 
Notice: Undefined offset: 2 in C:\Program Files (x86)\EasyPHP5.2.10\www\csv1.php on line 27
 
Notice: Undefined offset: 3 in C:\Program Files (x86)\EasyPHP5.2.10\www\csv1.php on line 27
 
Notice: Undefined offset: 4 in C:\Program Files (x86)\EasyPHP5.2.10\www\csv1.php on line 27
 
Notice: Undefined offset: 5 in C:\Program Files (x86)\EasyPHP5.2.10\www\csv1.php on line 27
 
Notice: Undefined offset: 1 in C:\Program Files (x86)\EasyPHP5.2.10\www\csv1.php on line 27
 
Notice: Undefined offset: 2 in C:\Program Files (x86)\EasyPHP5.2.10\www\csv1.php on line 27
 
Notice: Undefined offset: 3 in C:\Program Files (x86)\EasyPHP5.2.10\www\csv1.php on line 27
 
Notice: Undefined offset: 4 in C:\Program Files (x86)\EasyPHP5.2.10\www\csv1.php on line 27
 
Notice: Undefined offset: 5 in C:\Program Files (x86)\EasyPHP5.2.10\www\csv1.php on line 27
 
Notice: Undefined offset: 1 in C:\Program Files (x86)\EasyPHP5.2.10\www\csv1.php on line 27
 
Notice: Undefined offset: 2 in C:\Program Files (x86)\EasyPHP5.2.10\www\csv1.php on line 27
 
Notice: Undefined offset: 3 in C:\Program Files (x86)\EasyPHP5.2.10\www\csv1.php on line 27
 
Notice: Undefined offset: 4 in C:\Program Files (x86)\EasyPHP5.2.10\www\csv1.php on line 27
 
Notice: Undefined offset: 5 in C:\Program Files (x86)\EasyPHP5.2.10\www\csv1.php on line 27
 
Notice: Undefined offset: 1 in C:\Program Files (x86)\EasyPHP5.2.10\www\csv1.php on line 27
 
Notice: Undefined offset: 2 in C:\Program Files (x86)\EasyPHP5.2.10\www\csv1.php on line 27
 
Notice: Undefined offset: 3 in C:\Program Files (x86)\EasyPHP5.2.10\www\csv1.php on line 27
 
Notice: Undefined offset: 4 in C:\Program Files (x86)\EasyPHP5.2.10\www\csv1.php on line 27
 
Notice: Undefined offset: 5 in C:\Program Files (x86)\EasyPHP5.2.10\www\csv1.php on line 27
 
Notice: Undefined offset: 1 in C:\Program Files (x86)\EasyPHP5.2.10\www\csv1.php on line 27
 
Notice: Undefined offset: 2 in C:\Program Files (x86)\EasyPHP5.2.10\www\csv1.php on line 27
 
Notice: Undefined offset: 3 in C:\Program Files (x86)\EasyPHP5.2.10\www\csv1.php on line 27
 
Notice: Undefined offset: 4 in C:\Program Files (x86)\EasyPHP5.2.10\www\csv1.php on line 27
 
Notice: Undefined offset: 5 in C:\Program Files (x86)\EasyPHP5.2.10\www\csv1.php on line 27
 
Notice: Undefined offset: 1 in C:\Program Files (x86)\EasyPHP5.2.10\www\csv1.php on line 27
 
Notice: Undefined offset: 2 in C:\Program Files (x86)\EasyPHP5.2.10\www\csv1.php on line 27
 
Notice: Undefined offset: 3 in C:\Program Files (x86)\EasyPHP5.2.10\www\csv1.php on line 27
 
Notice: Undefined offset: 4 in C:\Program Files (x86)\EasyPHP5.2.10\www\csv1.php on line 27
 
Notice: Undefined offset: 5 in C:\Program Files (x86)\EasyPHP5.2.10\www\csv1.php on line 27
 
Notice: Undefined offset: 1 in C:\Program Files (x86)\EasyPHP5.2.10\www\csv1.php on line 27
 
Notice: Undefined offset: 2 in C:\Program Files (x86)\EasyPHP5.2.10\www\csv1.php on line 27
 
Notice: Undefined offset: 3 in C:\Program Files (x86)\EasyPHP5.2.10\www\csv1.php on line 27
 
Notice: Undefined offset: 4 in C:\Program Files (x86)\EasyPHP5.2.10\www\csv1.php on line 27
 
Notice: Undefined offset: 5 in C:\Program Files (x86)\EasyPHP5.2.10\www\csv1.php on line 27
 
Notice: Undefined offset: 1 in C:\Program Files (x86)\EasyPHP5.2.10\www\csv1.php on line 27
 
Notice: Undefined offset: 2 in C:\Program Files (x86)\EasyPHP5.2.10\www\csv1.php on line 27
 
Notice: Undefined offset: 3 in C:\Program Files (x86)\EasyPHP5.2.10\www\csv1.php on line 27
 
Notice: Undefined offset: 4 in C:\Program Files (x86)\EasyPHP5.2.10\www\csv1.php on line 27
 
Notice: Undefined offset: 5 in C:\Program Files (x86)\EasyPHP5.2.10\www\csv1.php on line 27
 
Notice: Undefined offset: 1 in C:\Program Files (x86)\EasyPHP5.2.10\www\csv1.php on line 27
 
Notice: Undefined offset: 2 in C:\Program Files (x86)\EasyPHP5.2.10\www\csv1.php on line 27
 
Notice: Undefined offset: 3 in C:\Program Files (x86)\EasyPHP5.2.10\www\csv1.php on line 27
 
Notice: Undefined offset: 4 in C:\Program Files (x86)\EasyPHP5.2.10\www\csv1.php on line 27
 
Notice: Undefined offset: 5 in C:\Program Files (x86)\EasyPHP5.2.10\www\csv1.php on line 27
 
Notice: Undefined offset: 1 in C:\Program Files (x86)\EasyPHP5.2.10\www\csv1.php on line 27
 
Notice: Undefined offset: 2 in C:\Program Files (x86)\EasyPHP5.2.10\www\csv1.php on line 27
 
Notice: Undefined offset: 3 in C:\Program Files (x86)\EasyPHP5.2.10\www\csv1.php on line 27
 
Notice: Undefined offset: 4 in C:\Program Files (x86)\EasyPHP5.2.10\www\csv1.php on line 27
 
Notice: Undefined offset: 5 in C:\Program Files (x86)\EasyPHP5.2.10\www\csv1.php on line 27
 
Notice: Undefined offset: 1 in C:\Program Files (x86)\EasyPHP5.2.10\www\csv1.php on line 27
 
Notice: Undefined offset: 2 in C:\Program Files (x86)\EasyPHP5.2.10\www\csv1.php on line 27
 
Notice: Undefined offset: 3 in C:\Program Files (x86)\EasyPHP5.2.10\www\csv1.php on line 27
 
Notice: Undefined offset: 4 in C:\Program Files (x86)\EasyPHP5.2.10\www\csv1.php on line 27
 
Notice: Undefined offset: 5 in C:\Program Files (x86)\EasyPHP5.2.10\www\csv1.php on line 27
 
Notice: Undefined offset: 1 in C:\Program Files (x86)\EasyPHP5.2.10\www\csv1.php on line 27
 
Notice: Undefined offset: 2 in C:\Program Files (x86)\EasyPHP5.2.10\www\csv1.php on line 27
 
Notice: Undefined offset: 3 in C:\Program Files (x86)\EasyPHP5.2.10\www\csv1.php on line 27
 
Notice: Undefined offset: 4 in C:\Program Files (x86)\EasyPHP5.2.10\www\csv1.php on line 27
 
Notice: Undefined offset: 5 in C:\Program Files (x86)\EasyPHP5.2.10\www\csv1.php on line 27
 
Notice: Undefined offset: 1 in C:\Program Files (x86)\EasyPHP5.2.10\www\csv1.php on line 27
 
Notice: Undefined offset: 2 in C:\Program Files (x86)\EasyPHP5.2.10\www\csv1.php on line 27
 
Notice: Undefined offset: 3 in C:\Program Files (x86)\EasyPHP5.2.10\www\csv1.php on line 27
 
Notice: Undefined offset: 4 in C:\Program Files (x86)\EasyPHP5.2.10\www\csv1.php on line 27
 
Notice: Undefined offset: 5 in C:\Program Files (x86)\EasyPHP5.2.10\www\csv1.php on line 27
 
Notice: Undefined offset: 1 in C:\Program Files (x86)\EasyPHP5.2.10\www\csv1.php on line 27
 
Notice: Undefined offset: 2 in C:\Program Files (x86)\EasyPHP5.2.10\www\csv1.php on line 27
 
Notice: Undefined offset: 3 in C:\Program Files (x86)\EasyPHP5.2.10\www\csv1.php on line 27
 
Notice: Undefined offset: 4 in C:\Program Files (x86)\EasyPHP5.2.10\www\csv1.php on line 27
 
Notice: Undefined offset: 5 in C:\Program Files (x86)\EasyPHP5.2.10\www\csv1.php on line 27
 
Notice: Undefined offset: 1 in C:\Program Files (x86)\EasyPHP5.2.10\www\csv1.php on line 27
 
Notice: Undefined offset: 2 in C:\Program Files (x86)\EasyPHP5.2.10\www\csv1.php on line 27
 
Notice: Undefined offset: 3 in C:\Program Files (x86)\EasyPHP5.2.10\www\csv1.php on line 27
 
Notice: Undefined offset: 4 in C:\Program Files (x86)\EasyPHP5.2.10\www\csv1.php on line 27
 
Notice: Undefined offset: 5 in C:\Program Files (x86)\EasyPHP5.2.10\www\csv1.php on line 27
 
Notice: Undefined offset: 1 in C:\Program Files (x86)\EasyPHP5.2.10\www\csv1.php on line 27
 
Notice: Undefined offset: 2 in C:\Program Files (x86)\EasyPHP5.2.10\www\csv1.php on line 27
 
Notice: Undefined offset: 3 in C:\Program Files (x86)\EasyPHP5.2.10\www\csv1.php on line 27
 
Notice: Undefined offset: 4 in C:\Program Files (x86)\EasyPHP5.2.10\www\csv1.php on line 27
 
Notice: Undefined offset: 5 in C:\Program Files (x86)\EasyPHP5.2.10\www\csv1.php on line 27
 
Notice: Undefined offset: 1 in C:\Program Files (x86)\EasyPHP5.2.10\www\csv1.php on line 27
 
Notice: Undefined offset: 2 in C:\Program Files (x86)\EasyPHP5.2.10\www\csv1.php on line 27
 
Notice: Undefined offset: 3 in C:\Program Files (x86)\EasyPHP5.2.10\www\csv1.php on line 27
 
Notice: Undefined offset: 4 in C:\Program Files (x86)\EasyPHP5.2.10\www\csv1.php on line 27
 
Notice: Undefined offset: 5 in C:\Program Files (x86)\EasyPHP5.2.10\www\csv1.php on line 27
 
Notice: Undefined offset: 1 in C:\Program Files (x86)\EasyPHP5.2.10\www\csv1.php on line 27
 
Notice: Undefined offset: 2 in C:\Program Files (x86)\EasyPHP5.2.10\www\csv1.php on line 27
 
Notice: Undefined offset: 3 in C:\Program Files (x86)\EasyPHP5.2.10\www\csv1.php on line 27
 
Notice: Undefined offset: 4 in C:\Program Files (x86)\EasyPHP5.2.10\www\csv1.php on line 27
 
Notice: Undefined offset: 5 in C:\Program Files (x86)\EasyPHP5.2.10\www\csv1.php on line 27
 
Notice: Undefined offset: 1 in C:\Program Files (x86)\EasyPHP5.2.10\www\csv1.php on line 27
 
Notice: Undefined offset: 2 in C:\Program Files (x86)\EasyPHP5.2.10\www\csv1.php on line 27
 
Notice: Undefined offset: 3 in C:\Program Files (x86)\EasyPHP5.2.10\www\csv1.php on line 27
 
Notice: Undefined offset: 4 in C:\Program Files (x86)\EasyPHP5.2.10\www\csv1.php on line 27
 
Notice: Undefined offset: 5 in C:\Program Files (x86)\EasyPHP5.2.10\www\csv1.php on line 27
 
Notice: Undefined offset: 1 in C:\Program Files (x86)\EasyPHP5.2.10\www\csv1.php on line 27
 
Notice: Undefined offset: 2 in C:\Program Files (x86)\EasyPHP5.2.10\www\csv1.php on line 27
 
Notice: Undefined offset: 3 in C:\Program Files (x86)\EasyPHP5.2.10\www\csv1.php on line 27
 
Notice: Undefined offset: 4 in C:\Program Files (x86)\EasyPHP5.2.10\www\csv1.php on line 27
 
Notice: Undefined offset: 5 in C:\Program Files (x86)\EasyPHP5.2.10\www\csv1.php on line 27
 
Notice: Undefined offset: 1 in C:\Program Files (x86)\EasyPHP5.2.10\www\csv1.php on line 27
 
Notice: Undefined offset: 2 in C:\Program Files (x86)\EasyPHP5.2.10\www\csv1.php on line 27
 
Notice: Undefined offset: 3 in C:\Program Files (x86)\EasyPHP5.2.10\www\csv1.php on line 27
 
Notice: Undefined offset: 4 in C:\Program Files (x86)\EasyPHP5.2.10\www\csv1.php on line 27
 
Notice: Undefined offset: 5 in C:\Program Files (x86)\EasyPHP5.2.10\www\csv1.php on line 27
 
Warning: Cannot modify header information - headers already sent by (output started at C:\Program Files (x86)\EasyPHP5.2.10\www\csv1.php:27) in C:\Program Files (x86)\EasyPHP5.2.10\www\csv1.php on line 33
 
Warning: Cannot modify header information - headers already sent by (output started at C:\Program Files (x86)\EasyPHP5.2.10\www\csv1.php:27) in C:\Program Files (x86)\EasyPHP5.2.10\www\csv1.php on line 34
 
Warning: Cannot modify header information - headers already sent by (output started at C:\Program Files (x86)\EasyPHP5.2.10\www\csv1.php:27) in C:\Program Files (x86)\EasyPHP5.2.10\www\csv1.php on line 35
form_data_id; form_data_saisie_id; form_id; form_data_control_name; form_data_control_value; pers_id; prenom; ; ; ; ; ; origine_web; ; ; ; ; ; jean-marie; ; ; ; ; ; origine_web; ; ; ; ; ; prenom; ; ; ; ; ; origine_web; ; ; ; ; ; ; ; ; ; ; ; SQLI; ; ; ; ; ; prenom; ; ; ; ; ; origine_connaissance; ; ; ; ; ; jm; ; ; ; ; ; SQLI; ; ; ; ; ; prenom; ; ; ; ; ; origine_connaissance; ; ; ; ; ; jm; ; ; ; ; ; SQLI; ; ; ; ; ; prenom; ; ; ; ; ; origine_web; ; ; ; ; ; ; ; ; ; ; ; SQLI; ; ; ; ; ; prenom; ; ; ; ; ; origine_connaissance; ; ; ; ; ; ; ; ; ; ; ; vous_adressez-vous_a_la_drh_parfois; ; ; ; ; ; vous_adressez-vous_a_la_drh_parfois; ; ; ; ; ; vous_adressez-vous_a_la_drh_jamais; ; ; ; ; ; SQLI; ; ; ; ; ; prenom; ; ; ; ; ; origine_connaissance; ; ; ; ; ; ; ; ; ; ; ; vous_adressez-vous_a_la_drh_souvent; ; ; ; ; ; SQLIttest; ; ; ; ; ; prenom; ; ; ; ; ; origine_web; ; ; ; ; ; validation; ; ; ; ; ; SQLI; ; ; ; ; ; prenom; ; ; ; ; ; origine_web; ; ; ; ; ; test agebnt sqli; ; ; ; ; ; vous_adressez-vous_a_la_drh_parfois; ; ; ; ; ; vous_adressez-vous_a_la_drh_parfois; ; ; ; ; ; vous_adressez-vous_a_la_drh_parfois; ; ; ; ; ; Remplir ici; ; ; ; ; ; 1_vous_adressez-vous_a_la_drh_souvent; ; ; ; ; ; Remplir ici; ; ; ; ; ; comment_avez_vous_trouve_la_fo_bien; ; ; ; ; ; comment_avez_vous_trouve_la_fo_bien; ; ; ; ; ;

n°2067823
MEI
|DarthPingoo(tm)|
Posté le 04-04-2011 à 10:01:44  profilanswer
 

Ne fait pas la première boucle, génère l'en-tête manuellement.
 
Dans le while, tu ne doit essayé de recupérer que les les colonnes renvoyées par la requête... et tu est censé les récupérer par leur nom de tête et non par leur index.


---------------
| AMD Ryzen 9 5950X 16C/32T @ 3.4-4.9GHz - 64GB DDR4-3600 16-18-18 1T - AMD Radeon RX 5700 XT 8GB @ 2010MHz/14Gbps |
n°2067960
Fu57
Posté le 04-04-2011 à 21:08:06  profilanswer
 

bonsoir, je n'arrive pas à mettre en œuvre ce vous dites


Aller à :
Ajouter une réponse
  FORUM HardWare.fr
  Programmation
  PHP

  problème script export csv php

 

Sujets relatifs
Problème de centrage total du site.[PHP] Problème système parrainage
[Résolu] Problème sur un formulaire de contactProbleme fonction SWITCH SQL ACCESS
Problème return char.Problème(s) positionnement div
[RESOLU] Problème compilation Visual C++[RESOLU] problème requete SQL 2008
HELP probleme pour un script d'export de zone DNS 
Plus de sujets relatifs à : problème script export csv php


Copyright © 1997-2022 Hardware.fr SARL (Signaler un contenu illicite / Données personnelles) / Groupe LDLC / Shop HFR