Advertisement
Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- if (!isset($error) && $uploadOk == 1) {
- //insert to DB
- try {
- //insert into database with a prepared statement
- $stmt = $db->prepare('INSERT INTO temp_calpenerima (NIK, Nama, Jenis_Kelamin, Umur, Pekerjaan, Alamat, Penghasilan, Tanggungan,
- Luas_Tanah, Luas_Bangunan, Kondisi_Dinding, Kondisi_Atap, Kondisi_Lantai, File_Gambar)
- VALUES (:no_ktp, :nama, :jenis_kelamin, :umur, :pekerjaan, :alamat, :penghasilan, :tanggungan,
- :luas_tanah, :luas_bangunan, :kondisi_dinding, :kondisi_atap, :kondisi_lantai, :file_gambar)');
- $stmt->execute(array(
- ':no_ktp' => $_POST['noKTP'],
- ':nama' => $_POST['nama'],
- ':jenis_kelamin' => $_POST['jenis_kelamin'],
- ':umur' => $_POST['umur'],
- ':pekerjaan' => $_POST['pekerjaan'],
- ':alamat' => $_POST['alamat'],
- ':penghasilan' => $_POST['penghasilan'],
- ':tanggungan' => $_POST['tanggungan'],
- ':luas_tanah' => $_POST['luas_tanah'],
- ':luas_bangunan' => $_POST['luas_bangunan'],
- ':kondisi_dinding' => $_POST['kondisi_dinding'],
- ':kondisi_atap' => $_POST['kondisi_atap'],
- ':kondisi_lantai' => $_POST['kondisi_lantai'],
- ':file_gambar' => basename($file_name)
- ));
- move_uploaded_file($file_temp, $target_file);
- //redirect
- header('Location: form_surat_usulan.php?action=success');
- exit;
- //else catch the exception and show the error.
- } catch(PDOException $e) {
- $error[] = $e->getMessage();
- }
- } else {
- ?>
- <div class="row">
- <div class="col-lg-6">
- <div class="alert alert-dismissable alert-danger">
- <button type="button" class="close" data-dismiss="alert">×</button>
- <?php
- foreach($error as $error){echo "<strong>".$error."</strong></br>";}
- ?>
- </div>
- </div>
- </div>
- <?php
- }?>
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement