/*---------- export.php ------------ */
$value) {
if($value == "invoegen") {
$fields = mysql_list_fields($_POST['database'], $key) or die(mysql_error());
$columns = mysql_num_fields($fields);
for ($i = 0; $i < $columns; $i++) {
if($i > 0) { $fieldstr .= "," . mysql_field_name($fields, $i); }
else { $fieldstr = mysql_field_name($fields, $i); }
// echo mysql_field_name($fields, $i) . "
\n";
}
$query = mysql_query("SELECT " . $fieldstr . " FROM $key") or die(mysql_error());
$valuestr .= "\r\nDELETE FROM $key;\r\n";
while($var = mysql_fetch_object($query)) {
// $valuestr .= "INSERT INTO $key ($fieldstr) VALUES ";
$valuestr .= "INSERT INTO $key VALUES ";
for ($i = 0; $i < $columns; $i++) {
$column = mysql_field_name($fields, $i);
$columnvalue = str_replace("\r\n","\\r\\n",$var->$column);
$columnvalue = mysql_escape_string($columnvalue);
if($i > 0) { $valuestr .= ",'" . $columnvalue . "'"; }
else { $valuestr .= "('" . $columnvalue . "'"; }
}
//$valuestr = str_replace("<","<",$valuestr);
//$valuestr = str_replace(">",">",$valuestr);
//$valuestr = str_replace("\r\n","\\r\\n",$valuestr);
$valuestr .= ");\r\n";
}
}
}
$backfile = $schrijfbare_map . $bestandsnaam;
$fp = fopen($backfile,"w+");
fwrite($fp,$valuestr);
fclose($fp);
$f = fopen($backfile, "r");
$contents = fread($f, filesize($backfile));
fclose($f);
unlink($backfile);
header("Content-type: application/force-download");
header("Content-Disposition: inline; filename=" . $bestandsnaam);
header("Pragma: no-cache");
header("Expires: 0");
echo($contents);
exit;
// echo str_replace(");\n",");
",$valuestr);
}
?>
Gemaakt door dekoffie.
Gemaakt door dekoffie.