<?php

//------------------------------------------------------------------------------------------------
header("Content-type: application/vnd.ms-excel; charset=UTF-16LE");
header("Content-disposition: attachment; filename=".$mysql_tbl."-" .date("Y-m-d").".csv");
$out = fopen('temp.csv', 'w');

$conds=" where 1=1 ";
if ($_GET['id'] != '')
{
  $conds .= " and id_evenement=".$_GET['id'];
}

if ($_GET['type'] == '0')
{
  $conds .= " and ( top_paiement = 'PAYE PAYPAL' or top_paiement = 'CHEQUE' or top_paiement = 'AUCUN' )";
}

$csv = '';
$res = mysqli_query($link_bdd,"desc ".$mysql_tbl);
$FName = Array();
$num = 0;
while($field = mysqli_fetch_assoc($res)) {
  if(!in_array($field['Field'], $hidden_fields_on_lst))
  {
    if (count($displayed_fields_name) && in_array($field['Field'], $displayed_fields_name))
    {
      $csv = $csv.ucfirst($displayed_fields_name[$field['Field']]).";";
    }
    else
    {
      $csv = $csv.ucfirst($field['Field']).";";
    }
  }
  $FName[] = $field['Field'];
  $num++;
}
$csv =substr($csv, 0, -1);
$csv = $csv."\n";

$res = mysqli_query($link_bdd, "select * from ".$mysql_tbl.$conds." ".($orderBy?" order by ".$orderBy."":''));
while($row = mysqli_fetch_row($res))
{
  for($f=0; $f<$num; $f++)
  {
    $data = $row[$f];
    if(!in_array($FName[$f], $hidden_fields_on_lst))
    {
      $csv = $csv.html_entity_decode($data, ENT_QUOTES,'UTF-8').";";
    }
  }
  $csv = $csv."\n";
}


fputs($out, $csv);
fclose($out);
$ret = file_get_contents('temp.csv');
echo chr(255).chr(254).mb_convert_encoding( $ret, 'UTF-16LE', 'UTF-8');

exit;

?>