tegarkurniawan

Contoh WHILE

Apr 2nd, 2014
125
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 3.38 KB | None | 0 0
  1. <?php session_start();
  2. if (session_is_registered('id'))
  3. {
  4. include "include/conn.php";
  5. $nis = $_REQUEST['NIS'];
  6. $id_nilai = $_REQUEST['id_nilai'];
  7. $user = $_SESSION[id];
  8. $ok=$_POST['ok'];
  9. if(isset($_POST['kirim'])){
  10. $nilai=$_POST[nilai];
  11. $id_pel=$_POST[id_mapel];
  12. $NIS=$_POST[NIS];
  13. $gntNama=$_POST[nama];
  14. $gntmapel=$_POST[mapel];
  15.  
  16.  
  17. if ($ok) {
  18. $sql=mysql_query("UPDATE nilai SET NIS='$NIS',nilai='$nilai' WHERE id_nilai='$id_nilai'");
  19. echo "<script> document.location.href='home.php?page=6'; </script>";
  20. }else{
  21. $sql=mysql_query("UPDATE nilai SET id_mapel='$gntmapel', nilai='$nilai', NIS='$gntNama' WHERE id_nilai='$id_nilai'");
  22. echo "<script> document.location.href='home.php?page=6'; </script>";
  23. }
  24.  
  25.  
  26. }elseif(isset($_POST['batal'])){
  27. echo "<script> document.location.href='home.php?page=6'; </script>";
  28. }
  29.  
  30. $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'");
  31. $querytampil = mysql_fetch_array($query);
  32. ?>
  33. <form method="POST" action="">
  34. <table width="100%" border="2" cellpadding="0" cellspacing="0" bordercolor="#99CC99" align="center">
  35. <tr>
  36. <td><label>NIS</label></td>
  37. <td>
  38. <input type="text" name="NIS" value="<?php echo $querytampil['NIS']; ?>" style="border:none;background:none;"></input>
  39. </td>
  40. </tr>
  41. <tr>
  42. <td><label>Nama</label></td>
  43. <td>
  44. <? $nama=mysql_query("select daftar.Nama FROM daftar,nilai where nilai.NIS=daftar.NIS and id_nilai='$id_nilai'");
  45. while ($row=mysql_fetch_array($nama)) {
  46. echo "<font style='font-size:9pt;'>".$row['Nama']."</font>";
  47. }?>
  48. </td>
  49. </tr>
  50. <tr>
  51. <td><label>Mata Pelajaran</label></td>
  52. <td>
  53. <? $pelajaran=mysql_query("select pelajaran.nama_pel from pelajaran,nilai where nilai.id_mapel=pelajaran.id_mapel and id_nilai='$id_nilai'");
  54. while ($row=mysql_fetch_array($pelajaran)) {
  55. echo "<font style='font-size:9pt;'>".$row['nama_pel']."</font>";
  56. }?>
  57. </td>
  58. </tr>
  59. <tr>
  60. <td><label>Nilai</label></td>
  61. <td>
  62. <input type="text" name="nilai" value="<?php echo $querytampil['nilai']; ?>" style="width:10%;"></input>
  63. </td>
  64. </tr>
  65. <tr>
  66. <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>
  67. </tr>
  68.  
  69. <tr>
  70. <td colspan="4"><label style="color:red;">*Jika ingin Ganti Pilih :</label></td>
  71. </tr>
  72.  
  73. <tr>
  74. <td colspan="4">
  75. Nama
  76. <select name="nama" style="width:30%;">
  77. <?php
  78. $sqlDaftar="SELECT NIS,Nama FROM daftar where id='$user' GROUP BY NIS";
  79. $sqlDaftar=mysql_query($sqlDaftar);
  80. while($DataDaftar=mysql_fetch_array($sqlDaftar)){
  81. echo"<option value=\"$DataDaftar[0]\">[$DataDaftar[0]]-$DataDaftar[1]</option>";
  82. }
  83. ?>
  84. </select>
  85. Mata Pelajaran
  86. <select name="mapel" style="width:20%;">
  87. <?php
  88. $sqlMapel="SELECT id_mapel,nama_pel FROM pelajaran GROUP BY id_mapel";
  89. $sqlMapel=mysql_query($sqlMapel);
  90. while($DataMapel=mysql_fetch_array($sqlMapel)){
  91. echo"<option value=\"$DataMapel[0]\">[$DataMapel[0]]-$DataMapel[1]</option>";
  92. }
  93. ?>
  94. </select>
  95. </td>
  96. </tr>
  97.  
  98. <tr>
  99. <td colspan="2" align="center">
  100. <input type="submit" name="kirim" value="Simpan"></input>
  101. <input type="submit" name="batal" value="Batal"></input>
  102. </td>
  103. </tr>
  104. </table>
  105. </form>
  106. <?php
  107. }
  108. ?>
Advertisement
Add Comment
Please, Sign In to add comment