$null = $_POST['export_csv_replacenull']; $crlf = isset($_POST['export_csv_crlf']); $fields_in_first_row = isset($_POST['export_csv_fieldnames']); $db = new Database($_SESSION[COOKIENAME . 'currentDB']); echo $db->export_csv($tables, $field_terminate, $field_enclosed, $field_escaped, $null, $crlf, $fields_in_first_row); } } exit; } //- Import a file into an existing database if (isset($_POST['import'])) { $db = new Database($_SESSION[COOKIENAME . 'currentDB']); $db->registerUserFunction($custom_functions); if ($_POST['import_type'] == "sql") { $data = file_get_contents($_FILES["file"]["tmp_name"]); $importSuccess = $db->import_sql($data); } else { $field_terminate = $_POST['import_csv_fieldsterminated']; $field_enclosed = $_POST['import_csv_fieldsenclosed']; $field_escaped = $_POST['import_csv_fieldsescaped']; $null = $_POST['import_csv_replacenull']; $fields_in_first_row = isset($_POST['import_csv_fieldnames']); $importSuccess = $db->import_csv($_FILES["file"]["tmp_name"], $_POST['single_table'], $field_terminate, $field_enclosed, $field_escaped, $null, $fields_in_first_row); } } //- Download (backup) a database file (as SQLite file, not as dump) if (isset($_GET['download']) && isManagedDB($_GET['download']) !== false) { header("Content-type: application/octet-stream"); header('Content-Disposition: attachment; filename="' . basename($_GET['download']) . '";'); header("Pragma: no-cache"); header("Expires: 0");