function do_import()
{
global $err_msg, $out_message, $dbh;
if ($_FILES['file1'] && $_FILES['file1']['name']) {
$filename = $_FILES['file1']['tmp_name'];
if (!do_multi_sql('', $filename)) {
$err_msg = "Error: " . mysql_error($dbh);
} else {
$out_message = 'Import done successfully';
do_sql('show tables');
return;
}
} else {
$err_msg = "Error: Please select file first";
}
print_import();
exit;
}
function do_import()
{
global $err_msg, $out_message, $dbh, $SHOW_T;
$err_msg = '';
$F = $_FILES['file1'];
if ($F && $F['name']) {
$filename = $F['tmp_name'];
$pi = pathinfo($F['name']);
if ($pi['extension'] != 'sql') {
//if not sql - assume .gz
$tmpf = tmp_name();
if (($gz = gzopen($filename, 'rb')) && ($tf = fopen($tmpf, 'wb'))) {
while (!gzeof($gz)) {
if (fwrite($tf, gzread($gz, 8192), 8192) === FALSE) {
$err_msg = 'Error during gz file extraction to tmp file';
break;
}
}
//extract to tmp file
gzclose($gz);
fclose($tf);
$filename = $tmpf;
} else {
$err_msg = 'Error opening gz file';
}
}
if (!$err_msg) {
if (!do_multi_sql('', $filename)) {
$err_msg = 'Import Error: ' . mysql_error($dbh);
} else {
$out_message = 'Import done successfully';
do_sql($SHOW_T);
return;
}
}
} else {
$err_msg = "Error: Please select file first";
}
print_import();
exit;
}
