X

Create New Item

File Folder

X

Search Results

etiquette

File "index.php"

Full path: /home/meharicl/www/etiquette/index.php
File size: 2.36 KiB (2413 bytes)
MIME-type: text/html
Charset: 8 bit

Download   Open   Edit   Advanced Edit   Back 

<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.01 Transitional//EN" "http://www.w3.org/TR/html4/loose.dtd">

<html>

<head>
<title>Sans Titre</title>
<meta http-equiv="content-type" content="text/html; charset=iso-8859-1" />
<meta name="generator" content="HAPedit 3.1">
</head>
<body bgcolor="#FFFFFF">
<?
  // Your code here
  $fp = fopen('file.csv', 'w');
  $csv[0]="an";
  $csv[1]="N";
  $csv[2]="Categorie";
  $csv[3]="Nom";
  $csv[4]="Prenom";
  $csv[5]="Adresse 1";
  $csv[6]="Adresse 2";
  $csv[7]="Adresse 3";
  $csv[8]="Code Postal";
  $csv[9]="Ville";
  $csv[10]="Nom Pays";


  fputcsv($fp, $csv,";");
  //extraction BDD
  $link = mysqli_connect("meharicltest.mysql.db", "meharicltest", "Pva131254", "meharicltest");
if (!$link) {                                                                                                
    echo "Erreur : Impossible de se connecter  MySQL." . PHP_EOL;                                           
    echo "Errno de dbogage : " . mysqli_connect_errno() . PHP_EOL;                                          
    echo "Erreur de dbogage : " . mysqli_connect_error() . PHP_EOL;                                         
    exit;}
    $sql="SELECT * FROM `member` ORDER BY `member`.`reference` ASC" ;
     $liste=$link->query($sql);

     while($member=$liste->fetch_assoc())
        {
        $csv[0]=$member['tags'];$csv[0]=str_replace(';','',$csv[0]);
        $csv[1]=$member['reference'];
        $csv[2]="";
        $csv[3]=$member['nom'];
        $csv[4]=$member['prenom'];
        $csv[5]=clean_str($member['adresse']);
        $csv[6]=get_libre($member['libre'],23);
        $csv[7]=get_libre($member['libre'],26);
        $csv[8]=$member['codePostal'];
        $csv[9]=$member['ville'];
        $csv[10]=$member['complementAdresse'];


        //$csv[6]=get_libre(26,$member['libre']);




        //var_dump($csv);
        fputcsv($fp, $csv,";");
        }
fclose($fp);
echo('<a href="file.csv">file</a> ');
function clean_str($chaine)
{
$chaine=str_replace(chr(13), '',  $chaine);
$chaine=str_replace(chr(10), '',  $chaine);
$chaine=str_replace(chr(9), '',  $chaine);
return($chaine);
}
function get_libre($libre,$id)
{
$libre=$libre.";";
$k0=strpos($libre,$id."=");
$k1=$k0+strlen($id)+1;
$k2=strpos($libre,";",$k1);
return(substr($libre,$k1,$k2-$k1));
}

?>
</body>

</html>