CariKelompokTaniUser.php

/si_petani/CariKelompokTaniUser.php

https://bitbucket.org/ArgoWibowo/dutatani
PHP | 191 lines | 177 code | 10 blank | 4 comment | 4 complexity | a412370533ac9d4e029e281cd6cb3b51 MD5 | raw file

<?php 
  session_start();
  $koneksi = include("koneksi.php");
  $katakunci = $_POST['input_cari']; 

    // jika kotak pencarian tidak sama dengan kosong
    if(!empty($katakunci)) 
    {
    // query mysql untuk mencari berdasarkan nama negara. .
      $sql = mysqli_query($koneksi,"select * from master_kel_tani where Nama_Kelompok_Tani like '%$katakunci%' 
        or ID_Kelompok_Tani like '%$katakunci%' or Alamat_Sekretariat like '%$katakunci%' or Kabupaten like '%$katakunci%' or 
        Kecamatan like '%$katakunci%' or Provinsi like '%$katakunci%' or Desa_Kelurahan like '%$katakunci%' or 
        Kontak_Person like '%$katakunci%' or  Nomor_Telpon like '%$katakunci%' or id_user like '%$katakunci%' or 
        Email like '%$katakunci%'") or die (mysql_error());   
    }
    else 
    {
      $sql = mysqli_query($koneksi,"select * from master_kel_tani") or die (mysql_error());
    }

   // mengecek data
   $cek = mysqli_num_rows($sql);
  ?>
<html>
<head>
        <meta charset="utf-8">
        <meta name="viewport" content="width=device-width, initial-scale=1">
        <script type="text/javascript" src="http://cdnjs.cloudflare.com/ajax/libs/jquery/2.0.3/jquery.min.js"></script>
        <script type="text/javascript" src="http://netdna.bootstrapcdn.com/bootstrap/3.3.4/js/bootstrap.min.js"></script>
        <link href="http://cdnjs.cloudflare.com/ajax/libs/font-awesome/4.3.0/css/font-awesome.min.css" rel="stylesheet" type="text/css">
        <link href="design\coba2.css" rel="stylesheet" type="text/css">
        <link href="design\side-bar.css" rel="stylesheet">
</head>
<nav class="navbar navbar-default">
  <div class="container-fluid">
    <div class="navbar-header">
      <button type="button" class="navbar-toggle collapsed" data-toggle="collapse" data-target="#bs-example-navbar-collapse-1" aria-expanded="false">
        <span class="sr-only">Toggle navigation</span>
        <span class="icon-bar"></span>
        <span class="icon-bar"></span>
        <span class="icon-bar"></span>
      </button>
      <a class="navbar-brand" href="#">Pangkalan Data Petani dan Komunitas Tani</a>
    </div>  
    <div class="collapse navbar-collapse" id="bs-example-navbar-collapse-1">
      <ul class="nav navbar-nav navbar-right">
        <?php                   
        $id_user = $_SESSION['ID_User'];                                       
        mysql_connect("localhost","root","") or die(mysql_error());
        mysql_select_db("iais_ukdw") or die("Database tidak ditemukan");
        $query= mysql_query("SELECT * FROM master_petani where ID_User = '$id_user';");
        $brsnama = mysql_fetch_array($query)
        ?>
        <li style="background-color: #34A853"><a href="#">Selamat Datang <?php echo $brsnama['Nama_Petani'] ?></a></li>
        <li style="background-color: #34A853"><a href="logout.php">Keluar</a></li>
          </ul>
        </li>
      </ul>
    </div>
  </div>
</nav>

 <nav class="navbar navbar-default no-margin">
    <!-- Brand and toggle get grouped for better mobile display -->
                <div class="navbar-header fixed-brand">
                    <button type="button" class="navbar-toggle collapsed" data-toggle="collapse"  id="menu-toggle">
                      <span class="glyphicon glyphicon-th-large" aria-hidden="true"></span>
                    </button>
                    <a class="navbar-brand" href="#"><i class="fa fa-server fa-4"></i> MENU</a> 
                </div><!-- navbar-header-->
 
                <div class="collapse navbar-collapse" id="bs-example-navbar-collapse-1">
                            <ul class="nav navbar-nav">
                                <li class="active" ><button class="navbar-toggle collapse in" data-toggle="collapse" id="menu-toggle-2"> <span class="glyphicon glyphicon-tasks" aria-hidden="true"></span></button></li>
                            </ul>
                            <ul>
                </div><!-- bs-example-navbar-collapse-1 -->
    </nav>
    <div id="wrapper">
        <!-- Sidebar -->
        <div id="sidebar-wrapper">
            <ul class="sidebar-nav nav-pills nav-stacked" id="menu" >
                <li>
                    <a><span class="fa-stack fa-lg pull-left"><i class="fa fa-server fa-stack-1x "></i></span> Pangkalan Data</a>
                       <ul class="nav-pills nav-stacked" style="list-style-type:none;">
                        <li><a href="KelompokTaniUser.php"> Pendataan Kelompok Tani</a></li>
                        <li><a href="DataKelompokTaniUser.php"> Daftar Kelompok Tani</a></li>
                        <li><a href="StrukturOrganisasiUser.php"> Pendataan Struktur Organisasi</a></li>
                        <li><a href="DataStrukturOrganisasiUser.php"> Daftar Struktur Organisasi</a></li>
                        <li><a href="KeangotaanPetaniUser.php"> Pendataan Keanggotaan Petani</a></li>
                        <li><a href="DataKeanggotaanPetaniUser.php"> Daftar Keanggotaan Petani</a></li>
                    </ul>
                </li>
               <li>
                    <a href="#"><span class="fa-stack fa-lg pull-left"><i class="fa fa-server fa-stack-1x "></i></span> Informasi Kelompok Tani</a>
                    <ul class="nav-pills nav-stacked" style="list-style-type:none;">
                        <li><a href=""> Berdasarkan Wilayah</a></li>
                        <li><a href=""> Berdasarkan Lama Terbentuk</a></li>
                        <li><a href=""> Berdasarkan Perkembangan Kelompok Tani</a></li>              
                        <li><a href=""> Berdasarkan Keanggotaan Petani</a></li>
                    </ul>
                </li>
                
               </div><!-- /#sidebar-wrapper -->        <!-- Page Content -->

        <!-- /#page-content-wrapper -->
    <!-- /#wrapper -->
    <!-- jQuery -->
    <script src="design/side_menu.js"></script>

        <div class="section">
            <div class="container">
                <div class="row">
                    <div class="col-md-12">
                        <h1>Daftar Kelompok Tani</h1>
                    </div>
                    <div style="margin-bottom:15px;" align="center">
                <form action="DataKelompokTaniUser.php" method="post">
                    <input type="text" name="input_cari" placeholder="Cari" style="height:30px;width:430px;color:black;"
                    value="<?php echo $katakunci; ?>" />
                    <input type="submit" name="cari" value="Reset" class="btn-md btn-danger" style="padding:3px;" margin="6px;" width="50px;"  />
                </form>
                </div>
                </div>
            </div>
        </div>
        <div class="section">
            <div class="container">
                <div class="row">
                    <div class="col-md-12">
                    <style>
                        div.scroll {
                        width: 1080px;
                        overflow: auto;
                        }
                    </style>
                    <div class ="scroll">

                      <?php
                       // jika data kurang dari 1
                       if($cek < 1) {
                        ?>
                         <p>Data Tidak Ditemukan!</p>
                      <?php
                       }
                       else
                       {
                      ?>
                        <table class="table">
                            <thead>
                                <tr>
                                    <th>No</th>
                                    <th>Nama Kelompok Tani</th>
                                    <th>Alamat Sekretariat</th>
                                    <th>Provinsi</th>                                    
                                    <th>Kabupaten</th>
                                    <th>Kecamatan</th>
                                    <th>Desa / kelurahan</th>
                                    <th>Opsi</th>

                                </tr>
                            </thead>
                            <?php
                                  $no = 1;
                                  while($kel_tani = mysqli_fetch_array($sql)){
                            ?>   
                            <tbody>
                                <tr>
                                    <td><?php echo $no++ ?></td>
                                    <td><?php echo $kel_tani['Nama_Kelompok_Tani']?></td>
                                    <td><?php echo $kel_tani['Alamat_Sekretariat']?></td>
                                    <td><?php echo $kel_tani['Provinsi']?></td>
                                    <td><?php echo $kel_tani['Kabupaten']?></td>
                                    <td><?php echo $kel_tani['Kecamatan']?></td>
                                    <td><?php echo $kel_tani['Desa_Kelurahan']?></td>
                                    <td><?php echo $kel_tani['Deskripsi']?></td>
                                    <td><a class="btn btn-s btn-primary" href="DetailKelompokTaniUser.php?id=<?php 
                                    echo $kel_tani['ID_Kelompok_Tani'] ?>">Detail</a></td>                                   
                                </tr>
                                <?php

                                }}?>
                            </tbody>
                        </table>
                    </div>
                    </div>
                </div>
            </div>
        </div>
</body>
</html>