problème script export csv php

problème script export csv php - PHP - Programmation

Marsh Posté le 01-04-2011 à 23:41:02    

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;
?>

Reply

Marsh Posté le 01-04-2011 à 23:41:02   

Reply

Marsh Posté le 02-04-2011 à 00:07:00    

remplace select * par select lenomdunchamp,lenomdunautrechamp


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

Reply

Marsh Posté le 03-04-2011 à 20:05:05    

j'ai essayer cela ne marche pas :s

Reply

Marsh Posté le 03-04-2011 à 20:16:52    

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; ; ; ; ; ;

Reply

Marsh Posté le 04-04-2011 à 10:01:44    

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 7 7700X 8C/16T @ 4.5-5.4GHz - 64GB DDR5-6000 30-40-40 1T - AMD Radeon RX 7900 XTX 24GB @ 2680MHz/20Gbps |
Reply

Marsh Posté le 04-04-2011 à 21:08:06    

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

Reply

Sujets relatifs:

Leave a Replay

Make sure you enter the(*)required information where indicate.HTML code is not allowed