Advertisement
Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- <?php
- $koneksi = mysqli_connect("localhost","root","","hutang");
- if ($_GET['k'] == 'insert') {
- $nama = $_POST['nama'];
- $umur = $_POST['umur'];
- $query = mysqli_query($koneksi,"INSERT INTO `test`(`nama`, `umur`) VALUES ('$nama','$umur')");
- echo json_encode($query);
- }elseif($_GET['k'] == 'show') {
- $query = mysqli_query($koneksi,"SELECT * FROM `test`");
- $data = mysqli_fetch_all($query,MYSQLI_ASSOC);
- echo json_encode($data);
- }elseif ($_GET['k'] == 'update') {
- $nama = $_POST['nama'];
- $umur = $_POST['umur'];
- $kode = $_POST['kode'];
- $query = mysqli_query($koneksi,"UPDATE `test` SET `nama`='$nama',`umur`='$umur' WHERE `nama`='$kode'");
- echo json_encode($query);
- }else if($_GET['k'] == 'delete') {
- $kode = $_POST['kode'];
- $query = mysqli_query($koneksi,"DELETE FROM `test` WHERE `nama` = '$kode'");
- echo json_encode($query);
- }
- ?>
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement