Advertisement
rizkyhap

Untitled

Sep 15th, 2017
134
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
PHP 3.87 KB | None | 0 0
  1. <?php
  2.   include_once 'kepala.php';
  3. ?>
  4. <!DOCTYPE html>
  5. <html>
  6. <head>
  7.   <title>Add Nilai</title>
  8.   <link href="css/bootstrap.min.css" rel="stylesheet">
  9.     <link href="css/bootstrap.min.css" rel="stylesheet">
  10.   <link href="css/bootstrap-datetimepicker.css" rel="stylesheet">
  11.   <link href="css/bootstrap.min.css" rel="stylesheet" media="screen">
  12.   <link href="css/bootstrap-datetimepicker.min.css" rel="stylesheet" media="screen">
  13. </head>
  14. </head>
  15. <body>
  16.   <div class="row">
  17.     <div class="col-xs-12 col-sm-6 col-md-6">
  18.       <div class="well">
  19.         <div class="page-header">
  20.           <h3 style="text-align: center;">Add Bobot TS Wisma Antara</h3>
  21.         </div>
  22.    
  23.           <?php
  24.           if(isset($_POST['simpan_ts_detil'])){
  25.             include "includes/koneksi.php";
  26.             $id_sm = $_POST["tswisma"];
  27.             $id_pekerjaan = $_POST["pekerjaan"];
  28.             $nilai = $_POST["nilai"];
  29.  
  30.             $sql = "INSERT INTO nilai (id_sm, id_pekerjaan, nilai) VALUES ('$id_sm', '$id_pekerjaan', $nilai')";
  31.  
  32.             if (mysqli_query($koneksi, $sql)) {
  33.               ?>
  34.               <div class="alert alert-success alert-dismissible" role="alert">
  35.                 <button type="button" class="close" data-dismiss="alert" aria-label="Close"><span aria-hidden="true">&times;</span></button>
  36.                 <strong>Berhasil Tambah Data!</strong> Tambah lagi atau <a href="nilai.php">lihat semua data</a>.
  37.               </div>
  38.               <?php
  39.             } else {
  40.               echo "Data tidak disimpan";
  41.             }
  42.           }
  43.           ?>
  44.               <form id="frmdata">
  45.            <?php
  46.           include "includes/koneksi.php";
  47.           $sql = "SELECT * FROM tswisma";
  48.           if (!$result = mysqli_query($koneksi, $sql)) {
  49.            die('Error: '.mysqli_error($koneksi));
  50.          } else{
  51.           if (mysqli_num_rows($result) > 0) {
  52.             ?>
  53.             <div class="form-group">
  54.               <label for="ss">Leased Line</label>
  55.               <select id="tswisma" class="form-control" name="tswisma">
  56.                <option value="">- Pilih Leased Line -</option>
  57.                <?php   while($row = mysqli_fetch_assoc($result)) {?>
  58.                <option value=<?php echo $row['id_sm']; ?>><?php echo $row['nm_sm']; ?></option>
  59.                <?php
  60.              }
  61.            }
  62.          }
  63.          ?>
  64.        </select>
  65.      </div>
  66.             <div class="form-group">
  67.               <label for="ss">Detail Pekerjaan</label>
  68.               <select id="dataset" class="form-control" name="pekerjaan">
  69.                <option value="">- Data Siswa -</option>
  70.        </select>
  71.      </div>
  72.           <button type="submit" class="btn btn-primary" name="simpan_ts_detil">Simpan</button>
  73.           <button type="button" onclick="location.href='nilai.php'" class="btn btn-success">Kembali</button>
  74.         </form>
  75.  
  76.       </div>
  77.     </div>
  78.     <div class="col-xs-12 col-sm-3 col-md-3">
  79.       <?php include_once 'sidebar.php'; ?>
  80.     </div>
  81.     <div class="navbar navbar-default navbar-fixed-bottom footer-bottom">
  82.      <div class="container text-center">
  83.       <p class="text-center">&copy; Sistem Database Online Leased Line</a></p>
  84.     </div>
  85.  
  86.  
  87. <script src="https://ajax.googleapis.com/ajax/libs/jquery/1.11.3/jquery.min.js"></script>
  88. <script src="js/bootstrap.min.js"></script>
  89. <script src="js/bootstrap-datetimepicker.js" charset="UTF-8"></script>
  90. <script src="js/locales/bootstrap-datetimepicker.id.js"></script>
  91.  
  92. <script type="text/javascript">
  93. $(function(){
  94.    $('#tswisma').change(function(){
  95.       $('#dataset').after('<span class="loading">Tunggu..data Kerja Sedang Loading..</span>');
  96.     $('#dataset').load('carisiswa.php?jk=' + $(this).val(),function(responseTxt,statusTxt,xhr)
  97.     {
  98.       if(statusTxt=="success")
  99.       $('.loading').remove();
  100.    
  101.     });
  102.     return false;
  103.    });
  104.  
  105. });
  106.  
  107. </script>
  108. </body>
  109. </html>
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement