J'ai fait mon code mais j'arrive a générer un fichier mais il est vide. Je vous met mon code/
recherche.php
<?php
//MX Widgets3 include
require_once('includes/wdg/WDG.php');
?><!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN" "http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd">
<html xmlns="http://www.w3.org/1999/xhtml" xmlns:wdg="http://ns.adobe.com/addt">
<head>
<meta http-equiv="Content-Type" content="text/html; charset=utf-8" />
<title>Document sans titre</title>
<script type="text/javascript" src="includes/common/js/sigslot_core.js"></script>
<script src="includes/common/js/base.js" type="text/javascript"></script>
<script src="includes/common/js/utility.js" type="text/javascript"></script>
<script type="text/javascript" src="includes/wdg/classes/MXWidgets.js"></script>
<script type="text/javascript" src="includes/wdg/classes/MXWidgets.js.php"></script>
<script type="text/javascript" src="includes/wdg/classes/Calendar.js"></script>
<script type="text/javascript" src="includes/wdg/classes/SmartDate.js"></script>
<script type="text/javascript" src="includes/wdg/calendar/calendar_stripped.js"></script>
<script type="text/javascript" src="includes/wdg/calendar/calendar-setup_stripped.js"></script>
<script src="includes/resources/calendar.js"></script>
<link href="includes/skins/mxkollection3.css" rel="stylesheet" type="text/css" media="all" />
</head>
<form action="dl.php" method="get" enctype="multipart/form-data" name="form1" id="form1">
Date début,
<label>
" wdg:mondayfirst="true" wdg:type="widget" wdg:singleclick="false" wdg:restricttomask="no" />
</label>,
----
Date fin,
<label>
" wdg:mondayfirst="true" wdg:type="widget" wdg:singleclick="false" wdg:restricttomask="no" />
</label>,
----
,
<label>
</label>
</form>
</html>
resultat.php
<?php
include ("connexion.php");
$connect= mysql_connect($host,$login,$pass);
mysql_select_db($base, $connect);
// Liste les données de la table
// Script permettant d'exporter une table Mysql au format CSV (séparateur
$debut='';
$fin='';
$resQuery = mysql_query("SELECT date_creat AS DATE_DE_CERATION, heure_d AS HEURE_CREATION, creation AS STATUS1, date_upd AS DATE_MODIFICATION, heure_up AS HEURE_MODIFICATION, modification AS STATUS2, societe AS SOCIETE, nom_navire AS NOM_NAVIRE, call_sign AS CALL_SIGN, type_navire AS TYPE_NAVIRE, comment AS COMMENTAIRES FROM navires WHERE date_creat BETWEEN '$debut' AND '$fin' ");
/*
$resQuery = mysql_query("SELECT date_creat, heure_d, creation, date_upd, heure_up, modification, societe, nom_navire, call_sign, type_navire, comment FROM navires WHERE date_creat='09052011'");
$resQuery = mysql_query("SELECT
nom_adherent,prenom_adherent,adresse_adherent,codepostal_adherent,ville_adhe
rent FROM mysite_adherents WHERE annee_echange_adherent = 2006");*/
header("Content-Type: application/csv-tab-delimited-table");
header("Content-disposition: filename=export.csv");
if (mysql_num_rows($resQuery) != 0) {
// titre des colonnes
$fields = mysql_num_fields($resQuery);
$i = 0;
while ($i < $fields) {
echo mysql_field_name($resQuery, $i).";";
$i++;
}
echo "\n";
// données de la table
while ($arrSelect = mysql_fetch_array($resQuery, MYSQL_ASSOC)) {
foreach($arrSelect as $elem) {
echo "$elem;";
}
echo "\n";
}
}
?>