function deleteUser($a)
{
$db = testdb_connect();
$stmt = $db->prepare("DELETE FROM user_permit WHERE no_id=:field1");
$stmt->execute(array(':field1' => $a));
$fetch_array = $stmt->fetchAll(PDO::FETCH_ASSOC);
return $fetch_array;
}
function getDokumen($a, $b)
{
$db = testdb_connect();
$stmt = $db->prepare("SELECT * FROM dokumen WHERE nip_peg=:field1 AND jenis_dokumen=:field2");
$stmt->execute(array(':field1' => $a, ':field2' => $b));
$fetch_array = $stmt->fetchAll(PDO::FETCH_ASSOC);
return $fetch_array;
}
<?php
$user = "";
$pass = "";
$hostname = "";
function testdb_connect($hostname, $user, $pass)
{
$db = new PDO("mysql:host={$hostname};dbname=pseudo", $user, $pass);
return $db;
}
try {
$db = testdb_connect($hostname, $user, $pass);
} catch (PDOException $e) {
}
function getKeluargaPegawai($a)
{
$db = testdb_connect();
$stmt = $db->prepare("SELECT * FROM keluarga_pegawai WHERE nip_peg=:field1");
$stmt->execute(array(':field1' => $a));
$fetch_array = $stmt->fetchAll(PDO::FETCH_ASSOC);
return $fetch_array;
}
