Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- <?php
- $db = pg_connect("host=localhost port=5432 dbname=karepku user=postgres password=k1ngk0ng");// Check connection
- $handle = fopen($_FILES["uploaded"]["tmp_name"], "r");
- if ($handle)
- {
- while (($line = fgets($handle)) !== false)
- {
- $lineArr = explode("t", "$line");
- var_dump($lineArr);
- // instead assigning one by onb use php list -> http://php.net/manual/en/function.list.php
- list($nmr_fingerprint, $tgl_presensine, $pegawai_idne, $validasi_a, $validasi_b, $stat) = $lineArr;
- // and then insert data
- $query_insert = "INSERT INTO dari_finger (nmr_fingerprint,tgl_presensine,pegawai_idne,validasi_a,validasi_b,stat) VALUES ('$nmr_fingerprint','$tgl_presensine','$pegawai_idne','$validasi_a','$validasi_b','$stat')";
- }
- $insert = pg_query($query_insert);
- $content.= "<div class='success' id='message'>Berhasil di import</div>";
- }
- fclose($handle);
- $content.= <<<EOF
- <h4>Import Data</h4>
- <form enctype="multipart/form-data" action="" method="post">
- File:<input name="uploaded" type="file" maxlength="20" /><input type="submit" name="upfile" value="Upload File">
- </form>
- EOF;
- echo $content;
Add Comment
Please, Sign In to add comment