Advertisement
Guest User

datahadir.php

a guest
Oct 14th, 2016
88
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 1.23 KB | None | 0 0
  1. <?php
  2. include 'koneksi.php';
  3. $server = "localhost";
  4. $user = "root";
  5. $password = "";
  6. $database = "rapatpcc";
  7.  
  8. mysql_connect($server, $user, $password) or die ("Koneksi Putus");
  9. mysql_select_db($database) or die ("Database tidak bisa dibuka");
  10. if(isset($_POST['id_rapat']))
  11.  
  12. {
  13. $id_rapat = $_POST['id_rapat'];
  14. $sql = mysql_query("SELECT * FROM `kehadiran`
  15. WHERE id_rapat = $id_rapat ORDER BY `kehadiran`.`id_hadir` DESC ");
  16. $cek = mysql_num_rows($sql);
  17. $response = array();
  18. if($cek > 0){
  19. $response["hadir"] = array();
  20. while($row = mysql_fetch_array($sql)){
  21. $data = array();
  22. $data["id_hadir"] = $row["id_hadir"];
  23. $data["id_rapat"] = $row["id_rapat"];
  24. $data["nama_hadir"] = $row["nama_hadir"];
  25. $data["status_hadir"] = $row["status_hadir"];
  26. $data["ket_hadir"] = $row["ket_hadir"];
  27. array_push($response["hadir"], $data);
  28. }
  29. $response["sukses"] = true;
  30. $response["pesan"] = "Berhasil mengambil data";
  31. echo json_encode($response);
  32. } else {
  33. $response["sukses"] = false;
  34. $response["pesan"] = "Gagal mengambil data";
  35. echo json_encode($response);
  36. }}
  37. else {
  38. $response["sukses"] = false;
  39. $response["pesan"] = "Input Tidak ada";
  40. echo json_encode($response);
  41. }
  42. ?>
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement