Postingan lainnya
membuat autofill pada textbox/combobox pada php yang terkoneksi dengan MYSQL (native -php)?
//form ini berbentuk sebuah modal bootstrap yang diklik dari opsi tabel pada 1 record dari //halaman view_document.php
<!-- Modal -->
<div class="modal fade" id="revisi" role="dialog">
<div class="modal-dialog">
<!-- Modal content-->
<div class="modal-content">
<div class="modal-header">
<button type="button" class="close" data-dismiss="modal">×</button>
<h4 class="modal-title">Revisi</h4>
</div>
<div class="modal-body">
<form class="form-horizontal" action="" method="post" enctype="multipart/form-data">
<fieldset>
<!-- Jenis Dokumen-->
<?php
include "config.php";
error_reporting(0);
$hasil=mysql_query("SELECT * FROM tb_jenis_dokumen");
?>
<div class="form-group">
<label class="col-md-3 control-label" for="name">Jenis Dokumen</label>
<div class="col-md-6">
<select class="form-control" id="jenis_dokumen" name="jenis_dokumen" disabled>
<option value="">Pilih Jenis Dokumen</option>
<?php
while ($baris = mysql_fetch_array($hasil)){
?>
<option value="<?php echo $baris[id_jenis_dokumen];?>"><?php echo $baris[jenis_dokumen];?></option>
<?php
}
?>
</select>
</div>
</div>
<!-- Judul Dokumen-->
<div class="form-group">
<label class="col-md-3 control-label" for="name">Judul</label>
<div class="col-md-6">
<input id="nama_dokumen" name="nama_dokumen" type="text" class="form-control" disabled>
</div>
</div>
<!--status-->
<?php
include "config.php";
error_reporting(0);
$hasil=mysql_query("SELECT * FROM status_dokumen");
?>
<div class="form-group">
<label class="col-md-3 control-label" for="name">Jenis Dokumen</label>
<div class="col-md-6">
<select class="form-control" id="status" name="status" disabled>
<option value="">Status Dokumen</option>
<?php
while ($baris = mysql_fetch_array($hasil)){
?>
<option value="<?php echo $baris[id_status_dokumen];?>"><?php echo $baris[status_dokumen];?></option>
<?php
}
?>
</select>
</div>
</div>
<div class="form-group">
<label class="col-md-3 control-label" for="file">File</label>
<div class="col-md-6">
<input id="file" name="file" type="file" placeholder="file" class="form-control">
</div>
</div>
<div class="form-group">
<label class="col-md-3 control-label" for="keterangan">Keterangan</label>
<div class="col-md-6">
<textarea class="form-control" id="keterangan" name="keterangan" rows="5"></textarea>
</div>
</div>
<!-- Tombol Submit -->
<div class="form-group">
<div class="col-md-12 widget-right">
<input type="submit" class="btn btn-primary btn-md pull-left" name="update" value="Update">
</div>
</div>
</fieldset>
</form>
</div>
<div class="modal-footer">
<button type="button" class="btn btn-default" data-dismiss="modal">Close</button>
</div>
</div>
</div>
</div>
<?php
if(isset($_POST['update'])){
$nama_dokumen = $_POST['nama_dokumen'];
$jenis_dokumen = $_POST['jenis_dokumen'];
$keterangan=$_POST['keterangan'];
$entry_date=$_POST['entry_date'];
$file = rand(1000,100000)."-".$_FILES['file']['name'];
$file_loc = $_FILES['file']['tmp_name'];
$file_size = $_FILES['file']['size'];
$file_type = $_FILES['file']['type'];
$folder="../uploads/";
$status=$_POST['status'];
move_uploaded_file($file_loc,$folder.$file);
$query = "UPDATE tb_dokumen_baru
SET nama_dokumen='$nama_dokumen',
file='$file',
keterangan='$keterangan',
jenis_dokumen='$jenis_dokumen',
status='$status',
entry_date=NOW()
WHERE nama_dokumen='$nama_dokumen';";
$result=mysql_query($query);
//validasi
if($nama_dokumen==""||$jenis_dokumen==""||
$file==""||$status==""){
echo '<script>
alert("salah satu kolom tidak boleh kosong");
</script>';
}
else {
echo '<script>
alert("dokumen sudah direvisi");
document.location="view_document.php";
</script>';
}
}
?>
//view_document.php
<body>
<?php $title="View Document"; ?>
<?php require_once('header.php') ?>
<?php require_once('sidebar.php') ?>
<?php include('add_dokumen.php'); ?>
<?php include('edit_dokumen.php'); ?>
<div class="col-sm-9 col-sm-offset-3 col-lg-10 col-lg-offset-2 main">
<div class="row">
<div class="col-md-12">
<div class="panel panel-default">
<div class="panel-heading">
Dokumen Baru
<a href="add_dokumen.php/#add_dokumen" class="btn btn-primary btn-md pull-right" data-toggle="modal">Buat Baru</a>
</div>
<div class="panel-body">
<!--TABEL DOKUMEN UTAMA-->
<div class="row">
<div class="col-lg-12">
<div class="panel panel-default">
<div class="panel-body">
<table data-toggle="table" data-show-refresh="true" data-show-toggle="true" data-show-columns="true" data-search="true" data-select-item-name="toolbar1" data-pagination="true" data-sort-name="name" data-sort-order="asc">
<thead>
<tr>
<th data-field="jenis_dokumen">Jenis</th>
<th data-field="nama_dokumen">Judul</th>
<th data-field="unit">Unit Terkait</th>
<th data-field="revisi">Revisi Ke- </th>
<th data-field="status_dokumen">Status</th>
<th data-field="keterangan">Keterangan</th>
<th data-field="entry_date">Tanggal Pengajuan</th>
<th colspan="1">Opsi</th>
</tr>
</thead>
<tbody>
<?php
$query = mysql_query("SELECT
tb_jenis_dokumen.jenis_dokumen,
tb_dokumen_baru.nama_dokumen,
tb_admin.unit,
tb_dokumen_baru.entry_date,
tb_dokumen_baru.keterangan,
tb_dokumen_baru.revisi,
tb_dokumen_baru.`file`,
status_dokumen.status_dokumen
FROM
tb_dokumen_baru
Inner Join tb_admin ON tb_dokumen_baru.id_admin = tb_admin.id_admin
Inner Join status_dokumen ON status_dokumen.id_status_dokumen = tb_dokumen_baru.`status`
Inner Join tb_jenis_dokumen ON tb_jenis_dokumen.id_jenis_dokumen = tb_dokumen_baru.jenis_dokumen
where tb_admin.unit='".$_SESSION['unit']."'
");
while ($data = mysql_fetch_array($query)) {
?>
<tr>
<td><?php echo $data['jenis_dokumen']; ?></td>
<td><?php echo $data['nama_dokumen']; ?></td>
<td><?php echo $data['unit']; ?></td>
<td><?php echo $data['revisi']; ?></td>
<td><?php echo $data['status_dokumen']; ?></td>
<td><?php echo $data['keterangan']; ?></td>
<td><?php echo $data['entry_date'];?></td>
<td>
<ul>
<li>
<?php
$file = $data['file']; //Let say If I put the file name Bang.png
echo "<a href='download_document.php?file=".$file."' class='glyphicon glyphicon-download'></a> ";
?>
</li>
<li>
<a href="edit_dokumen.php/#revisi" data-toggle="modal" class="glyphicon glyphicon-edit"></a>
</li>
</ul>
</td>
</tr>
<?php
}
?>
</tbody>
</table>
</div>
</div>
</div>
</div><!--/.row-->
</div> <!--/.main-->
<script src="js/jquery-1.11.1.min.js"></script>
<script src="js/bootstrap.min.js"></script>
<script src="js/chart.min.js"></script>
<script src="js/chart-data.js"></script>
<script src="js/easypiechart.js"></script>
<script src="js/easypiechart-data.js"></script>
<script src="js/bootstrap-datepicker.js"></script>
<script src="js/bootstrap-table.js"></script>
<script>
!function ($) {
$(document).on("click","ul.nav li.parent > a > span.icon", function(){
$(this).find('em:first').toggleClass("glyphicon-minus");
});
$(".sidebar span.icon").find('em:first').addClass("glyphicon-plus");
}(window.jQuery);
$(window).on('resize', function () {
if ($(window).width() > 768) $('#sidebar-collapse').collapse('show')
})
$(window).on('resize', function () {
if ($(window).width() <= 767) $('#sidebar-collapse').collapse('hide')
})
</script>
</body>
</html>
1
1 Jawaban:
bagian sini bukan gan ? susah ga bsa scroll kesamping,
<div class="form-group">
<label class="col-md-3 control-label" for="name">Jenis Dokumen</label>
<div class="col-md-6">
<select class="form-control" id="jenis_dokumen" name="jenis_dokumen" disabled>
<option value="">Pilih Jenis Dokumen</option>
<?php
while ($baris = mysql_fetch_array($hasil)){
?>
<option value="<?php echo $baris[id_jenis_dokumen];?>"><?php echo $baris[jenis_dokumen];?></option>
<?php
}
?>
</select>
</div>
</div>
0