Tws

[farhan695]

Pertemuan 14

[farhan695]

Pertemuan 14

<?php

$server = "localhost"; $username = "root"; $password = ""; $database = "tabelbiodata"; $con = mysqli_connect($server, $username, $password) or die("

Koneksi Mysqli Error : " .mysqli_connect_error()); mysqli_select_db($con, $database) or die("

Koneksi Kedatabase Error :

" . mysqli_error($con));

@$operasi = $_GET['operasi'];

switch ($operasi) {

case "view";

$query_tampil_biodata = mysqli_query($con,"SELECT * FROM isibiodata") or die (mysqli_error($con));
$data_array = array();

while($data = mysqli_fetch_assoc($query_tampil_biodata)) {
    $data_array[]=$data;
}
echo json_encode($data_array);

break;

case "insert";
@$nim = $_GET['nim'];
@$nama = $_GET['nama'];
@$alamat = $_GET['alamat'];

$query_insert_data = mysqli_query($con, "INSERT INTO isibiodata (nim, nama, alamat) VALUES('$nim','$nama','$alamat')");

if ($query_insert_data) {
    echo "Data Berhasil Disimpan";
}
else {
    echo "Maaf Insert Ke Dalam Database Error" . mysqli_error($con);
}

break;

case "get_biodata_by_id";
@$id =(int)$_GET['id'];
$query_tampil_biodata = mysqli_query($con, "SELECT * FROM isibiodata WHERE id='$id'") or die (mysqli_error($con));
$data_array = array();
$data_array = mysqli_fetch_assoc($query_tampil_biodata);
echo "[" .json_encode ($data_array) . "]";
break;

case "update";
@$nim = $_GET['nim'];
@$nama = $_GET['nama'];
@$alamat = $_GET['alamat'];
@$id = $_GET['id'];

$query_update_biodata = mysqli_query($con, "UPDATE isibiodata SET nim = '$nim', nama='$nama', alamat='$alamat' WHERE id='$id'");

If ($query_update_biodata) {
    echo " Update Data Berhasil ";
}
else {
    echo mysqli_error($con);
}
break;

case "delete":
@$id = $_GET['id'];
$query_delete_biodata = mysqli_query($con, "DELETE FROM isibiodata WHERE id='$id'");
if ($query_delete_biodata) {
    echo "Data Berhasil Dihapus";
}
else {
    echo mysqli_error($con);
}
break;

default;
break;

} ?>