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