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>


avatar yogatanaya
@yogatanaya

10 Kontribusi 2 Poin

Diperbarui 6 tahun yang lalu

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>
avatar nanto88
@nanto88

122 Kontribusi 56 Poin

Dipost 6 tahun yang lalu

Login untuk ikut Jawaban