$jam=date("H:i:s");
===============================
>>Combo Box Berelasi
<?php
$s="select * from `kelas`";
$q=getData($conn,$s);
foreach($q as $d){
$kls_ajar0=$d["kls_ajar"];
$nm_wali=$d["nm_wali"];
echo"<option value='$kls_ajar0' ";if($kls_ajar0==$kls_ajar){echo"selected";} echo">$kls_ajar0 - $nm_wali </option>";
}
?>
di kode_siswa ( yang di relasikan )
getSiswa($conn,[$kode_siswa])
----------------------------------------------------------
>>Function GetData di Index
function getGuru($conn,$kode){
$field="nama_guru";
$sql="SELECT `$field` FROM `guru` where `kd_guru`='$kode'";
$rs=$conn->query($sql);
$rs->data_seek(0);
$row = $rs->fetch_assoc();
$rs->free();
return $row[$field];
}
=============================================================================================================
>>Contoh Combo Box Berdiri Sendiri
<tr>
<td valign="top"><label for="hari">Hari</label>
<td valign="top">:<td colspan="2"><select name="hari" id="status">
<option value="-">Pilih Hari</option>
<option value="Senin" <?php if($hari=="Senin"){echo "selected";} ?>>Senin</option>
<option value="Selasa" <?php if($hari=="Selasa"){echo "selected";} ?>>Selasa</option>
<option value="Rabu" <?php if($hari=="Rabu"){echo "selected";} ?>>Rabu</option>
<option value="Kamis" <?php if($hari=="Kamis"){echo "selected";} ?>>Kamis</option>
<option value="Jum'at" <?php if($hari=="Jum'at"){echo "selected";} ?>>Jum'at</option>
<option value="Sabtu" <?php if($hari=="Sabtu"){echo "selected";} ?>>Sabtu</option>
<option value="Minggu" <?php if($hari=="Minggu"){echo "selected";} ?>>Minggu</option>
</select></td></tr>
==========================================================================================
>>Accordion Bounce
Di copy (folder jss accordion) ke folder webnya
----------------------------------------------------------
<link href="jss/jquery-ui.css" rel="stylesheet">
<script src="jss/jquery-1.8.2.js"></script>
<script src="jss/jquery-ui-1.9.0.custom.js"></script>
<script type="text/javascript">
$(document).ready(function(){
$("#accordion").accordion({
animated: "easeOutBounce"
});
});
</script>
----------------------------------------------------------
>>Di atas tabel Input
<body style="font-size:65%;">
<div id="isi">
<h2><a href="#">Menu Input Harga</a></h2>
<div>
>>Di atas Data Admin
</div>
<h2><a href="#">Data PO Status</a></h2>
<div>
<br />
>>Di atas if(isset($_POST["Simpan])){
</div>
</div>
>>Accordion Biasa
Di copy (folder jss accordion) ke folder webnya
----------------------------------------------------------
<link rel="stylesheet" href="js/jquery-ui.css">
<link rel="stylesheet" href="resources/demos/style.css">
<script src="js/jquery-1.12.4.js"></script>
<script src="js/jquery-ui.js"></script>
<script>
$( function() {
$( "#accordion" ).accordion({
collapsible: true
});
} );
</script>
----------------------------------------------------------
>>Di atas tabel Input
<div id="accordion">
<h3>Input Data Admin</h3>
<div>
>>Di atas Data Admin
</div>
<h3>Data Admin</h3>
<div>
<br />
>>Di atas if(isset($_POST["Simpan])){
</div>
</div>
</body>
>>Accordion Bootstrap
>>Di atas tabel Input
<!-----ACCORDION----->
<div class="panel-group" id="accordion">
<div class="panel panel-default">
<div class="panel-heading">
<h4 class="panel-title">
<a data-toggle="collapse" data-parent="#accordion" href="#collapse1">
<font color="#0000FF">Input Data Admin</font></a>
</h4>
</div>
<div id="collapse1" class="panel-collapse collapse in">
<div class="panel-body">
<!-----ACCORDION----->
>>Di atas Data Admin
<!-----ACCORDION----->
</div>
</div>
</div>
<div class="panel panel-default">
<div class="panel-heading">
<h4 class="panel-title">
<a data-toggle="collapse" data-parent="#accordion" href="#collapse2">
<font color="#0000FF">Lihat Data Admin</font></a>
</h4>
</div>
<div id="collapse2" class="panel-collapse collapse">
<div class="panel-body">
<!-----ACCORDION----->
<br />
>>Di atas if(isset($_POST["Simpan])){
<!-----ACCORDION----->
</div>
</div>
</div>
</div>
<!-----ACCORDION----->
=====================================================================================================
>>Fungsi - class current/active
//";if($mnu=="home"){echo"class='current'";} echo"
=============================================================================================================
>>Distinc
<?php
$sqlq="select distinct(kls_ajar) from `$tbpengampu` order by `kd_pengampu` desc";
$jumq=getJum($conn,$sqlq);
if($jumq <1){
echo"<h1>Maaf data belum tersedia...</h1>";
}
$arrq=getData($conn,$sqlq);
foreach($arrq as $dq) {
$kls_ajar=$dq["kls_ajar"];
?>
<h2><a href="#">Data Kelas <?php echo"$kls_ajar";?></a></h2>
<div>
++++++++++++++++++++++++
$sql="select * from `$tbpengampu` where kls_ajar='$kls_ajar' order by `kd_pengampu` desc";
++++++++++++++++++++++++
echo "</div>";
}
?>
</div>
</body>
=============================================================================================================
>>Menghilangkan Header/Slider/jQuery yg bentrok/Dan lain-lain
<?php if($mnu=="home" || $mnu==""){?>
<?php }?>
( atau )
<?php if($mnu=="home" || $mnu==""){?>
<?php }else{?>
<?php }?>
( atau ) jika ada dua yg bentrok/lebih
<?php if($mnu=="" || $mnu=="login" || $mnu=="home"){?>
<?php }?>
=============================================================================================================
class="table table-striped table-bordered table-hover"
=============================================================================================================
if(!isset($_SESSION["cid"]))
{
die("<script>location.href='login.php';</script>");
}