ahmfarisi

retrieve.php

May 12th, 2022
66
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
PHP 0.74 KB | None | 0 0
  1. <?php
  2. require("koneksi.php");
  3. $perintah = "SELECT * FROM tblrumahsakitpalembang";
  4. $eksekusi = mysqli_query($konek, $perintah);
  5.  
  6. $cek = mysqli_affected_rows($konek);
  7.  
  8. if($cek > 0){
  9.     $response["kode"] = 1;
  10.     $response["pesan"] = "Data Tersedia";
  11.     $response["data"] = array();
  12.    
  13.     while($ambil = mysqli_fetch_object($eksekusi)){
  14.         $temp["id"] = $ambil->id;
  15.         $temp["nama"] = $ambil->nama;
  16.         $temp["alamat"] = $ambil->alamat;
  17.         $temp["telepon"] = $ambil->telepon;
  18.         $temp["foto"] = $ambil->foto;
  19.        
  20.         array_push($response["data"], $temp);
  21.     }
  22. }
  23. else{
  24.     $response["kode"] = 0;
  25.     $response["pesan"] = "Data Tidak Tersedia";
  26. }
  27.  
  28. echo json_encode($response);
  29. mysqli_close($konek);
Advertisement
Add Comment
Please, Sign In to add comment