<form method="POST">
<input type="text" id="url" name="url" value="http://example.com/data2iidxsd.sql" size="50" /><br />
<input type="submit" value="import" />
</form>
<form method="POST">
<input type="hidden" id="split" name="split" value="1" />
<input type="submit" value="split" />
</form>
</body>
</html>
HTML;
if ($_POST["split"] == "1") {
execSplit();
}
if ($_POST["url"]) {
inputData();
}
function inputData()
{
$url = $_POST["url"];
$data = file_get_contents($url);
$data = str_replace("\r\n", "\n", $data);
$data = str_replace("\r", "\n", $data);
$list = explode("\n", $data);
array_shift($list);
//$num = count($list);
$sql = <<<SQL
DROP TABLE IF EXISTS temp cascade;
CREATE TABLE temp(
id serial,
no character(4) not null,
<?php
include "../controller/function.php";
$nis = $_POST['nis'];
$nama = $_POST['nama_sales'];
$alamat = $_POST['alamat'];
$telp = $_POST['telp'];
$cabang = $_POST['cabang'];
$stmt = "insert into sales values('{$nis}', '{$nama}', '{$alamat}', '{$telp}', '{$cabang}')";
if (inputData($stmt)) {
echo '{"status":"Data Sales Berhasil Disimpan"}';
} else {
echo '{"status":"Data Dales Gagal Disimpan"}';
}