<?php
//koneksi database
$conn = mysqli_connect("localhost","root","","dbrismanila");

function query($query) {
	global $conn;

	$result = mysqli_query($conn, $query);
	$rows = [];
	while( $row = mysqli_fetch_assoc($result) ) {
		$rows[] = $row;
	}
	return $rows;
}

function tambah($data) {
	global $conn;

	$id_petugas = htmlspecicalchars($data["id_petugas"]);
	$username = htmlspecialchars($data["username"]);
	$password = htmlspecialchars($data["password"]);
	$nama_petugas = htmlspecialchars($data["nama_petugas"]);
	$id_level = htmlspecialchars($data["id_level"]);

	$query = "INSERT INTO petugas VALUES ('$id_petugas','$username','$password','$nama_petugas','$id_level')";

	mysqli_query($conn,$query);

	return mysqli_affected_rows($conn);
}

function hapus($id) {
	global $conn;

	mysqli_query($conn,"DELETE FROM petugas WHERE id_petugas = $id");

	return  mysqli_affected_rows($conn);
}

function ubah($data) {
	global $conn;

	$id = $data["id"];
	$username = htmlspecialchars($data["username"]);
	$password = htmlspecialchars($data["password"]);
	$nama_user = htmlspecialchars($data["nama_user"]);

	$query = "UPDATE user SET
				  username = '$username',
				  password = '$password',
				  nama_user = '$nama_user'
			  WHERE id_user = $id
			  ";

	mysqli_query($conn,$query);

	return mysqli_affected_rows($conn);
}

?>