Guest User

Untitled

a guest
Aug 22nd, 2018
193
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 1.14 KB | None | 0 0
  1. <?php
  2. $db = pg_connect("host=localhost port=5432 dbname=karepku user=postgres password=k1ngk0ng");// Check connection
  3.  
  4. $handle = fopen($_FILES["uploaded"]["tmp_name"], "r");
  5. if ($handle)
  6. {
  7. while (($line = fgets($handle)) !== false)
  8. {
  9.  
  10. $lineArr = explode("t", "$line");
  11. var_dump($lineArr);
  12. // instead assigning one by onb use php list -> http://php.net/manual/en/function.list.php
  13. list($nmr_fingerprint, $tgl_presensine, $pegawai_idne, $validasi_a, $validasi_b, $stat) = $lineArr;
  14.  
  15. // and then insert data
  16. $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')";
  17. }
  18. $insert = pg_query($query_insert);
  19. $content.= "<div class='success' id='message'>Berhasil di import</div>";
  20. }
  21. fclose($handle);
  22. $content.= <<<EOF
  23. <h4>Import Data</h4>
  24. <form enctype="multipart/form-data" action="" method="post">
  25. File:<input name="uploaded" type="file" maxlength="20" /><input type="submit" name="upfile" value="Upload File">
  26. </form>
  27. EOF;
  28. echo $content;
Add Comment
Please, Sign In to add comment