function.php

<?php
$conn = mysqli_connect("localhost","root","","inventaris");

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

  }

  return $rows;
}



function tambahakun($data){
    global $conn;


$username = htmlspecialchars($data["username"]);

$pass =htmlspecialchars($data["password"]);

$nama = htmlspecialchars($data["nama_petugas"]);
$level = htmlspecialchars($data["id_level"]);


$query = "INSERT INTO petugas
         VALUES
          ('','$username','$pass','$nama','$level')

";
mysqli_query($conn,$query);


return mysqli_affected_rows($conn);

}


function tambahpegawai($data){
    global $conn;

$ipegawai= htmlspecialchars($data["id_pegawai"]);
$pegawai= htmlspecialchars($data["nama_pegawai"]);

$nip =htmlspecialchars($data["nip"]);

$alamat = htmlspecialchars($data["alamat"]);



$query = "INSERT INTO pegawai
         VALUES
          ('$ipegawai','$pegawai','$nip','$alamat',)

";
mysqli_query($conn,$query);


return mysqli_affected_rows($conn);

}













function hapusakun($id){
  global $conn;
  mysqli_query($conn,"DELETE FROM petugas WHERE id_petugas=$id");
  return mysqli_affected_rows($conn);




}
function hapuspegawai($id1){
  global $conn;
  mysqli_query($conn,"DELETE FROM pegawai WHERE id_pegawai=$id1");
  return mysqli_affected_rows($conn);




}





































 ?>