81,7 → 81,8 |
$info = array(); |
$champs = array("titre", "code", "version", "domaine_taxo", "domaine_geo", "domaine_nom", "classification", "coordinateur", "auteur", "contributeur", "date_production", "source", "contact", "editeur", "droit", "licence", "referencement"); |
$p = $this->traiterParametresUrl(array("ref","version"), $param, false); |
$fichier = '/home/delphine/tmp/'.date('Y_m_d')."/meta_".$p['version']."_".time().'.csv'; |
$racine_tmp = Config::get('chemin_tmp'); |
$fichier = $racine_tmp.date('Y_m_d')."/meta_".$p['version']."_".time().'.csv'; |
$requete = "SELECT '".implode("', '", $champs)."' UNION ( SELECT ".implode(", ", $champs). |
" INTO OUTFILE '". |
$fichier."' CHARACTER SET utf8 FIELDS TERMINATED BY '\t' OPTIONALLY ENCLOSED BY '' LINES TERMINATED BY '\n' ". |