Advertisement
arijulianto

Ambil Data AJAX berdasar NIS

Mar 24th, 2014
301
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
PHP 1.25 KB | None | 0 0
  1. // tampil.php
  2. <script type="text/javascript" src="http://ajax.googleapis.com/ajax/libs/jquery/1.8.3/jquery.min.js"></script>
  3. <script>
  4. $(function){
  5. $('#nis').change(function(){
  6. $.ajax({
  7.     url: 'ambilData.php',
  8.     data:'nis='+$(this).val(),
  9.     dataType; 'json',
  10.     success: function(data){
  11.         $('#nama').val(data.nama);
  12.         $('#kelamin').val(data.kelamin);
  13.         $('#kelas').val(data.kelas);
  14.     }
  15. })
  16. })
  17. })
  18. </script>
  19. <form>
  20. <table>
  21. <tr>
  22.     <td>NIS</td>
  23.     <td><select id="nis">
  24.     <?php
  25.     include "koneksi.php";
  26.     $sql = mysql_query("SELECT NIS from tbl_siswa order by NIS");
  27.     while($nis=mysql_fetch_array($sql))
  28.         echo "<option value=\"$nis[NIS]\">$nis[NIS]</option>\n";
  29.     ?>
  30.     </select></td>
  31. </tr>
  32. <tr>
  33.     <td>Nama</td>
  34.     <td input type="text" name="nama" id="nama" /></td>
  35. </tr>
  36. <tr>
  37.     <td>Jenis Kelamin</td>
  38.     <td input type="text" name="kelamin" id="kelamin" /></td>
  39. </tr>
  40. <tr>
  41.     <td>Kelas</td>
  42.     <td input type="text" name="kelas" id="kelas" /></td>
  43. </tr>
  44. </table>
  45. </form>
  46.  
  47. // file ambilData.php
  48. <?php
  49. include "koneksi.php";
  50. $sql = mysql_query("SELECT * from tbl_siswa where NIS='$_GET[nis]'");
  51. $data = mysql_fetch_array($sql);
  52. $output = array('nama'=>$data['nama'], 'kelamin'=>$data['jenis_kelamin'], 'kelas'=>$data['kelas']);
  53. echo json_encode($output);
  54. ?>
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement