API tools faq
paste
Advertisement
NgurahGde

elemen_create.php

NgurahGde
Feb 22nd, 2018
85
0
Never
Add comment
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
PHP 13.65 KB | None | 0 0
raw download clone embed print report
  1. <?php
  2. include_once("../config/config.php");
  3.  
  4. session_start();
  5.  
  6. if($_SESSION['status'] !="login"){
  7.     header("location:index.php");
  8. }
  9.  
  10. $result = mysqli_query($mysqli, "SELECT * FROM skpd ORDER BY id_skpd DESC");
  11.  
  12. // $qry = "SELECT * FROM kecamatan kec INNER JOIN kabupaten kab ON kec.id_kabupaten = kab.id_kabupaten";
  13. $qryjenis = "SELECT * from jenis";
  14. $resultjenis = mysqli_query($mysqli, $qryjenis) or die("Error: ".mysqli_error($mysqli));
  15.  
  16. $qryunit = "SELECT * from unit";
  17. $resultunit = mysqli_query($mysqli, $qryunit) or die("Error: ".mysqli_error($mysqli));
  18.  
  19. $qryjadwal = "SELECT * from jadwal";
  20. $resultjadwal = mysqli_query($mysqli, $qryjadwal) or die("Error: ".mysqli_error($mysqli));
  21.  
  22. $qryskpd = "SELECT * from skpd";
  23. $resultskpd = mysqli_query($mysqli, $qryskpd) or die("Error: ".mysqli_error($mysqli));
  24. ?>
  25. <!DOCTYPE html>
  26. <html>
  27. <head>
  28.   <meta charset="utf-8">
  29.   <meta http-equiv="X-UA-Compatible" content="IE=edge">
  30.   <title>AdminLTE 2 | Data Tables</title>
  31.   <!-- Tell the browser to be responsive to screen width -->
  32.   <meta content="width=device-width, initial-scale=1, maximum-scale=1, user-scalable=no" name="viewport">
  33.   <!-- Bootstrap 3.3.7 -->
  34.   <link rel="stylesheet" href="../assets/bower_components/bootstrap/dist/css/bootstrap.min.css">
  35.   <!-- Font Awesome -->
  36.   <link rel="stylesheet" href="../assets/bower_components/font-awesome/css/font-awesome.min.css">
  37.   <!-- Ionicons -->
  38.   <link rel="stylesheet" href="../assets/bower_components/Ionicons/css/ionicons.min.css">
  39.   <!-- DataTables -->
  40.   <link rel="stylesheet" href="../assets/bower_components/datatables.net-bs/css/dataTables.bootstrap.min.css">
  41.   <!-- Theme style -->
  42.   <link rel="stylesheet" href="../assets/dist/css/AdminLTE.min.css">
  43.   <!-- AdminLTE Skins. Choose a skin from the css/skins
  44.        folder instead of downloading all of them to reduce the load. -->
  45.   <link rel="stylesheet" href="../assets/dist/css/skins/_all-skins.min.css">
  46.  
  47.   <!-- HTML5 Shim and Respond.js IE8 support of HTML5 elements and media queries -->
  48.   <!-- WARNING: Respond.js doesn't work if you view the page via file:// -->
  49.   <!--[if lt IE 9]>
  50.   <script src="https://oss.maxcdn.com/html5shiv/3.7.3/html5shiv.min.js"></script>
  51.   <script src="https://oss.maxcdn.com/respond/1.4.2/respond.min.js"></script>
  52.   <![endif]-->
  53.  
  54.   <!-- Google Font -->
  55.   <link rel="stylesheet"
  56.         href="https://fonts.googleapis.com/css?family=Source+Sans+Pro:300,400,600,700,300italic,400italic,600italic">
  57. </head>
  58. <body class="hold-transition skin-blue sidebar-mini">
  59. <div class="wrapper">
  60.  
  61.   <header class="main-header">
  62.     <!-- Logo -->
  63.     <a href="assets/index2.html" class="logo">
  64.       <!-- mini logo for sidebar mini 50x50 pixels -->
  65.       <span class="logo-mini"><b>A</b>LT</span>
  66.       <!-- logo for regular state and mobile devices -->
  67.       <span class="logo-lg"><b>Admin</b>LTE</span>
  68.     </a>
  69.     <!-- Header Navbar: style can be found in header.less -->
  70.     <nav class="navbar navbar-static-top">
  71.       <!-- Sidebar toggle button-->
  72.       <a href="#" class="sidebar-toggle" data-toggle="push-menu" role="button">
  73.         <span class="sr-only">Toggle navigation</span>
  74.         <span class="icon-bar"></span>
  75.         <span class="icon-bar"></span>
  76.         <span class="icon-bar"></span>
  77.       </a>
  78.  
  79.       <div class="navbar-custom-menu">
  80.         <ul class="nav navbar-nav">
  81.           <!-- User Account: style can be found in dropdown.less -->
  82.           <li class="dropdown user user-menu">
  83.             <a href="#" class="dropdown-toggle" data-toggle="dropdown">
  84.               <img src="../assets/dist/img/user2-160x160.jpg" class="user-image" alt="User Image">
  85.               <span class="hidden-xs"><?php echo $_SESSION['username']; ?></span>
  86.             </a>
  87.             <ul class="dropdown-menu">
  88.               <!-- User image -->
  89.               <li class="user-header">
  90.                 <img src="../assets/dist/img/user2-160x160.jpg" class="img-circle" alt="User Image">
  91.  
  92.                 <p>
  93.                   <?php echo $_SESSION['username']; ?>
  94.                   <small>Kabupaten Badung</small>
  95.                 </p>
  96.               </li>
  97.               <!-- Menu Body -->
  98.               <li class="user-body">
  99.                 <div class="row">
  100.                   <div class="col-xs-4 text-center">
  101.                     <a href="#"></a>
  102.                   </div>
  103.                   <div class="col-xs-4 text-center">
  104.                     <a href="#"></a>
  105.                   </div>
  106.                   <div class="col-xs-4 text-center">
  107.                     <a href="#"></a>
  108.                   </div>
  109.                 </div>
  110.                 <!-- /.row -->
  111.               </li>
  112.               <!-- Menu Footer-->
  113.               <li class="user-footer">
  114.                 <div class="pull-left">
  115.                   <a href="../logout.php" class="btn btn-default btn-flat">Log Out</a>
  116.                 </div>
  117.               </li>
  118.             </ul>
  119.           </li>
  120.           <!-- Control Sidebar Toggle Button -->
  121.           <!--<li>
  122.             <a href="#" data-toggle="control-sidebar"><i class="fa fa-gears"></i></a>
  123.           </li>
  124.           !-->
  125.         </ul>
  126.       </div>
  127.     </nav>
  128.   </header>
  129.   <!-- Left side column. contains the logo and sidebar -->
  130.   <aside class="main-sidebar">
  131.     <!-- sidebar: style can be found in sidebar.less -->
  132.     <section class="sidebar">
  133.       <!-- Sidebar user panel -->
  134.       <div class="user-panel">
  135.         <div class="pull-left image">
  136.           <img src="../assets/dist/img/user2-160x160.jpg" class="img-circle" alt="User Image">
  137.         </div>
  138.         <div class="pull-left info">
  139.           <p><?php echo $_SESSION['username']; ?></p>
  140.           <a href="#"><i class="fa fa-circle text-success"></i> Logged In</a>
  141.         </div>
  142.       </div>
  143.       <!-- sidebar menu: : style can be found in sidebar.less -->
  144.       <ul class="sidebar-menu" data-widget="tree">
  145.         <li class="header">MAIN NAVIGATION</li>
  146.         <li class="treeview">
  147.           <a href="#">
  148.             <i class="fa fa-dashboard"></i> <span>Dashboard</span>
  149.             <span class="pull-right-container">
  150.               <i class="fa fa-angle-left pull-right"></i>
  151.             </span>
  152.           </a>
  153.           <ul class="treeview-menu">
  154.             <li><a href="../index.php"><i class="fa fa-circle-o"></i> Dashboard v1</a></li>
  155.             <li><a href="../index.php"><i class="fa fa-circle-o"></i> Dashboard v2</a></li>
  156.           </ul>
  157.         </li>
  158.           <li class="active treeview"><a href="../user.php"><i class="fa fa-book"></i> <span>User</span></a></li>
  159.       </ul>
  160.       </ul>
  161.     </section>
  162.     <!-- /.sidebar -->
  163.   </aside>
  164.  
  165.   <!-- Content Wrapper. Contains page content -->
  166.   <div class="content-wrapper">
  167.     <!-- Content Header (Page header) -->
  168.     <section class="content-header">
  169.       <h1>
  170.         User
  171.       </h1>
  172.       <ol class="breadcrumb">
  173.         <li><a href="#"><i class="fa fa-dashboard"></i> Home</a></li>
  174.         <li><a href="#">Tables</a></li>
  175.         <li class="active">Data tables</li>
  176.       </ol>
  177.     </section>
  178.  
  179.     <!-- Main content -->
  180.     <section class="content">
  181.       <div class="row">
  182.         <!-- left column -->
  183.       <form action="elemen_create.php" method="post" name="form1">
  184.         <div class="col-md-12">
  185.           <div class="box box-danger">
  186.             <div class="box-header with-border">
  187.               <h3 class="box-title">Create User</h3>
  188.             </div>
  189.             <div class="box-body">
  190.               <div class="row">
  191.                 <div class="col-xs-3">
  192.                   <label for="exampleInputPassword1">SKPD</label>
  193.                   <select class="form-control" name="skpd">
  194.                   <?php
  195.                       while($skpd = mysqli_fetch_array($resultskpd))
  196.                       {
  197.                         $id = $skpd['id_skpd'];
  198.                         $nama_skpd = $skpd['skpd'];
  199.                   ?>
  200.                       <option value="<?php echo $id?>"><?php echo $nama_skpd?></option>
  201.                   <?php
  202.                     }
  203.                   ?>
  204.                 </select>
  205.                 </div>
  206.                 <div class="col-xs-3">
  207.                   <label for="exampleInputPassword1">Jenis Kegiatan</label>
  208.                   <select class="form-control" name="jenis">
  209.                   <?php
  210.                       while($jenis = mysqli_fetch_array($resultjenis))
  211.                       {
  212.                         $id = $jenis['id_jenis'];
  213.                         $nama_jenis = $jenis['jenis'];
  214.                   ?>
  215.                       <option value="<?php echo $id?>"><?php echo $nama_jenis?></option>
  216.                   <?php
  217.                     }
  218.                   ?>
  219.                 </select>
  220.                 </div>
  221.                 <div class="col-xs-3">
  222.                   <label for="exampleInputPassword1">Elemen</label>
  223.                   <input type="text" name="elemen" class="form-control" placeholder="Masukan Kecamatan">
  224.                 </div>
  225.                 <div class="col-xs-3">
  226.                   <label for="exampleInputPassword1">Unit</label>
  227.                   <select class="form-control" name="unit">
  228.                   <?php
  229.                       while($unit = mysqli_fetch_array($resultunit))
  230.                       {
  231.                         $id = $unit['id_unit'];
  232.                         $nama_unit = $unit['unit'];
  233.                   ?>
  234.                       <option value="<?php echo $id?>"><?php echo $nama_unit?></option>
  235.                   <?php
  236.                     }
  237.                   ?>
  238.                 </select>
  239.                 </div>
  240.                 <div class="col-xs-3">
  241.                   <label for="exampleInputPassword1">Wilayah</label>
  242.                   <input type="text" name="wilayah" class="form-control" placeholder="Masukan Status">
  243.                 </div>
  244.                 <div class="col-xs-3">
  245.                   <label for="exampleInputPassword1">Gender</label>
  246.                   <input type="text" name="gender" class="form-control" placeholder="Masukan Status">
  247.                 </div>
  248.                 <div class="col-xs-3">
  249.                   <label for="exampleInputPassword1">Jadwal Kegiatan</label>
  250.                   <select class="form-control" name="jadwal">
  251.                   <?php
  252.                       while($jadwal = mysqli_fetch_array($resultjadwal))
  253.                       {
  254.                         $id = $jadwal['id_jadwal'];
  255.                         $nama_jadwal = $jadwal['jadwal'];
  256.                   ?>
  257.                       <option value="<?php echo $id?>"><?php echo $nama_jadwal?></option>
  258.                   <?php
  259.                     }
  260.                   ?>
  261.                 </select>
  262.                 </div>
  263.                 <div class="col-xs-3">
  264.                   <label for="exampleInputPassword1">Status</label>
  265.                   <input type="text" name="status" class="form-control" placeholder="Masukan Status">
  266.                 </div>
  267.               </div>
  268.             </div>
  269.             <!-- /.box-body -->
  270.             <div class="box-footer">
  271.                 <button type="submit" name="Submit" class="btn btn-primary">Submit</button>
  272.               </div>
  273.         </form>
  274.           </div>
  275.           <!-- /.box -->
  276.         </div>
  277.         <!--/.col (left) -->
  278.  
  279.       </div>
  280.       <!-- /.row -->
  281.     </section>
  282.     <!-- /.content -->
  283.   </div>
  284.   <!-- /.content-wrapper -->
  285.   <footer class="main-footer">
  286.     <div class="pull-right hidden-xs">
  287.       <b>Version</b> 2.4.0
  288.     </div>
  289.     <strong>Copyright &copy; 2014-2016 <a href="https://adminlte.io">Almsaeed Studio</a>.</strong> All rights
  290.     reserved.
  291.   </footer>
  292.  
  293.   <!-- Control Sidebar -->
  294.  
  295.   <!-- /.control-sidebar -->
  296.   <!-- Add the sidebar's background. This div must be placed
  297.        immediately after the control sidebar -->
  298.   <div class="control-sidebar-bg"></div>
  299. </div>
  300. <!-- ./wrapper -->
  301.  
  302. <!-- jQuery 3 -->
  303. <script src="../assets/bower_components/jquery/dist/jquery.min.js"></script>
  304. <!-- Bootstrap 3.3.7 -->
  305. <script src="../assets/bower_components/bootstrap/dist/js/bootstrap.min.js"></script>
  306. <!-- DataTables -->
  307. <script src="../assets/bower_components/datatables.net/js/jquery.dataTables.min.js"></script>
  308. <script src="../assets/bower_components/datatables.net-bs/js/dataTables.bootstrap.min.js"></script>
  309. <!-- SlimScroll -->
  310. <script src="../assets/bower_components/jquery-slimscroll/jquery.slimscroll.min.js"></script>
  311. <!-- FastClick -->
  312. <script src="../assets/bower_components/fastclick/lib/fastclick.js"></script>
  313. <!-- AdminLTE App -->
  314. <script src="../assets/dist/js/adminlte.min.js"></script>
  315. <!-- AdminLTE for demo purposes -->
  316. <script src="../assets/dist/js/demo.js"></script>
  317. <!-- page script -->
  318. <script>
  319.   $(function () {
  320.     $('#example1').DataTable()
  321.     $('#example2').DataTable({
  322.       'paging'      : true,
  323.       'lengthChange': false,
  324.       'searching'   : false,
  325.       'ordering'    : true,
  326.       'info'        : true,
  327.       'autoWidth'   : false
  328.     })
  329.   })
  330. </script>
  331.   <?php
  332.  
  333.   // Check If form submitted, insert form data into users table.
  334.   if(isset($_POST['Submit'])) {
  335.  
  336.  
  337.     $idjenis = $_POST['jenis'];
  338.     $elemen = $_POST['elemen'];
  339.     $idunit = $_POST['unit'];
  340.     $wilayah = $_POST['wilayah'];
  341.     $idjadwal = $_POST['jadwal'];
  342.     $gender = $_POST['gender'];
  343.     $idskpd = $_POST['skpd'];
  344.     $status = $_POST['status'];
  345.  
  346.     $resultzz = mysqli_query($mysqli, "INSERT INTO elemen (jenis, elemen, unit, wilayah, jadwal, gender, skpd, status)
  347.      VALUES('$idjenis', '$elemen', '$idunit', '$wilayah', '$idjadwal', '$gender', '$idskpd', '$status')") or die ("Error: ".mysqli_error($mysqli));
  348.  
  349.  
  350.     // Show message when user added
  351.     echo "User added successfully. <a href='../index.php'>View Users</a>";
  352. }
  353.   ?>
  354. </body>
  355. </html>
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement
Public Pastes
Advertisement
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!