EditKecamatan.php | searchcode

/EditKecamatan.php

https://bitbucket.org/ArgoWibowo/si_petani
PHP | 219 lines | 209 code | 8 blank | 2 comment | 7 complexity | ee84e98c16cec4459ded9327906eb371 MD5 | raw file

<?php
  session_start();
  $koneksi = include("koneksi.php");
  $Kec = $_GET['id'];
  $hasil = mysqli_query($koneksi,"select * from kecamatan where Nama_Kecamatan = '$Kec'");
     while($Kec = mysqli_fetch_array($hasil))
    {   
  ?>
<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><a href="#">Welcome <?php echo $brsnama['Nama_Petani'] ?></a></li>
        <li><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="Wilayah.php"> Pendataan Wilayah</a></li> 
                        <!-- <li><a href="PetaniUser.php">Pendataan Petani</a></li> -->
                        <li><a href="KelompokTani.php">Pendataan Kelompok Tani</a></li>
                        <li><a href="StrukturOrganisasi.php">Pendataan Struktur Organisasi</a></li>
                        <li><a href="KeangotaanPetani.php"> Pendataan 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 Petani</a>
                    <ul class="nav-pills nav-stacked" style="list-style-type:none;">
                        <li><a href="GrafikWilayah.php"> Berdasarkan Wilayah</a></li>
                        <li><a href="#"> Berdasarkan Agama</a>
                          <li>
                              <a href="SumarryTaniAgama.php"><span class="fa-stack fa-lg pull-left"><i class="fa fa-list-alt fa-stack-1x "></i></span> Tabel</a>
                              <a href="GrafikTaniAgama.php"><span class="fa-stack fa-lg pull-left"><i class="fa fa-signal fa-stack-1x "></i></span> Grafik</a>
                          </li>
                        </li>
                        <li><a href="#"> Berdasarkan Usia</a>
                          <li>
                              <a href="SumarryTaniUmur.php"><span class="fa-stack fa-lg pull-left"><i class="fa fa-list-alt fa-stack-1x "></i></span> Tabel</a>
                              <a href="GrafikTaniUmur.php"><span class="fa-stack fa-lg pull-left"><i class="fa fa-signal fa-stack-1x "></i></span> Grafik</a>
                          </li>
                        </li>
                        <li><a href="#"> Berdasarkan Tk. Pendidikan</a>
                          <li>
                              <a href="SumarryTaniPendidikan.php"><span class="fa-stack fa-lg pull-left"><i class="fa fa-list-alt fa-stack-1x "></i></span> Tabel</a>
                              <a href="GrafikTaniPendidikan.php"><span class="fa-stack fa-lg pull-left"><i class="fa fa-signal fa-stack-1x "></i></span> Grafik</a>
                          </li>
                        </li>
                        <li><a href="#"> Berdasarkan Status Petani</a>
                          <li>
                                <a href="SumarryTaniStatus.php"><span class="fa-stack fa-lg pull-left"><i class="fa fa-list-alt fa-stack-1x "></i></span> Tabel</a>
                                <a href="GrafikTaniStatus.php"><span class="fa-stack fa-lg pull-left"><i class="fa fa-signal fa-stack-1x "></i></span> Grafik</a>
                            </li>
                        </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="GrafikKelTaniWilayah.php"> Berdasarkan Wilayah</a></li>
                       
                        <li><a href="#"> Berdasarkan Lama Terbentuk</a>
                          <li>
                              <a href="SumarryKelTaniUmur.php"><span class="fa-stack fa-lg pull-left"><i class="fa fa-list-alt fa-stack-1x "></i></span> Tabel</a>
                              <a href="GrafikKelTaniUmur.php"><span class="fa-stack fa-lg pull-left"><i class="fa fa-signal fa-stack-1x "></i></span> Grafik</a>
                          </li>
                        </li>
                        <li><a href="#"> Berdasarkan Perkembangan Kelompok Tani</a>
                          <li>
                                <a href="SumarryKelTaniPerkemb.php"><span class="fa-stack fa-lg pull-left"><i class="fa fa-list-alt fa-stack-1x "></i></span> Tabel</a>
                                <a href="GrafikKelTaniPerkemb.php"><span class="fa-stack fa-lg pull-left"><i class="fa fa-signal fa-stack-1x "></i></span> Grafik</a>
                          </li>
                        </li>              
                        <li><a href="#"> Berdasarkan Keanggotaan Petani</a>
                        <li>
                                <a href="SumarryKeanggotaanTani.php"><span class="fa-stack fa-lg pull-left"><i class="fa fa-list-alt fa-stack-1x "></i></span> Tabel</a>
                                <a href="GrafikKeanggotaanTani.php"><span class="fa-stack fa-lg pull-left"><i class="fa fa-signal fa-stack-1x "></i></span> Grafik</a>
                          </li>
                        </li>
                        <li><a href="Detail_Kel_Tani.php"> Detail Anggota Kelompok Tani</a></li> 
                        <li><a href="StatistikKelompokTani.php"> Statistik Kelompok Tani</a></li>     
                    </ul>
                </li>
            </div><!-- /#sidebar-wrapper -->
        
    <script src="design/side_menu.js"></script>

<body>

         <div class="section">
            <div class="container">
                <div class="row">
                    <div class="col-md-12">
                        <ul class="nav nav-pills">                     
                        <h1>Pendataan Kecamatan</h1>
                    </div>
                </div>
            </div>
        </div>
         
    <div class="section">
      <div class="container">
        <div class="row">
          <div class="col-md-6">
           <form role="form" action="UpdateKecamatan.php" method="post">
              <div class="form-group">
                <label class="control-label">Nama Kecamatan</label>
                <input class="form-control" name="nama_kec" type="text" value="<?php echo $Kec['Nama_Kecamatan']?>">
              </div>
                <input class="form-control" name="nama_kec1" type="hidden" value="<?php echo $Kec['Nama_Kecamatan']?>">
              <div class="form-group">
                <label class="control-label">Nama Kabupaten</label>
                 <select class="form-control" name="nama_kab" value="<?php echo $Kec['Nama_Kabupaten']?>">
                    <option> Nama Kabupaten </option>
                     <?php
                      //include ("koneksi.php");
                        mysql_connect("localhost","root","") or die(mysql_error());
                        mysql_select_db("iais_ukdw") or die("Database tidak ditemukan");
                        $query2= mysql_query('SELECT * FROM kabupaten;');
                          if (mysql_num_rows($query2) != 0){ 
                            while($brs2 = mysql_fetch_assoc($query2)){
                            if($Kec['Nama_Kabupaten']== $brs2['Nama_Kabupaten']){ 
                            echo '<option value="'.$brs2['Nama_Kabupaten'].'" selected>'.$brs2['Nama_Kabupaten'].'</option>';
                            }else
                            {
                              echo '<option value="'.$brs2['Nama_Kabupaten'].'">'.$brs2['Nama_Kabupaten'].'</option>';
                            }
                          }
                        }
                     ?> 
                </select>
              </div>

              <div class="form-group">
                <label class="control-label">Nama Provinsi</label>
                 <select class="form-control" name="nama_prov"value="<?php echo $Kec['Nama_Provinsi']?>">
                    <option> Nama Provinsi </option>
                     <?php
                      //include ("koneksi.php");
                        mysql_connect("localhost","root","") or die(mysql_error());
                        mysql_select_db("iais_ukdw") or die("Database tidak ditemukan");
                        $query1= mysql_query('SELECT * FROM provinsi;');
                          if (mysql_num_rows($query1) != 0){ 
                            while($brs1 = mysql_fetch_assoc($query1)){
                             if($Kec['Nama_Provinsi']== $brs1['Nama_Provinsi']){ 
                            echo '<option value="'.$brs1['Nama_Provinsi'].'" selected>'.$brs1['Nama_Provinsi'].'</option>';
                            }else
                          {
                            echo '<option value="'.$brs1['Nama_Provinsi'].'">'.$brs1['Nama_Provinsi'].'</option>';
                          }
                        }
                      }
                     ?> 
                </select>
              </div>
              <br>
              <input class="btn btn-primary btn-lg" type="submit" value="submit">
              <br/>
            </form>
          </div>
        </div>
      </div>
    </div>
  <?php
    }
  ?>
</body>
</html>