kamar-input.php

<?php
require ('library/config.php');
//Autonumber ID
$a = 'KMR/01/0';
$pilih = mysql_query("SELECT MAX(id_kamar) AS MaxID FROM ap_kamar WHERE id_kamar LIKE '$a%'");
$data = mysql_fetch_array($pilih);
$b = substr($data['MaxID'],8,2);
$c = (int)$b;
$d = $c + 1;
//Insert ke database
if(isset($_POST['submit'])){
    $id = $_POST['txtID'];
    $type = $_POST['txtType'];
    $status = $_POST['txtStatus'];
    $query = "INSERT INTO `app`.`ap_kamar`(`id_kamar` ,`status_kamar` ,`id_fasilitas`) VALUES('$id','$status','$type')";
    if(mysql_query($query)){
        $m = '';
        $m = 'display:none;';
    }else{
        echo "<script>alert('gagal');</script>";
        $m = 'display:none;';
        $m = '';
    }
}else{
$m = "display:none;";
$n = "display:none;";
}
;?>

 <div class="row">
          <div class="col-lg-12">
            <h1>Data Kamar <small>Add Room</small></h1>
            <ol class="breadcrumb">
              <li class="active"><i class="fa fa-dashboard"></i> <a href="?page=kamar">Kamar</a></li>
              <li>Tambah Kamar</li>
            </ol>
            <div class='alert alert-success alert-dismissable' style="<?php echo $m ;?>">
              <button type='button' class='close' data-dismiss='alert' aria-hidden='true'>&times;</button>
              <b>Penambahan data berhasil !</b> <a class='alert-link' href='?page=kamar-view&id=$id'><i>Lihat Hasil<i></a> .
              <button type='button' class='close' data-dismiss='alert' aria-hidden='true'>&times;</button>
              <b>Penambahan data gagal !</b> Pastikan data yang dimasukan benar ! .
            </div>
            <div class='alert alert-danger alert-dismissable' style="<?php echo $n ;?>" >
            </div>
            <div class="panel-body">
                <div class="table-responsive">

            <form action="<?php $_SERVER['PHP_SELF'];?>" method="POST" >
            <table class="table table-bordered table-hover table-striped " >
                <tr>
                    <th colspan="3" ><h2 >Tambah Kamar</h2></th>
                <tr>
                <tr>
                    <td>ID-Kamar</td>
                    <td align="center">:</td>
                    <td><input type="text" value="<?php echo $a.sprintf('%02s',$d) ; ?>" name="txtID" id="txtID" size="30" maxlength="30" required/></td>
                </tr>
                <tr>
                    <td>Type Kamar</td>
                    <td align="center">:</td>
                    <td>
                    <select name="txtType" required>
                    <option><--Pilih Option--></option>
                    <?php
                        $fasi = mysql_query("SELECT * FROM ap_fasilitas ");
                        while($list=mysql_fetch_assoc($fasi)){
                    ?>
                    <option value="<?php echo $list['id_fasilitas'];?>"><?php echo $list['type'];?></option>
                    <?php } ?>
                    </select>
                    </td>
                </tr>
                <tr>
                    <td>Status Kamar</td>
                    <td align="center">:</td>
                    <td>
                    <p>
                        <label>
                            <input name="txtStatus" type="radio" id="RadioGroup" value="1" checked="checked" />
                        Available</label>
                        <br />
                        <label>
                            <input type="radio" name="txtStatus" value="0" id="RadioGroup" />
                        Not Available</label>
                        <br />
                    </p>
                    </td>
                </tr>
                <tr>
                    <td>&nbsp;</td>
                    <td>&nbsp;</td>
                    <td><input type="submit" class="button" value="SUBMIT"/>&nbsp;<input type="reset" class="button" value="RESET"/>&nbsp;<input type="button" value="KEMBALI" class="button" onClick="self.history.back()"></td>
                </tr>
            </table>
            </form><!--End Form-->
                </div>
            </div><!--End Responsive Table-->

          </div>
        </div><!-- /.row -->