Postingan lainnya
Buku Ini Koding!
Baru!
Buku ini akan jadi teman perjalanan kamu belajar sampai dapat kerjaan di dunia programming!
Kelas Premium!
Belajar bikin website dari nol sekarang
Gunakan kupon "lebihcepat" untuk diskon 25%!
Kelas Premium!
Belajar Javascript untuk website
Gunakan kupon "mulaijs" untuk diskon 75 ribu!
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