Advertisement
Guest User

Untitled

a guest
Feb 24th, 2019
235
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
PHP 1.83 KB | None | 0 0
  1.  
  2. --getData.php--
  3. <?php
  4. $servername = "localhost";
  5. $username = "root";
  6. $password = "";
  7. $dbname = "tugas";
  8. // Create connection
  9. $conn = mysqli_connect($servername, $username, $password, $dbname);
  10. $query = mysqli_query($conn,"SELECT * FROM tb_barang AS A LEFT JOIN tb_category AS B ON A.category=B.id");
  11. $rows = array();
  12. while($r = mysqli_fetch_assoc($query)) {
  13.     $rows[] = $r;
  14. }
  15. print json_encode($rows);
  16.  
  17. --updateData.php--
  18. <?php
  19. $servername = "localhost";
  20. $username = "root";
  21. $password = "";
  22. $dbname = "tugas";
  23. $id = $_GET['id'];
  24. $nama = $_GET['nama'];
  25. $harga = $_GET['harga'];
  26. // Create connection
  27. $conn = mysqli_connect($servername, $username, $password, $dbname);
  28. $query="UPDATE tb_barang SET nama = '$nama',harga='$harga' WHERE id='$id'";
  29. if($query = mysqli_query($conn,$query)){
  30.     echo("{\"sukses\":true}");
  31. }else{
  32.     echo("{\"sukses\":false}");
  33. }
  34.  
  35. --deleteData.php--
  36. <?php
  37. $servername = "localhost";
  38. $username = "root";
  39. $password = "";
  40. $dbname = "tugas";
  41. $id = $_GET['id'];
  42. // Create connection
  43. $conn = mysqli_connect($servername, $username, $password, $dbname);
  44. $query="DELETE FROM tb_barang where id='$id'";
  45. if($query = mysqli_query($conn,$query)){
  46.     echo("{\"sukses\":true}");
  47. }else{
  48.     echo("{\"sukses\":false}");
  49. }
  50.  
  51. --login.php--
  52. <?php
  53. if(!empty($_GET['username']) and !empty($_GET['password']) ){
  54.     $servername = "localhost";
  55.     $username = "root";
  56.     $password = "";
  57.     $dbname = "tugas";
  58.     $user = $_GET['username'];
  59.     $pass = $_GET['password'];
  60.     // Create connection
  61.     $conn = mysqli_connect($servername, $username, $password, $dbname);
  62.     $query = mysqli_query($conn,"SELECT * FROM `tb_user` WHERE username = '$user' AND username = '$pass'");
  63.     if(mysqli_num_rows($query)>0){
  64.         echo("{\"sukses\":true}");
  65.     }else{
  66.         echo("{\"sukses\":false}");
  67.     }
  68. }
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement