Advertisement
Mumud

Untitled

Dec 8th, 2016
75
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 0.86 KB | None | 0 0
  1. $koneksi = mysqli_connect("localhost","root","","bpjs")
  2. or die("Error ".mysqli_error($koneksi));
  3. //Mengambil data pada table dari database MySQL
  4. $sql = "select * from tb_kamar where kodekelas='ISO'";
  5. $result = mysqli_query($koneksi, $sql)
  6. or die("Error in Selecting " . mysqli_error($koneksi));
  7. //Membuat array
  8.  
  9.  
  10. $item = array();
  11. $i=0;
  12. while($row =mysqli_fetch_assoc($result))
  13. {
  14. //Menampilkan konversi data pada tabel identitas ke format JSON
  15.  
  16. $myvars="";
  17. $item[$i] = array(
  18. 'kodekelas'=>$row['kodekelas'],
  19. 'koderuang'=>$row['koderuang'],
  20. 'namaruang'=>$row['namaruang'],
  21. 'kapasitas'=>$row['kapasitas'],
  22. 'tersedia'=>$row['tersedia'],
  23. 'tersediapria'=>$row['tersediapria'],
  24. 'tersediawanita'=>$row['tersediawanita'],
  25. 'tersediapriawanita'=>$row['tersediapriawanita']
  26. );
  27. $i++;
  28. }
  29. $myvars = json_encode($item);
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement