Advertisement
Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- <?php
- $kodebarang = 'xx.xxx.xxx';
- $koneksi = mysqli_connect('localhost','xxxx','xxxx','xxxx');
- if (!$koneksi) {
- echo "Gagal Terhubung ke Database. " . PHP_EOL;
- echo "Debugging errno : " . mysqli_connect_errno() . PHP_EOL;
- echo "Debugging error : " . mysqli_connect_error() . PHP_EOL;
- }
- /**
- echo "Berhasil Terkoneksi ke Database." . PHP_EOL;
- echo "<br>";
- echo "Informasi Server : " . mysqli_get_host_info($koneksi) . PHP_EOL;
- echo "<br>";
- */
- $cariData = $koneksi->prepare("SELECT komputer.hostname,komputer.ipaddress,komputer.macaddress FROM komputer WHERE komputer.kodebarang=?");
- $cariData->bind_param("s",$kodebarang);
- $cariData->execute();
- $hasilPencarian = $cariData->get_result();
- $arrayJSON = array();
- while($barisData = $hasilPencarian->fetch_array(MYSQLI_ASSOC)) {
- $arrayJSON[] = $barisData;
- }
- // echo json_encode($arrayJSON);
- echo json_encode($arrayJSON);
- $cariData->close();
- $koneksi->close();
- ?>
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement