fetch_one("SHOW CREATE TABLE $tbl");
if (!empty($res)){
$output .= $res['Create Table'].";\n\n";
}
$output .= "-- \n-- Dumping data for table `".$tbl."`\n-- \n\n";
$data = $db->fetch_all("SELECT * FROM $tbl");
if (!empty($data)){
foreach ($data as $ks => $dt){
$output .= "INSERT INTO `$tbl` VALUES(";
$outputdata = '';
foreach ($dt as $dtt){
$dtt = mysql_real_escape_string($dtt);
$outputdata .= ", '$dtt'";
}
$outputdata = substr($outputdata,2);
$output .= $outputdata.");\n";
}
}
$output .= "\n-- --------------------------------------------------------\n\n";
return $output;
}
if (checkFormValue('doing') && $_POST['doing'] == 'generating'){
$show_query = "SHOW TABLE STATUS";
$show = $db->fetch_all($show_query);
if (sizeof($show) == 0){
echo 'Error: Could not backup database
';
echo 'MySQL Error: '. @mysql_error().'
';
echo 'Click HERE to return';
exit;
}
$backup = '';
foreach($show as $tabs){
$backup .= PrintOut($backup,$tabs['Name']);
}
if (!empty($backup)){
$formattedtimenowbk = date('j-M-Y-H-i-s');
$filenamedefined = 'db_ecommerce-'.$formattedtimenowbk.'.sql';
header('Content-type: application/sql');
header('Content-Disposition: attachment; filename="'.$filenamedefined.'";');
echo $backup;
exit;
}
else{
echo 'Error: Could not backup database
';
echo 'MySQL Error: '. @mysql_error().'
';
echo 'Click HERE to return';
exit;
}
}
require_once 'incl/global_template.php';
$theme = gettemplate('backup');
eval("\$theme = \"$theme\";");
echo $theme;
?>