Advertisement
Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- <html>
- <head>
- <?php
- include "config/connect.php";
- $query = mysql_fetch_array(mysql_query("SELECT MAX(kd_napi) as kode from narapidana"));
- $lastID = $query['kode'];
- $lastNoUrut = substr($lastID, 3, 9);
- $nextNoUrut = $lastNoUrut + 1;
- $nextID = "N-".sprintf("%03s",$nextNoUrut);
- ?>
- </head>
- <body>
- <h1>Form Input (Create)</h1>
- <form id="form_input" method="POST">
- <div class="form-group">
- <label class="control-label col-md-3">Kode Narapidana</label>
- <div class="col-md-9">
- <input type="text" class="form-control" readonly="" name="kode" value="<?php echo $nextID; ?>">
- </div>
- </div>
- <div class="form-group">
- <label class="control-label col-md-3">Nama Lengkap</label>
- <div class="col-md-9">
- <input type="text" class="form-control" required name="nama" placeholder="Nama Lengkap">
- </div>
- </div>
- <div class="form-group">
- <label class="control-label col-md-3">NIK Narapidana</label>
- <div class="col-md-9">
- <input required type="text" class="form-control" name="nik" placeholder="NIK Narapidana">
- </div>
- </div>
- <div class="form-group">
- <label class="control-label col-md-3">Pasal Pidana</label>
- <div class="col-md-9">
- <select class="form-control" id="form_control_1" name="psl">
- <option>Pasal Pidana</option>
- <?php
- $w = mysql_query('select pasal from kuhp order by pasal asc');
- if(mysql_num_rows($w)>0){
- while ($q = mysql_fetch_array($w)) {
- ?>
- <option value="<?php $q['pasal'] ?> "> <?php echo $q['pasal'] ?> </option>
- <?php
- }
- }
- ?>
- </select>
- </div>
- </div>
- <div class="form-group">
- <label class="control-label col-md-3">Kode Kamar</label>
- <div class="col-md-9">
- <select class="form-control" id="form_control_1" name="kmr">
- <option>Kode Kamar</option>
- <?php
- $w = mysql_query('select kd_kamar from kamar order by kd_kamar asc');
- if(mysql_num_rows($w)>0){
- while ($q = mysql_fetch_array($w)) {
- ?>
- <option value="<?php $q['kd_kamar'] ?> "> <?php echo $q['kd_kamar'] ?> </option>
- <?php
- }
- }
- ?>
- </select>
- </div>
- </div>
- </div>
- <div class="form-group">
- <input type="submit" value="Simpan" name="simpan" class="btn btn-primary">
- <input type="reset" value="Reset" class="btn btn-danger">
- </div>
- </form>
- </div>
- </div>
- </div>
- </body>
- </html>
- <?php
- if(isset($_POST['simpan']))
- {
- $simpan = "INSERT INTO narapidana(kd_napi, nik_napi, nama_napi,kd_kamar,pasal_pidana) VALUES
- ('$_POST[kode]',
- '$_POST[nik]',
- '$_POST[nama]',
- '$_POST[kmr]',
- '$_POST[psl]')";
- $sql = mysql_query ($simpan) or die (mysql_error());
- if($sql){
- echo 'Data berhasil di simpan! '; //Pesan jika proses simpan sukses
- echo '<a href="index.php">Kembali</a>'; //membuat Link untuk kembali ke halaman edit
- }else{
- echo 'Gagal menyimpan data! '; //Pesan jika proses simpan gagal
- echo '<a href="index.php">Kembali</a>'; //membuat Link untuk kembali ke halaman edit
- }
- }
- ?>
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement