Advertisement
Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- >>Combo Box
- <?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>";
- }
- ?>
- =======================================================================================================
- >>Function GetData
- 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];
- }
- getSiswa($conn,[$kode_siswa])
- =============================================================================================================
- >>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>
- --------------------------------------------------------------------------------------------------------------------------------
- COMBO//
- ==================================================================
- <?php
- $s="select * from `tb_supplier`";
- $q=mysql_query($s);
- while($d=mysql_fetch_array($q)){
- $kode_supplier0=$d["kode_supplier"];
- $nama_supplier=$d["nama_supplier"];
- echo"<option value='$kode_supplier0' ";if($kode_supplier0==$kode_supplier){echo"selected";} echo">$nama_supplier |$kode_supplier0</option>";
- }
- ?>
- <?php
- function getKategori($kode){
- $sql="select * from `tb_kategori` where `kode_kategori`='$kode'";
- $exe=mysql_query($sql);
- $data=mysql_fetch_array($exe);
- $nama_kategori=$data["nama_kategori"];
- $keterangan=$data["keterangan"];
- return "$kode - $nama_kategori";
- ////////////////////////////////////////////////////
- ACORDEON
- ===============================================================================================
- <link href="js/jquery-ui.css" rel="stylesheet">
- <script src="js/jquery-1.8.2.js"></script>
- <script src="js/jquery-ui-1.9.0.custom.js"></script>
- <script type="text/javascript">
- $(document).ready(function(){
- $("#isi").accordion({
- animated: "easeOutBounce"
- });
- });
- </script>
- >>>>>
- <body style="font-size:65%;">
- <div id="isi">
- <h2><a href="#">Input Data Barang</a></h2>
- <div>
- >>>>>
- </div>
- <h2><a href="#">Data Barang</a></h2>
- <div>
- >>>>>>>>>
- </div>
- </div>
- </body>
- >>>>>>>>>
- =====================================================================
- DISTINC()
- ======================================================================
- <?php
- $sv="select distinct(kategori) from `$tbbarang` order by `kode_barang` desc";
- $qv=mysql_query($sv);
- $jumv=mysql_num_rows($qv);
- while($dv=mysql_fetch_array($qv)){
- $kategori=$dv["kategori"];
- ?>
- <h2><a href="#">Data <?php echo"$kategori";?></a></h2>
- <div>
- >>
- sql lihat= $s="select * from `$tbbarang` where kategori='$kategori' order by `kode_barang` desc";
- >>
- after jmldata
- echo"</div>";
- }//distinct
- ==================================================================================
- SINGLE REPORT
- ==================================================================================
- >add function Print1
- function PRINT1(kategori){
- win=window.open('barang/print.php?kategori='+kategori,'win',..........
- >>>>
- | <a href="barang/pdf.php?kategori=<?php echo $kategori;?>" ><img src='ypathicon/pdf.png' alt='PDF'></a>
- | <img src='ypathicon/print.png' alt='PRINT' OnClick="PRINT1('<?php echo $kategori;?>')"> |
- >>
- in print.php add:
- $s="select * from `$tbbarang` order by `kode_barang` desc";
- if(isset($_GET["kategori"])){
- $kategori=$_GET["kategori"];
- $s="select * from `$tbbarang` where kategori='$kategori' order by kode_barang desc";
- }
- >>
- pdf.php:
- $s="select * from `$tbbarang`";
- if(isset($_GET["kategori"])){
- $kategori=$_GET["kategori"];
- $s="select * from `$tbbarang` where kategori like '$kategori'";
- }
- $sql = mysql_query($s);
- $jml = mysql_num_rows($sql);
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement