Bonjour voila je sai pas ce quie ce passe avec ce formulaire mais rien marche alors qu'il me semble correcte
Donc y aurai t il qq un qui peut me dire ce quie ne va pas?
Merci
<?php
require('includes/application_top.php');
$jour=$HTTP_POST_VARS['jour'];
$mois=$HTTP_POST_VARS['mois'];
$an=$HTTP_POST_VARS['an'];
if (!isset($_POST['submit'])){
?>
<style type="text/css">
<!--
.Style1 {color: #000099}
-->
</style>
<center>
<h1 class="Style1">Rapport de comptabilité</h1>
</center>
<form id="form1" name="form1" method="get" action="">
<table width="284" border="0" align="center">
<tr align="center">
<td colspan="3"><span class="Style1">Veuillez saisir la date du rapport </span></td>
</tr>
<tr>
<td width="90" align="center">Jour</td>
<td width="90" align="center">Mois</td>
<td width="90" align="center">Année</td>
</tr>
<tr>
<td align="center"><input name="textfield" type="text" maxlength="2" checked="checked"/></td>
<td align="center"><input name="textfield" type="text" maxlength="2" checked="checked"/></td>
<td align="center"><input name="textfield" type="text" maxlength="4" checked="checked"/></td>
</tr>
<tr>
<td colspan="3" align="center"><INPUT TYPE="submit" VALUE="Download" name="submit" /></td>
</tr>
</table>
</form>
<?php
}
// Liste les données de la table
// -------------------------------------------
elseif (isset($_POST['submit']) && isset($HTTP_POST_VARS['jour']) && isset($HTTP_POST_VARS['mois']) && isset($HTTP_POST_VARS['an'])) {
$date= " " . $an . "-" . $mois . "-". $jour . " " ;
$chifr=100000;
$resQuery = "select p.delivery_name, p.last_modified as lm, op.products_tax as tx, op.products_price as pp, p.orders_id as oid, p.delivery_postcode, p.delivery_street_address, p.delivery_city, p.customers_telephone from " . TABLE_ORDERS . " p, " . TABLE_ORDERS_PRODUCTS . " op where p.orders_id = op.orders_id and p.orders_status = '" . (int)$chifr . "' ";
$date=" and p.last_modified like '" . $date . "%' ";
echo $date;
$resQuery = tep_db_query($resQuery . $date);
header("Content-disposition: filename=table.csv");
header("Content-Type: application/vnd.ms-excel");
header("Content-Transfer-Encoding: binary"); // Surtout ne pas enlever le \n
header("selfclose()");
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";
}
}
}
else
{
}
?>
<?php require(DIR_WS_INCLUDES . 'application_bottom.php'); ?>