API tools faq
paste
permanar

Kecamatan Update

permanar
Feb 5th, 2018
141
0
Never
Add comment
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
PHP 11.28 KB | None | 0 0
raw download clone embed print report
  1. <?php
  2. // include database connection file
  3. include_once("../config/config.php");
  4.  
  5. session_start();
  6.  
  7. // Check if form is submitted for user update, then redirect to homepage after update
  8. if(isset($_POST['update']))
  9. {
  10.   $id_kecamatan = $_POST['id_kecamatan'];
  11.  
  12.     $kabupaten = $_POST['kabupaten'];
  13.     $kecamatan = $_POST['kecamatan'];
  14.     $status = $_POST['status'];
  15.  
  16.   // update user data
  17.   $result = mysqli_query($mysqli, "UPDATE `kecamatan` SET `id_kabupaten`='$kabupaten', `kecamatan`='$kecamatan', `status`='$status' WHERE `id_kecamatan`=$id_kecamatan") or die ("Error :".mysqli_error($mysqli));
  18.  
  19.   // Redirect to homepage to display updated user in list
  20.   header("Location: ../kecamatan.php");
  21. }
  22. ?>
  23. <?php
  24. // Display selected user data based on id
  25. // Getting id from url
  26. $id_kecamatan = $_GET['id_kecamatan'];
  27.  
  28. // Fetech user data based on id
  29. $qry = "SELECT * FROM kecamatan kec INNER JOIN kabupaten kab ON kec.id_kabupaten = kab.id_kabupaten WHERE id_kecamatan = '$id_kecamatan'";
  30. $qrys = "SELECT * from kabupaten";
  31. $result = mysqli_query($mysqli, $qry) or die("Error: ".mysqli_error($mysqli));
  32. $results = mysqli_query($mysqli, $qrys) or die("Error: ".mysqli_error($mysqli));
  33.  
  34. while($kecamatans = mysqli_fetch_array($result))
  35. {
  36.   $kecamatan = $kecamatans['kecamatan'];
  37.   $kabupaten = $kecamatans['kabupaten'];
  38.   $status = $kecamatans[3];
  39. }
  40. ?>
  41. <!DOCTYPE html>
  42. <html>
  43. <head>
  44.   <meta charset="utf-8">
  45.   <meta http-equiv="X-UA-Compatible" content="IE=edge">
  46.   <title>AdminLTE 2 | Data Tables</title>
  47.   <!-- Tell the browser to be responsive to screen width -->
  48.   <meta content="width=device-width, initial-scale=1, maximum-scale=1, user-scalable=no" name="viewport">
  49.   <!-- Bootstrap 3.3.7 -->
  50.   <link rel="stylesheet" href="../assets/bower_components/bootstrap/dist/css/bootstrap.min.css">
  51.   <!-- Font Awesome -->
  52.   <link rel="stylesheet" href="../assets/bower_components/font-awesome/css/font-awesome.min.css">
  53.   <!-- Ionicons -->
  54.   <link rel="stylesheet" href="../assets/bower_components/Ionicons/css/ionicons.min.css">
  55.   <!-- DataTables -->
  56.   <link rel="stylesheet" href="../assets/bower_components/datatables.net-bs/css/dataTables.bootstrap.min.css">
  57.   <!-- Theme style -->
  58.   <link rel="stylesheet" href="../assets/dist/css/AdminLTE.min.css">
  59.   <!-- AdminLTE Skins. Choose a skin from the css/skins
  60.        folder instead of downloading all of them to reduce the load. -->
  61.   <link rel="stylesheet" href="../assets/dist/css/skins/_all-skins.min.css">
  62.  
  63.   <!-- HTML5 Shim and Respond.js IE8 support of HTML5 elements and media queries -->
  64.   <!-- WARNING: Respond.js doesn't work if you view the page via file:// -->
  65.   <!--[if lt IE 9]>
  66.   <script src="https://oss.maxcdn.com/html5shiv/3.7.3/html5shiv.min.js"></script>
  67.   <script src="https://oss.maxcdn.com/respond/1.4.2/respond.min.js"></script>
  68.   <![endif]-->
  69.  
  70.   <!-- Google Font -->
  71.   <link rel="stylesheet"
  72.         href="https://fonts.googleapis.com/css?family=Source+Sans+Pro:300,400,600,700,300italic,400italic,600italic">
  73. </head>
  74. <body class="hold-transition skin-blue sidebar-mini">
  75. <div class="wrapper">
  76.  
  77.   <header class="main-header">
  78.     <!-- Logo -->
  79.     <a href="assets/index2.html" class="logo">
  80.       <!-- mini logo for sidebar mini 50x50 pixels -->
  81.       <span class="logo-mini"><b>A</b>LT</span>
  82.       <!-- logo for regular state and mobile devices -->
  83.       <span class="logo-lg"><b>Admin</b>LTE</span>
  84.     </a>
  85.     <!-- Header Navbar: style can be found in header.less -->
  86.     <nav class="navbar navbar-static-top">
  87.       <!-- Sidebar toggle button-->
  88.       <a href="#" class="sidebar-toggle" data-toggle="push-menu" role="button">
  89.         <span class="sr-only">Toggle navigation</span>
  90.         <span class="icon-bar"></span>
  91.         <span class="icon-bar"></span>
  92.         <span class="icon-bar"></span>
  93.       </a>
  94.  
  95.       <div class="navbar-custom-menu">
  96.         <ul class="nav navbar-nav">
  97.           <!-- User Account: style can be found in dropdown.less -->
  98.           <li class="dropdown user user-menu">
  99.             <a href="#" class="dropdown-toggle" data-toggle="dropdown">
  100.               <img src="../assets/dist/img/user2-160x160.jpg" class="user-image" alt="User Image">
  101.               <span class="hidden-xs"><?php echo $_SESSION['username']; ?></span>
  102.             </a>
  103.             <ul class="dropdown-menu">
  104.               <!-- User image -->
  105.               <li class="user-header">
  106.                 <img src="../assets/dist/img/user2-160x160.jpg" class="img-circle" alt="User Image">
  107.  
  108.                 <p>
  109.                   <?php echo $_SESSION['username']; ?>
  110.                   <small>Kabupaten Badung</small>
  111.                 </p>
  112.               </li>
  113.               <!-- Menu Body -->
  114.               <li class="user-body">
  115.                 <div class="row">
  116.                   <div class="col-xs-4 text-center">
  117.                     <a href="#"></a>
  118.                   </div>
  119.                   <div class="col-xs-4 text-center">
  120.                     <a href="#"></a>
  121.                   </div>
  122.                   <div class="col-xs-4 text-center">
  123.                     <a href="#"></a>
  124.                   </div>
  125.                 </div>
  126.                 <!-- /.row -->
  127.               </li>
  128.               <!-- Menu Footer-->
  129.               <li class="user-footer">
  130.                 <div class="pull-left">
  131.                   <a href="../logout.php" class="btn btn-default btn-flat">Log Out</a>
  132.                 </div>
  133.               </li>
  134.             </ul>
  135.           </li>
  136.           <!-- Control Sidebar Toggle Button -->
  137.           <!--<li>
  138.             <a href="#" data-toggle="control-sidebar"><i class="fa fa-gears"></i></a>
  139.           </li>
  140.           !-->
  141.         </ul>
  142.       </div>
  143.     </nav>
  144.   </header>
  145.   <!-- Left side column. contains the logo and sidebar -->
  146.   <aside class="main-sidebar">
  147.     <!-- sidebar: style can be found in sidebar.less -->
  148.     <section class="sidebar">
  149.       <!-- Sidebar user panel -->
  150.       <div class="user-panel">
  151.         <div class="pull-left image">
  152.           <img src="../assets/dist/img/user2-160x160.jpg" class="img-circle" alt="User Image">
  153.         </div>
  154.         <div class="pull-left info">
  155.           <p><?php echo $_SESSION['username']; ?></p>
  156.           <a href="#"><i class="fa fa-circle text-success"></i> Logged In</a>
  157.         </div>
  158.       </div>
  159.       <!-- sidebar menu: : style can be found in sidebar.less -->
  160.       <ul class="sidebar-menu" data-widget="tree">
  161.         <li class="header">MAIN NAVIGATION</li>
  162.         <li class="treeview">
  163.           <a href="#">
  164.             <i class="fa fa-dashboard"></i> <span>Dashboard</span>
  165.             <span class="pull-right-container">
  166.               <i class="fa fa-angle-left pull-right"></i>
  167.             </span>
  168.           </a>
  169.           <ul class="treeview-menu">
  170.             <li><a href="../index.php"><i class="fa fa-circle-o"></i> Dashboard v1</a></li>
  171.             <li><a href="../index.php"><i class="fa fa-circle-o"></i> Dashboard v2</a></li>
  172.           </ul>
  173.         </li>
  174.           <li class="active treeview"><a href="../user.php"><i class="fa fa-book"></i> <span>User</span></a></li>
  175.       </ul>
  176.       </ul>
  177.     </section>
  178.     <!-- /.sidebar -->
  179.   </aside>
  180.  
  181.   <!-- Content Wrapper. Contains page content -->
  182.   <div class="content-wrapper">
  183.     <!-- Content Header (Page header) -->
  184.     <section class="content-header">
  185.       <h1>
  186.         User
  187.       </h1>
  188.       <ol class="breadcrumb">
  189.         <li><a href="#"><i class="fa fa-dashboard"></i> Home</a></li>
  190.         <li><a href="#">Tables</a></li>
  191.         <li class="active">Data tables</li>
  192.       </ol>
  193.     </section>
  194.  
  195.     <!-- Main content -->
  196.     <section class="content">
  197.       <div class="row">
  198.         <!-- left column -->
  199.       <form action="kecamatan_update.php" method="post" name="kecamatan_update">
  200.         <div class="col-md-12">
  201.           <div class="box box-danger">
  202.             <div class="box-header with-border">
  203.               <h3 class="box-title">Update SKPD</h3>
  204.             </div>
  205.             <div class="box-body">
  206.               <div class="row">
  207.                 <div class="col-xs-3">
  208.                   <label for="exampleInputPassword1">Kabupaten</label>
  209.                   <select class="form-control" name="kabupaten">
  210.                   <?php
  211.                       while($kab = mysqli_fetch_array($results))
  212.                       {
  213.                           $idkab = $kab['id_kabupaten'];
  214.                           $kabupaten = $kab['kabupaten'];
  215.                   ?>
  216.                       <option value="<?php echo $idkab?>"><?php echo $kabupaten?></option>
  217.                   <?php
  218.                     }
  219.                   ?>
  220.                 </select>
  221.                 </div>
  222.                 <div class="col-xs-3">
  223.                   <label for="exampleInputPassword1">Kecamatan</label>
  224.                   <input type="text" name="kecamatan" class="form-control" value="<?php echo $kecamatan;?>">
  225.                 </div>
  226.                 <div class="col-xs-3">
  227.                   <label for="exampleInputPassword1">Status</label>
  228.                   <input type="text" name="status" class="form-control" value="<?php echo $status;?>">
  229.                 </div>
  230.               </div>
  231.             </div>
  232.             <!-- /.box-body -->
  233.             <div class="box-footer">
  234.                 <tr>
  235.                   <td><input type="hidden" name="id_kecamatan" value=<?php echo $_GET['id_kecamatan'];?>></td>
  236.                   <td><input type="submit" name="update" value="Update"></td>
  237.                 </tr>
  238.               </div>
  239.         </form>
  240.           </div>
  241.           <!-- /.box -->
  242.         </div>
  243.         <!--/.col (left) -->
  244.  
  245.       </div>
  246.       <!-- /.row -->
  247.     </section>
  248.     <!-- /.content -->
  249.   </div>
  250.   <!-- /.content-wrapper -->
  251.   <footer class="main-footer">
  252.     <div class="pull-right hidden-xs">
  253.       <b>Version</b> 2.4.0
  254.     </div>
  255.     <strong>Copyright &copy; 2014-2016 <a href="https://adminlte.io">Almsaeed Studio</a>.</strong> All rights
  256.     reserved.
  257.   </footer>
  258.  
  259.   <!-- Control Sidebar -->
  260.  
  261.   <!-- /.control-sidebar -->
  262.   <!-- Add the sidebar's background. This div must be placed
  263.        immediately after the control sidebar -->
  264.   <div class="control-sidebar-bg"></div>
  265. </div>
  266. <!-- ./wrapper -->
  267.  
  268. <!-- jQuery 3 -->
  269. <script src="../assets/bower_components/jquery/dist/jquery.min.js"></script>
  270. <!-- Bootstrap 3.3.7 -->
  271. <script src="../assets/bower_components/bootstrap/dist/js/bootstrap.min.js"></script>
  272. <!-- DataTables -->
  273. <script src="../assets/bower_components/datatables.net/js/jquery.dataTables.min.js"></script>
  274. <script src="../assets/bower_components/datatables.net-bs/js/dataTables.bootstrap.min.js"></script>
  275. <!-- SlimScroll -->
  276. <script src="../assets/bower_components/jquery-slimscroll/jquery.slimscroll.min.js"></script>
  277. <!-- FastClick -->
  278. <script src="../assets/bower_components/fastclick/lib/fastclick.js"></script>
  279. <!-- AdminLTE App -->
  280. <script src="../assets/dist/js/adminlte.min.js"></script>
  281. <!-- AdminLTE for demo purposes -->
  282. <script src="../assets/dist/js/demo.js"></script>
  283. <!-- page script -->
  284. <script>
  285.   $(function () {
  286.     $('#example1').DataTable()
  287.     $('#example2').DataTable({
  288.       'paging'      : true,
  289.       'lengthChange': false,
  290.       'searching'   : false,
  291.       'ordering'    : true,
  292.       'info'        : true,
  293.       'autoWidth'   : false
  294.     })
  295.   })
  296. </script>
  297. </body>
  298. </html>
Advertisement
Add Comment
Please, Sign In to add comment
Public Pastes
We use cookies for various purposes including analytics. By continuing to use Pastebin, you agree to our use of cookies as described in the Cookies Policy.  OK, I Understand
Not a member of Pastebin yet?
Sign Up, it unlocks many cool features!