Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- <?php session_start();
- if (session_is_registered('id'))
- {
- include "include/conn.php";
- $nis = $_REQUEST['NIS'];
- $id_nilai = $_REQUEST['id_nilai'];
- $user = $_SESSION[id];
- $ok=$_POST['ok'];
- if(isset($_POST['kirim'])){
- $nilai=$_POST[nilai];
- $id_pel=$_POST[id_mapel];
- $NIS=$_POST[NIS];
- $gntNama=$_POST[nama];
- $gntmapel=$_POST[mapel];
- if ($ok) {
- $sql=mysql_query("UPDATE nilai SET NIS='$NIS',nilai='$nilai' WHERE id_nilai='$id_nilai'");
- echo "<script> document.location.href='home.php?page=6'; </script>";
- }else{
- $sql=mysql_query("UPDATE nilai SET id_mapel='$gntmapel', nilai='$nilai', NIS='$gntNama' WHERE id_nilai='$id_nilai'");
- echo "<script> document.location.href='home.php?page=6'; </script>";
- }
- }elseif(isset($_POST['batal'])){
- echo "<script> document.location.href='home.php?page=6'; </script>";
- }
- $query = mysql_query("select nilai.id_mapel, nilai.NIS,nilai.nilai,pelajaran.nama_pel from nilai,pelajaran,daftar WHERE nilai.id_mapel=pelajaran.id_mapel and id_nilai='$id_nilai'");
- $querytampil = mysql_fetch_array($query);
- ?>
- <form method="POST" action="">
- <table width="100%" border="2" cellpadding="0" cellspacing="0" bordercolor="#99CC99" align="center">
- <tr>
- <td><label>NIS</label></td>
- <td>
- <input type="text" name="NIS" value="<?php echo $querytampil['NIS']; ?>" style="border:none;background:none;"></input>
- </td>
- </tr>
- <tr>
- <td><label>Nama</label></td>
- <td>
- <? $nama=mysql_query("select daftar.Nama FROM daftar,nilai where nilai.NIS=daftar.NIS and id_nilai='$id_nilai'");
- while ($row=mysql_fetch_array($nama)) {
- echo "<font style='font-size:9pt;'>".$row['Nama']."</font>";
- }?>
- </td>
- </tr>
- <tr>
- <td><label>Mata Pelajaran</label></td>
- <td>
- <? $pelajaran=mysql_query("select pelajaran.nama_pel from pelajaran,nilai where nilai.id_mapel=pelajaran.id_mapel and id_nilai='$id_nilai'");
- while ($row=mysql_fetch_array($pelajaran)) {
- echo "<font style='font-size:9pt;'>".$row['nama_pel']."</font>";
- }?>
- </td>
- </tr>
- <tr>
- <td><label>Nilai</label></td>
- <td>
- <input type="text" name="nilai" value="<?php echo $querytampil['nilai']; ?>" style="width:10%;"></input>
- </td>
- </tr>
- <tr>
- <td colspan="3"><label style="color:red;">*Jika tidak ingin mengganti NAMA dan MATA PELAJARAN ceklist tanda ini </label><input type="checkbox" name="ok" /></td>
- </tr>
- <tr>
- <td colspan="4"><label style="color:red;">*Jika ingin Ganti Pilih :</label></td>
- </tr>
- <tr>
- <td colspan="4">
- Nama
- <select name="nama" style="width:30%;">
- <?php
- $sqlDaftar="SELECT NIS,Nama FROM daftar where id='$user' GROUP BY NIS";
- $sqlDaftar=mysql_query($sqlDaftar);
- while($DataDaftar=mysql_fetch_array($sqlDaftar)){
- echo"<option value=\"$DataDaftar[0]\">[$DataDaftar[0]]-$DataDaftar[1]</option>";
- }
- ?>
- </select>
- Mata Pelajaran
- <select name="mapel" style="width:20%;">
- <?php
- $sqlMapel="SELECT id_mapel,nama_pel FROM pelajaran GROUP BY id_mapel";
- $sqlMapel=mysql_query($sqlMapel);
- while($DataMapel=mysql_fetch_array($sqlMapel)){
- echo"<option value=\"$DataMapel[0]\">[$DataMapel[0]]-$DataMapel[1]</option>";
- }
- ?>
- </select>
- </td>
- </tr>
- <tr>
- <td colspan="2" align="center">
- <input type="submit" name="kirim" value="Simpan"></input>
- <input type="submit" name="batal" value="Batal"></input>
- </td>
- </tr>
- </table>
- </form>
- <?php
- }
- ?>
Advertisement
Add Comment
Please, Sign In to add comment