Advertisement
Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- <?php
- error_reporting(0);
- //error_reporting(E_ALL ^ (E_NOTICE | E_WARNING));
- $uri = $_SERVER['REQUEST_URI'];
- $uri = explode("/", $uri);
- include "$_SERVER[DOCUMENT_ROOT]/$uri[1]/conf/connection.php";
- // include "conf/connection.php";
- $query = $db->query("SELECT * FROM ts_kepegawaian WHERE id_kepegawaian ='".$_GET['id']."'");
- //menampilkan hasil query dalam bentuk object
- //bisa juga menggunakan mysql_fetch_assoc atau mysql_fetch_array dll
- $rows = $query->fetch_object();
- $id_kepegawaian = $rows->id_kepegawaian;
- $id_pegawai = $rows->id_pegawai;
- $id_bidang = $rows->id_bidang;
- $id_jabatan = $rows->id_jabatan;
- $id_gaji = $rows->id_gaji;
- $tanggal = $rows->tanggal;
- ?>
- <div class="col-lg-12">
- <div class="card">
- <div class="card-header">
- <strong>Edit</strong> Kepegawaian
- </div>
- <div class="card-body card-block">
- <form action="?target=kepegawaian&action=update" method="post" enctype="multipart/form-data" class="form-horizontal">
- <input type="hidden" name="id_kepegawaian" value="<?php echo $id_kepegawaian; ?>">
- <div class="row form-group">
- <div class="col col-md-3"><label for="select" class=" form-control-label">nip</label></div>
- <div class="col-9 col-md-6">
- <select name="id_pegawai" id="select" class="form-control">
- <?php
- include "conf/connection.php";
- $q = $db->query("select * from tb_pegawai");
- while($r = $q->fetch_array()){
- ?>
- <option <?php if ( $r['id_pegawai'] == $nip ){echo 'selected';} ?> value="<?php echo $r['id_pegawai'];?>">
- <?php
- echo $r['nip'];?>
- </option>
- <?php }?>
- </select>
- </div>
- </div>
- <div class="row form-group">
- <div class="col col-md-3"><label for="select" class=" form-control-label">pegawai</label></div>
- <div class="col-9 col-md-6">
- <select name="id_pegawai" value="<?php echo $nm_pegawai; ?>" class="form-control">
- <option ></option>
- <?php
- include "conf/connection.php";
- $q = $db->query("select * from tb_pegawai");
- while($r = $q->fetch_array()){
- ?>
- <option <?php if ($r['id_pegawai'] == $nm_pegawai){
- echo 'selected'; } ?> value="<?php echo $r['id_pegawai'];?>">
- <?php echo $r['nm_pegawai'];?>
- </option>
- <?php }?>
- </select>
- </div>
- </div>
- <div class="row form-group">
- <div class="col col-md-3"><label for="select" class=" form-control-label">bidang</label></div>
- <div class="col-9 col-md-6">
- <select name="id_bidang" id="select" class="form-control">
- <?php
- include "conf/connection.php";
- $q = $db->query("select * from tb_bidang");
- while($r = $q->fetch_array()){
- ?>
- <option <?php if ( $r['id_bidang'] == $bidang ){echo 'selected';} ?> value="<?php echo $r['id_bidang'];?>">
- <?php
- echo $r['bidang'];?>
- </option>
- <?php }?>
- </select>
- </div>
- </div>
- <div class="row form-group">
- <div class="col col-md-3"><label for="select" class=" form-control-label">jabatan</label></div>
- <div class="col-9 col-md-6">
- <select name="id_jabatan" id="select" class="form-control">
- <?php
- include "conf/connection.php";
- $q = $db->query("select * from tb_jabatan");
- while($r = $q->fetch_array()){
- ?>
- <option <?php if ( $r['id_jabatan'] == $jabatan ){echo 'selected';} ?> value="<?php echo $r['id_jabatan'];?>">
- <?php
- echo $r['jabatan'];?>
- </option>
- <?php }?>
- </select>
- </div>
- </div>
- <div class="row form-group">
- <div class="col col-md-3"><label for="select" class=" form-control-label">kls_jabatan</label></div>
- <div class="col-9 col-md-6">
- <select name="id_jabatan" id="select" class="form-control">
- <?php
- include "conf/connection.php";
- $q = $db->query("select * from tb_jabatan");
- while($r = $q->fetch_array()){
- ?>
- <option <?php if ( $r['id_jabatan'] == $kls_jabatan ){echo 'selected';} ?> value="<?php echo $r['id_jabatan'];?>">
- <?php
- echo $r['kls_jabatan'];?>
- </option>
- <?php }?>
- </select>
- </div>
- </div>
- <div class="row form-group">
- <div class="col col-md-3"><label for="select" class=" form-control-label">bobot</label></div>
- <div class="col-9 col-md-6">
- <select name="id_jabatan" id="select" class="form-control">
- <?php
- include "conf/connection.php";
- $q = $db->query("select * from tb_jabatan");
- while($r = $q->fetch_array()){
- ?>
- <option <?php if ( $r['id_jabatan'] == $bobot ){echo 'selected';} ?> value="<?php echo $r['id_jabatan'];?>">
- <?php
- echo $r['bobot'];?>
- </option>
- <?php }?>
- </select>
- </div>
- </div>
- <div class="row form-group">
- <div class="col col-md-3"><label for="select" class=" form-control-label">golongan</label></div>
- <div class="col-9 col-md-6">
- <select name="id_jabatan" id="select" class="form-control">
- <?php
- include "conf/connection.php";
- $q = $db->query("select * from tb_jabatan");
- while($r = $q->fetch_array()){
- ?>
- <option <?php if ( $r['id_jabatan'] == $golongan ){echo 'selected';} ?> value="<?php echo $r['id_jabatan'];?>">
- <?php
- echo $r['golongan'];?>
- </option>
- <?php }?>
- </select>
- </div>
- </div>
- <div class="row form-group">
- <div class="col col-md-3"><label for="select" class=" form-control-label">gaji_bersih</label></div>
- <div class="col-9 col-md-6">
- <select name="id_gaji" id="select" class="form-control">
- <?php
- include "conf/connection.php";
- $q = $db->query("select * from tb_gaji");
- while($r = $q->fetch_array()){
- ?>
- <option <?php if ( $r['id_gaji'] == $gaji_bersih ){echo 'selected';} ?> value="<?php echo $r['id_gaji'];?>">
- <?php
- echo $r['gaji_bersih'];?>
- </option>
- <?php }?>
- </select>
- </div>
- </div>
- <div class="row form-group">
- <div class="col col-md-3"><label for="text-input" class=" form-control-label">Tanggal</label></div>
- <div class="col-12 col-md-9"><input type="date" name="tanggal" value="<?php echo $tanggal; ?>" class="form-control"></div>
- </div>
- <input type="hidden" name="id_kepegawaian" value="<?php echo $id_kepegawaian; ?>">
- <input type="submit" class="btn btn-primary btn-sm" value="Simpan">
- <a href="?target=kepegawaian" class="btn btn-danger btn-sm"> Kembali</a>
- </form>
- </div>
- </div>
- </div>
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement