Tws

[farhan695]

Pertemuan 14

[farhan695]

Pertemuan 14

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; } ?>