API tools faq
paste
Advertisement
H4nk

Index.php Siswa

H4nk
Dec 5th, 2012
46
0
Never
Add comment
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
HTML 5 5.75 KB | None | 0 0
raw download clone embed print report
  1. <?php
  2. include"../conn.php";
  3. if($_POST[kembali]){
  4. ?>  <script language='javascript'>
  5.           window.location = 'index.php?page=input_pelajaran'</script>
  6.  
  7. <?
  8. if($kategori=='Produktif'){
  9.        $kkm = 7.5;}
  10.        else{
  11.                $kkm = 7.0;
  12.                }
  13. }
  14. if($_POST[simpan]){
  15. if(empty($_POST['nama_pelajaran'])){
  16. echo "<script language='javascript'>alert('isikan nama pelajaran');
  17.           window.location = 'javascript:history.back()'</script>";
  18.           }else{
  19. $nama_pelajaran=$_POST['nama_pelajaran'];
  20. $kategori=$_POST['kategori'];
  21. if($kategori=='Produktif'){
  22.         $kkm = 7.5;}
  23.         else{
  24.                 $kkm = 7.0;
  25.                 }
  26. $sql4="insert into tpelajaran values('','$nama_pelajaran','$kategori','$kkm')";
  27. $result4=mysql_query($sql4);
  28. ?>  <script language='javascript'>
  29.           window.location = 'index.php?page=input_pelajaran'</script>
  30.  
  31. <?
  32. }
  33. }
  34. if($_POST[ubah]){
  35. $nama_pelajaran=$_POST['nama_pelajaran'];
  36. $kategori=$_POST['kategori'];
  37.        mysql_query("UPDATE tpelajaran SET nama_pelajaran='{$nama_pelajaran}', kategori_pelajaran='{$kategori}' WHERE id_pelajaran='$_GET[id]'")or die(mysql_error());
  38.        echo "<script language='javascript'>
  39.           window.location = 'index.php?page=input_pelajaran'</script>";
  40. }
  41.  
  42. if($_GET[ubah]){
  43.         $sql=mysql_query("SELECT * FROM tpelajaran WHERE id_pelajaran='".$_GET[id]."'");
  44.         $res=mysql_fetch_array($sql);
  45. }
  46.  
  47. if($_GET[hapus]){
  48.         mysql_query("DELETE FROM tpelajaran WHERE id_pelajaran='".$_GET[id]."'");
  49.         echo "<script language='javascript'>
  50.           window.location = 'index.php?page=input_pelajaran'</script>";
  51. }
  52.  
  53. ?>
  54. <html>
  55. <head>
  56. <script type="text/JavaScript">
  57. <!--
  58. function MM_findObj(n, d) { //v4.01
  59.  var p,i,x;  if(!d) d=document; if((p=n.indexOf("?"))>0&&parent.frames.length) {
  60.    d=parent.frames[n.substring(p+1)].document; n=n.substring(0,p);}
  61.  if(!(x=d[n])&&d.all) x=d.all[n]; for (i=0;!x&&i<d.forms.length;i++) x=d.forms[i][n];
  62.  for(i=0;!x&&d.layers&&i<d.layers.length;i++) x=MM_findObj(n,d.layers[i].document);
  63.  if(!x && d.getElementById) x=d.getElementById(n); return x;
  64. }
  65.  
  66. function MM_validateForm() { //v4.0
  67.  var i,p,q,nm,test,num,min,max,errors='',args=MM_validateForm.arguments;
  68.  for (i=0; i<(args.length-2); i+=3) { test=args[i+2]; val=MM_findObj(args[i]);
  69.    if (val) { nm=val.name; if ((val=val.value)!="") {
  70.      if (test.indexOf('isEmail')!=-1) { p=val.indexOf('@');
  71.        if (p<1 || p==(val.length-1)) errors+='- '+nm+' must contain an e-mail address.\n';
  72.      } else if (test!='R') { num = parseFloat(val);
  73.        if (isNaN(val)) errors+='- '+nm+' must contain a number.\n';
  74.        if (test.indexOf('inRange') != -1) { p=test.indexOf(':');
  75.          min=test.substring(8,p); max=test.substring(p+1);
  76.          if (num<min || max<num) errors+='- '+nm+' must contain a number between '+min+' and '+max+'.\n';
  77.    } } } else if (test.charAt(0) == 'R') errors += '- '+nm+' is required.\n'; }
  78.  } if (errors) alert('The following error(s) occurred:\n'+errors);
  79.  document.MM_returnValue = (errors == '');
  80. }
  81. //-->
  82. </script>
  83. </head>
  84. <body>
  85. <h2><span></span>INPUT PELAJARAN</h2>
  86. <div class="main_column_section_content">
  87. <form name="form_pelajaran" method="post" action="">
  88.   <table width="311" border="0" align="center" cellpadding="0" cellspacing="0">
  89.     <tr>
  90.       <th width="113" height="34" align="left" scope="row">Nama Pelajaran </th>
  91.       <td width="198"><input name="nama_pelajaran" type="text" class="inp-form" onBlur="MM_validateForm('nama_pelajaran','','R');return document.MM_returnValue" value="<? echo $res[nama_pelajaran];?>"/></td>
  92.     </tr>
  93.     <tr>
  94.       <th height="34" align="left" scope="row">Kategori</th>
  95.       <td><label>
  96.         <select name="kategori"  class="styledselect_form_1">
  97.           <option value="Normatif" selected="selected">Normatif</option>
  98.           <option value="Adaptif" se>Adaptif</option>
  99.           <option value="Produktif">Produktif</option>  
  100.           <option value="Muatan Lokal">Muatan Lokal</option>
  101.         </select>
  102.                
  103.         <?php //input kkm ?>
  104.       </label></td>
  105.     </tr>
  106.     <tr>
  107.       <th height="46" colspan="2" align="left" scope="row"><div align="center">
  108.           <? if(!$_GET[ubah]){?>
  109.                 <input type="submit" name="simpan" value="Save">
  110.         <? }else{?>
  111.         <input type="submit" name="ubah" id="ubah" value="  Ubah  ">
  112.         <? }?>
  113.          <input type="submit" value="Kembali"  name="kembali">
  114.       </div></th>
  115.        
  116.     </tr>
  117.   </table>
  118.   <p>&nbsp;</p>
  119.   <table width="550" border="1" align="center">
  120.     <tr>
  121.       <td width="31"><div align="center">No</div></td>
  122.       <td width="223"><div align="center">Nama Pelajaran </div></td>
  123.       <td width="120"><div align="center">Kategori</div></td>
  124.       <td width="67"><div align="center">KKM</div></td>
  125.       <td colspan="2"><div align="center">Aksi</div></td>
  126.     </tr>
  127.          <?php
  128.  
  129.  $sql4 = "SELECT * FROM tpelajaran ORDER BY nama_pelajaran";
  130.  $qry = mysql_query($sql4);
  131.  while ($data = mysql_fetch_array($qry))
  132.  {
  133.        $no++;
  134.  ?>
  135.     <tr>
  136.       <td><div align="center"><strong><?php echo $no;?></strong></div></td>
  137.       <td><div align="left"><strong><?php echo $data['nama_pelajaran']; ?></strong></div></td>
  138.       <td><div align="left"><strong><?php echo $data['kategori_pelajaran']; ?></strong></div></td>
  139.       <td><div align="center"><strong><?php echo $data['kkm']; ?></strong></div></td>
  140.       <td width="67"><div align="center"><a href="?page=input_pelajaran&amp;ubah=?&amp;id=<?php echo $data['id_pelajaran']; ?>">Edit</a></div></td>
  141.       <td width="78"><div align="center"><a href="?page=input_pelajaran&amp;hapus=?&amp;id=<?php echo $data['id_pelajaran']; ?>">Hapus</a></div></td>
  142.     </tr>
  143.                  <?php
  144.  }
  145.  ?>
  146.     <tr>
  147.       <td colspan="6">&nbsp;</td>
  148.     </tr>
  149.   </table>
  150.   <p>&nbsp;</p>
  151.   <p>&nbsp;</p>
  152. </form>
  153. </div>
  154. </body>
  155. </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!