public static function commit_sauvegarde($type_sauvegarde)
{
$PHP_SELF = $_SERVER['PHP_SELF'];
$session = session_id();
$return = '';
header("Pragma: no-cache");
header("Content-Type: text/x-delimtext; name=\"php_conges_" . $type_sauvegarde . ".sql\"");
header("Content-disposition: attachment; filename=php_conges_" . $type_sauvegarde . ".sql");
//
// Build the sql script file...
//
$maintenant = date("d-m-Y H:i:s");
$return .= "#\n";
$return .= "# PHP_CONGES\n";
$return .= "#\n# DATE : {$maintenant}\n";
$return .= "#\n";
//recup de la liste des tables
$sql1 = "SHOW TABLES";
$ReqLog = \includes\SQL::query($sql1);
while ($resultat = $ReqLog->fetch_array()) {
$table = $resultat[0];
$return .= "#\n#\n# TABLE: {$table} \n#\n";
if ($type_sauvegarde == "all" || $type_sauvegarde == "structure") {
$return .= "# Struture : \n#\n";
$return .= \admin\Fonctions::get_table_structure($table);
}
if ($type_sauvegarde == "all" || $type_sauvegarde == "data") {
$return .= "# Data : \n#\n";
$return .= \admin\Fonctions::get_table_data($table);
}
}
echo $return;
}