Advertisement
Guest User

Untitled

a guest
Feb 28th, 2015
184
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 1.79 KB | None | 0 0
  1. if (!isset($error) && $uploadOk == 1) {
  2. //insert to DB
  3.  
  4. try {
  5. //insert into database with a prepared statement
  6. $stmt = $db->prepare('INSERT INTO temp_calpenerima (NIK, Nama, Jenis_Kelamin, Umur, Pekerjaan, Alamat, Penghasilan, Tanggungan,
  7. Luas_Tanah, Luas_Bangunan, Kondisi_Dinding, Kondisi_Atap, Kondisi_Lantai, File_Gambar)
  8. VALUES (:no_ktp, :nama, :jenis_kelamin, :umur, :pekerjaan, :alamat, :penghasilan, :tanggungan,
  9. :luas_tanah, :luas_bangunan, :kondisi_dinding, :kondisi_atap, :kondisi_lantai, :file_gambar)');
  10. $stmt->execute(array(
  11. ':no_ktp' => $_POST['noKTP'],
  12. ':nama' => $_POST['nama'],
  13. ':jenis_kelamin' => $_POST['jenis_kelamin'],
  14. ':umur' => $_POST['umur'],
  15. ':pekerjaan' => $_POST['pekerjaan'],
  16. ':alamat' => $_POST['alamat'],
  17. ':penghasilan' => $_POST['penghasilan'],
  18. ':tanggungan' => $_POST['tanggungan'],
  19. ':luas_tanah' => $_POST['luas_tanah'],
  20. ':luas_bangunan' => $_POST['luas_bangunan'],
  21. ':kondisi_dinding' => $_POST['kondisi_dinding'],
  22. ':kondisi_atap' => $_POST['kondisi_atap'],
  23. ':kondisi_lantai' => $_POST['kondisi_lantai'],
  24. ':file_gambar' => basename($file_name)
  25. ));
  26. move_uploaded_file($file_temp, $target_file);
  27.  
  28. //redirect
  29. header('Location: form_surat_usulan.php?action=success');
  30. exit;
  31.  
  32. //else catch the exception and show the error.
  33. } catch(PDOException $e) {
  34. $error[] = $e->getMessage();
  35. }
  36. } else {
  37. ?>
  38. <div class="row">
  39. <div class="col-lg-6">
  40. <div class="alert alert-dismissable alert-danger">
  41. <button type="button" class="close" data-dismiss="alert">&times;</button>
  42. <?php
  43. foreach($error as $error){echo "<strong>".$error."</strong></br>";}
  44. ?>
  45. </div>
  46. </div>
  47. </div>
  48. <?php
  49. }?>
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement