Advertisement
riyanris

Backend

Apr 1st, 2019
625
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
PHP 0.85 KB | None | 0 0
  1. <?php
  2. $koneksi = mysqli_connect("localhost","root","","hutang");
  3.  
  4. if ($_GET['k'] == 'insert') {
  5.     $nama = $_POST['nama'];
  6.     $umur = $_POST['umur'];
  7.     $query = mysqli_query($koneksi,"INSERT INTO `test`(`nama`, `umur`) VALUES ('$nama','$umur')");
  8.     echo json_encode($query);
  9. }elseif($_GET['k'] == 'show') {
  10.     $query = mysqli_query($koneksi,"SELECT * FROM `test`");
  11.     $data = mysqli_fetch_all($query,MYSQLI_ASSOC);
  12.     echo json_encode($data);
  13. }elseif ($_GET['k'] == 'update') {
  14.     $nama = $_POST['nama'];
  15.     $umur = $_POST['umur'];
  16.     $kode = $_POST['kode'];
  17.     $query = mysqli_query($koneksi,"UPDATE `test` SET `nama`='$nama',`umur`='$umur' WHERE `nama`='$kode'");
  18.     echo json_encode($query);
  19. }else if($_GET['k'] == 'delete') {
  20.     $kode = $_POST['kode'];
  21.     $query = mysqli_query($koneksi,"DELETE FROM `test` WHERE `nama` = '$kode'");
  22.     echo json_encode($query);
  23. }
  24.  
  25. ?>
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement