Advertisement
Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- $koneksi = mysqli_connect("localhost","root","","bpjs")
- or die("Error ".mysqli_error($koneksi));
- //Mengambil data pada table dari database MySQL
- $sql = "select * from tb_kamar where kodekelas='ISO'";
- $result = mysqli_query($koneksi, $sql)
- or die("Error in Selecting " . mysqli_error($koneksi));
- //Membuat array
- $item = array();
- $i=0;
- while($row =mysqli_fetch_assoc($result))
- {
- //Menampilkan konversi data pada tabel identitas ke format JSON
- $myvars="";
- $item[$i] = array(
- 'kodekelas'=>$row['kodekelas'],
- 'koderuang'=>$row['koderuang'],
- 'namaruang'=>$row['namaruang'],
- 'kapasitas'=>$row['kapasitas'],
- 'tersedia'=>$row['tersedia'],
- 'tersediapria'=>$row['tersediapria'],
- 'tersediawanita'=>$row['tersediawanita'],
- 'tersediapriawanita'=>$row['tersediapriawanita']
- );
- $i++;
- }
- $myvars = json_encode($item);
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement