cahyadsn

input presensi

Jan 10th, 2015
268
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
PHP 2.44 KB | None | 0 0
  1. <html>
  2.   <head>
  3.   </head>
  4.   <body>
  5.     <table border = "1">
  6.     <form method = "POST" action = "save_presensi.php">
  7.     <?php
  8.     date_default_timezone_set('Asia/Jakarta');
  9.     $jam=date("H:i:s");
  10.     $tanggal=date('Y-m-d');
  11.     ?>
  12.     <tr>
  13.       <td colspan='7'>Tanggal :<input type="text" name="tanggal" id="tanggal" value="<?php echo $tanggal;?>" readonly></td>
  14.     </tr>
  15.     <tr>
  16.       <th rowspan='2'>NIS</th>
  17.       <th rowspan='2'>Nama</th>
  18.       <th rowspan='2'>Kelas</th>
  19.       <th colspan='4'>Keterangan</th>
  20.     </tr>
  21.     <tr>
  22.       <th>Hadir</th>
  23.       <th>Ijin</th>
  24.       <th>Sakit</th>
  25.       <th>Alfa</th>
  26.     </tr>
  27.     <?php
  28.     include "connect.php";
  29.     $id_kelas = $_GET['id_kelas'];
  30.     $a = mysql_query("
  31.    SELECT
  32.      s.id_siswa ,s.nis, s.nama ,k.nama_kelas ,s.no_telp
  33.    FROM
  34.      tb_siswa s, tb_kelas k
  35.    WHERE
  36.      s.id_kelas = '$id_kelas'
  37.      AND k.id_kelas = s.id_kelas
  38.    ORDER
  39.      BY s.id_kelas  ");
  40.     $i=-1;
  41.     while($b = mysql_fetch_array($a)){
  42.       echo "
  43.          <tr>
  44.            <td><input type='text' name='data[".(++$i)."][nis]' value='{$b['nis']}' readonly></td>
  45.            <td><input type='text'name='data[{$i}][nama]' value='{$b['nama']}' readonly></td>
  46.            <td><input type='text'name='data[{$i}][nama_kelas]' value='{$b['nama_kelas']}' readonly></td>
  47.            <td><input type='radio' name ='data[{$i}][ket]' value = 'hadir'></td>
  48.            <td><input type='radio' name ='data[{$i}][ket]' value = 'ijin'></td>
  49.            <td><input type='radio' name ='data[{$i}][ket]' value = 'sakit'></td>
  50.            <td>
  51.           <input type='radio' name ='data[{$i}][ket]' value = 'alfa'>
  52.              <input type='hidden' name='data[{$i}][id_siswa]' value='{$b['id_siswa']}'>
  53.              <input type='hidden' name='data[{$i}][id_kelas]' value='{$id_kelas}'>
  54.            </td>
  55.          </tr>";
  56.     }
  57.     ?>
  58.     <tr>
  59.       <td><input type="submit" name = "submit" value = "Selesai"></td>
  60.     </tr>
  61.     </form>
  62.   </body>
  63. </html>
  64.  
  65. //-- save_presensi.php
  66. <?php
  67. $datas=isset($_POST['data'])?$_POST['data']:array();
  68. if(count($datas)>0){
  69.   $value=array();
  70.   foreach($datas as $data){
  71.     $value[]="('{$data['nis']}','{$data['id_kelas']}','{$_POST['tanggal']}','{$data['ket']}')";
  72.   }
  73.   $sql="INSERT INTO tb_presensi (nis,id_kelas,tanggal,ket) VALUES ".implode(',',$value);
  74.   include "connect.php";
  75.   mysql_query($sql) or die('ada kesalahan '.mysql_error());
  76. }
  77. ?>
Advertisement
Add Comment
Please, Sign In to add comment