Postingan lainnya
Kelas Premium!
Belajar bikin website dari nol sekarang
Gunakan kupon "lebihcepat" untuk diskon 25%!
Script combo box tidak berfungsi ketika di edit
Mohon bantuannya yang lagi online, kenapa code combo box di php gak berfungsi ketika ada di file edit ? padahal script nya juga sama dengan script add.. Ini script edit.php nya :
<?php
include 'config/koneksi.php';
$id = $_GET['id'];
$pesan = "";
$query = "SELECT * FROM book_appointment2 WHERE guess='$id'";
$result = mysqli_query($koneksi, $query);
$data = mysqli_fetch_array($result);
$divisi = array();
$query = "SELECT * FROM divisi";
$result = mysqli_query($koneksi, $query);
while($row = mysqli_fetch_array($result)) {
$data_divisi = array("kode_divisi" => $row["kode_divisi"], "nama_divisi" => $row["nama_divisi"]);
array_push($divisi, $data_divisi);
}
$karyawan = array();
$query = "SELECT * FROM karyawan";
$result = mysqli_query($koneksi, $query);
while($row = mysqli_fetch_array($result)) {
$data_karyawan = array("nik" => $row["NIK"], "nama" => $row["Nama"], "kode_divisi" => $row["kode_divisi"] );
array_push($karyawan, $data_karyawan);
}
?>
<!DOCTYPE html>
<html lang="en">
<head>
<meta charset="utf-8">
<meta http-equiv="X-UA-Compatible" content="IE=edge">
<meta name="viewport" content="width=device-width, initial-scale=1">
<!-- The above 3 meta tags *must* come first in the head; any other head content must come *after* these tags -->
<meta name="description" content="">
<meta name="author" content="">
<title>Book Appointment</title>
<!-- Bootstrap core CSS -->
<link rel="stylesheet" href="https://maxcdn.bootstrapcdn.com/bootstrap/3.3.7/css/bootstrap.min.css" integrity="sha384-BVYiiSIFeK1dGmJRAkycuHAHRg32OmUcww7on3RYdg4Va+PmSTsz/K68vbdEjh4u" crossorigin="anonymous">
<link rel="stylesheet" href="css/bootstrap-datetimepicker.css" />
<!-- css dibawah ini hanya untuk demo-->
<style>
body {
padding-top: 70px;
}
footer {
padding: 30px 0;
}
</style>
</head>
<body>
<nav class="navbar navbar-fixed-top navbar-inverse">
<div class="container">
<div class="navbar-header">
<button type="button" class="navbar-toggle collapsed" data-toggle="collapse" data-target="#navbar" aria-expanded="false" aria-controls="navbar">
<span class="sr-only">Toggle navigation</span>
<span class="icon-bar"></span>
<span class="icon-bar"></span>
<span class="icon-bar"></span>
</button>
<a class="navbar-brand">Book Appointment</a>
</div>
<div id="navbar" class="collapse navbar-collapse">
<ul class="nav navbar-nav">
<li class="active"><a href="bookappointment.php">Home</a></li>
<li><a href="crud_tabel.php">Agenda</a></li>
</ul>
</div><!-- /.nav-collapse -->
</div><!-- /.container -->
</nav><!-- /.navbar -->
<div class="container">
<div class="row row-offcanvas row-offcanvas-right">
<div class="col-xs-12 col-sm-8">
<p class="pull-right visible-xs">
<button type="button" class="btn btn-primary btn-xs" data-toggle="offcanvas">Toggle nav</button>
</p>
<div>
<p><?php echo $pesan ?></p>
<form action="simpan_edit2.php" method="POST">
<div class="form-group">
<label for="novisitor">No Visitor</label>
<input type="number" name="novisitor" class="form-control" id="novisitor" value="<?php echo $data['novisitor'] ?>">
</div>
<div class="form-group">
<label for="date">Date</label>
<input type="text" name="date" class="form-control" id="date" value="<?php echo $data['date'] ?>">
</div>
<div class="form-group">
<label for="date">Tanggal Keluar</label>
<input type="text" name="datekeluar" class="form-control" id="date_2" value="<?php echo $data['datekeluar'] ?>">
</div>
<div class="form-group">
<label for="guess">Guess</label>
<input type="text" name="guess" class="form-control" id="guess" value="<?php echo $data['guess'] ?>">
</div>
<div class="form-group">
<label for="company">Company</label>
<input type="text" name="company" class="form-control" id="company" value="<?php echo $data['company'] ?>">
</div>
<div class="form-group">
<label for="reasonforvisit">Reason For Visit</label>
<textarea name="reasonforvisit" class="form-control" id="reasonforvisit"><?php echo $data['reasonforvisit'] ?></textarea>
</div>
<div class="form-group">
<label for="mid">Meet With Employee</label>
<select class="form-control" id="mid" name="mid">
<?php
foreach ($divisi as $key => $value) {
echo "<optgroup label='".$value['nama_divisi']."'>";
foreach ($karyawan as $key => $value_2) {
if($value['kode_divisi'] == $value_2['kode_divisi'] ){
echo "<option value='".$value_2['nama']."'>".$value_2['nama']."</option>";
}
}
echo "</optgroup>";
}
?>
</select>
</div>
<div class="form-group">
<label for="ktpnumber">No Identity</label>
<div class="panel-group">
<div class="panel panel-default">
<div class="panel-heading">
<h2 class="panel-title">
<a data-toggle="collapse" href="#collapse1">KTP</a>
</br>
</br><a data-toggle="collapse" href="#collapse1">PASPOR</a>
</br>
</br><a data-toggle="collapse" href="#collapse1">SIM</a>
</br>
</br><a data-toggle="collapse" href="#collapse1">NPWP</a>
</br>
</br><a data-toggle="collapse" href="#collapse1">ASKES</a>
</h2>
</div>
<div id="collapse1" class="panel-collapse collapse">
<input type="number" name="ktpnumber" class="form-control" id="ktpnumber">
</div>
</div>
</div>
</div>
<label for="nopol">No Polisi</label>
<input type="text" name="nopol" class="form-control" id="nopol" value="<?php echo $data['nopol'] ?>">
<div class="form-group">
<label for="phonenumber">Phone Number</label>
<input type="number" name="phonenumber" class="form-control" id="phonenumber" value="<?php echo $data['phonenumber'] ?>">
</div>
<input type="hidden" name="guess" value="<?php echo $data['guess'] ?>">
<input type="submit" name="submit" class="btn btn-primary" value="Update"/>
<a href="crud_table2.php" class="btn btn-default">Cancel</a>
</form>
</div>
</div><!--/.col-xs-12.col-sm-9-->
<hr>
</div><!--/.container-->
<!-- Bootstrap core JavaScript
================================================== -->
<!-- Placed at the end of the document so the pages load faster -->
<script src="https://ajax.googleapis.com/ajax/libs/jquery/1.12.4/jquery.min.js"></script>
<script type="text/javascript" src="js2/moment.js"></script>
<script type="text/javascript" src="js2/bootstrap-datetimepicker.js"></script>
<script type="text/javascript">
$(function () {
$('#date').datetimepicker({
format: 'YYYY-MM-DD HH:mm:ss'
});
$('#date_2').datetimepicker({
format: 'YYYY-MM-DD HH:mm:ss'
});
});
</script>
</body>
</html>
0
Belum ada Jawaban. Jadi yang pertama Jawaban
Login untuk ikut Jawaban