| [ask] koq gak mau menyimpan ke db ya.. tolong solusinya, gan. TQ
<?php error_reporting(0);
$o = ""; if (isset($_GET['success']) && ($_GET['success'] == "1")) {
$o .= '<div class="alert alert-success"> <a class="close" data-dismiss="alert" href="#">x</a> Proses berhasil </div>'; } elseif (isset($_GET['success']) && ($_GET['success'] == "0")) { $o .= '<div class="alert alert-error"> <a class="close" data-dismiss="alert" href="#">x</a> Proses gagal </div>'; } echo $o;
?>
<form action="?action=add" method="POST"> <div class="span4"> <div class="control-group"> <label>Bayar Uang Kebersihan</label> </div> <div class="control-group"> <label class="control-label" for="input01">Nama Makam </label> <div class="controls"> <select name="makam"><option value="0">Pilih Makam</option> <?php require ('config.php'); $sql = mysql_query("SELECT * FROM `tbl_makam`"); while ($l = mysql_fetch_array($sql)) { echo '<option value="'.$l['makamid'].'">'.$l['nama_almarhum'].'</option>'; } ?> </select> </div> </div> <div class="control-group"> <label class="control-label" for="input01">Bank Tujuan</label> <div class="controls"> <select name="bank"> <option value="0">Pilih Bank</option> <?php require ('config.php'); $sql = mysql_query("SELECT * FROM `tbl_bank`"); while ($l = mysql_fetch_array($sql)) { echo '<option value="'.$l['bank_id'].'">'.$l['nama_bank'].'</option>'; } ?> </select> </div> </div> <div class="control-group"> <label class="control-label" for="input01">Bank Anda</label> <div class="controls"> <input type="text" id="ubank" name="ubank" rel="popover" data-content="Masukkan Bank Anda." data-original-title="Bank Anda"> </div> </div> <div class="control-group"> <label class="control-label" for="input01">Rekening Atas Nama</label> <div class="controls"> <input type="text" id="nama_rek" name="nama_rek" rel="popover" data-content="Masukkan Nama." data-original-title="Rekening Atas Nama"> </div> </div> <div class="control-group"> <label class="control-label" for="input01">Nominal Transfer</label> <div class="controls"> <input type="text" id="nominal" name="nominal" rel="popover" data-content="Masukkan Nominal Transfer." data-original-title="Nominal Transfer"> </div> </div> <div class="control-group"> <label class="control-label" for="input01">Tanggal Transfer</label> <div class="controls"> <input type="text" id="tgl_trans" name="tgl_trans" rel="popover" data-content="Masukkan Tanggal Transfer." data-original-title="Tanggal Transfer"> </div> </div> <div class="control-group"> <label class="control-label" for="input01">Nomor Rekening</label> <div class="controls"> <input type="text" id="norek" name="norek" rel="popover" data-content="Masukkan Nomor Rekening Anda." data-original-title="Nomor Rekening Anda"> </div> </div> <div class="control-group"> <label class="control-label" for="input01"></label> <div class="controls"> <button type="submit" class="btn btn-success">Konfirmasi Pembayaran</button> </div> </div> </div> </form> </div> <hr> <footer> <p>© Pemakaman Kayu Besar Medan 2013</p> </footer> </body> </html> <?php error_reporting(0);
if ($_GET['action'] == "add") { require ('config.php'); $makamid = htmlentities(mysql_real_escape_string($_POST['makamid'])); $bank_id = htmlentities(mysql_real_escape_string($_POST['bank_id'])); $ubank = htmlentities(mysql_real_escape_string($_POST['ubank'])); $nama_rek = htmlentities(mysql_real_escape_string($_POST['nama_rek'])); $nominal = htmlentities(mysql_real_escape_string($_POST['nominal'])); $tgl_trans = htmlentities(mysql_real_escape_string($_POST['tgl_trans'])); $norek = htmlentities(mysql_real_escape_string($_POST['norek'])); // input data ke database $input_bayar = mysql_query("insert into `tbl_bayar` (`makamid`, `bank_id`,`ubank`,`nama_rek`, `nominal`,`tgl_trans`,`norek`) values ('$makamid','$bank_id','$ubank','$nama_rek','$nominal','$tgl_trans','$norek')"); if ($input_bayar) { ?> <script language="javascript"> document.location="?success=1"; </script> <?php } else { ?> <script language="javascript"> document.location="?success=0"; </script> <?php } } ?> |
Tidak ada komentar:
Posting Komentar