Hello merci pour ton aide,
Voici le script complet:
1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31 32 33 34 35
| <?php
session_start();
$annee = date('Y') ;
if(!empty($_POST))
{
$_SESSION['rando'] = $_POST;
}
$rand = trim($_SESSION['rando']['rando']);
//unlink("C:/wamp/bin/mysql/mysql5.6.17/data/test/backup.sql");
//Sauvegarde table
$dbhost = 'localhost';
$dbuser = 'xxxx';
$dbpass = 'xxxx';
$dbdb = 'test';
try {
$connexion = new PDO('mysql:host='.$dbhost.';dbname='.$dbdb, $dbuser, $dbpass);
}
catch (PDOException $e) {
print "Erreur !: " . $e->getMessage() . "<br/>";
die();
}
$table_name = "gghf_rando";
$backup_file = "backup.sql";
$resultats=$connexion->query("SELECT * INTO OUTFILE '$backup_file' FROM $table_name WHERE rando = '$rand' AND annee = '$annee' ");
$resultat = $resultats->fetch(PDO::FETCH_OBJ);
$connexion = null; |
J'ai modifié la ligne en
$resultat = $resultats->fetch(PDO::FETCH_OBJ);
Sans succès car même erreur.
Partager