function query_statements($q) { extract($q); list($resource_ids, $rule_values) = query_result($q); for ($i = 0; $i < count($resource_ids); $i++) { $items[] = array('item_id' => $resource_ids[$i], 'notes' => get_notes($resource_ids[$i], $db)); } return $items; }
function get_nama_status_lpj($stat_kd) { $data_stat = query_result("SELECT STATUS_NAMA FROM TB_M_STATUS_LPJ WHERE STATUS_KODE='{$stat_kd}'", 'select', false); return $data_stat['STATUS_NAMA']; }
<?php if (!isset($_GET['lpj_id'])) { header("location:index.php"); } $lpj_id = $_GET['lpj_id']; include "functions.php"; $data_lpj = query_result("SELECT LPJ_ARSIP FROM TB_DATA_LPJ WHERE LPJ_ID='{$lpj_id}'", 'select', false); $arsip_lpj = $data_lpj['LPJ_ARSIP']; header("location:arsip/" . $arsip_lpj);
<?php if (!isset($_GET['lpj_id'])) { header("location:index.php"); } $lpj_id = $_GET['lpj_id']; define("UPLOAD_DIR", "arsip/"); include "functions.php"; $name = query_result("SELECT LPJ_ARSIP FROM TB_DATA_LPJ WHERE LPJ_ID='{$lpj_id}'", 'select', false); $name = $name['LPJ_ARSIP']; if (file_exists(UPLOAD_DIR . $name)) { $delete = unlink(UPLOAD_DIR . $name); if ($delete == true) { $query = query_result("UPDATE TB_DATA_LPJ SET LPJ_ARSIP=NULL WHERE LPJ_ID='{$lpj_id}'", 'non_select', false); if ($query) { header("location:index.php?page=cari-arsip-lpj&lpj_id=" . $lpj_id . "&delete_arsip=success"); } else { header("location:index.php?page=cari-arsip-lpj&lpj_id=" . $lpj_id . "&delete_arsip=error"); } } else { header("location:index.php?page=cari-arsip-lpj&lpj_id=" . $lpj_id . "&delete_arsip=error"); } } else { header("location:index.php?page=cari-arsip-lpj&lpj_id=" . $lpj_id . "&delete_arsip=error"); }
<td colspan="3"> <table class=topmenu border=0> <tr> <td width=5%> </td> <td> <h1 class=title><?php echo $namepage; ?> </h1> <?php // Выводим дату начала регистрации данных и число прошедших с начала регистрации // дней - определяем дату в таблице $tbl_ip и $tbl_arch_hits $query = "SELECT UNIX_TIMESTAMP(MIN(putdate)) AS data \n FROM {$tbl_ip}"; $date_ip = query_result($query); $query = "SELECT UNIX_TIMESTAMP(MIN(putdate)) AS data \n FROM {$tbl_arch_hits}"; $date_arch = query_result($query); if (empty($date_ip) && empty($date_arch)) { $date = time(); } else { if (empty($date_ip)) { $date = $date_arch; } else { if (empty($date_ip)) { $date = $date_ip; } else { if ($date_ip < $date_arch) { $date = $date_ip; } else { $date = $date_arch; } }
<?php require "connect.php"; require "functions.php"; $username = $_SESSION['login_session']['user_id']; $data_adm = query_result("SELECT * FROM TB_USER WHERE USER_ID='{$username}'", 'select', false); ?> <div class='sub-content' id='edit-data-admin'> <div class='subtitle'> <div class='title'><h2>Form Edit Data Admin</h2></div> </div> <div class='sub-container'> <div class='cust-register'> <?php if (isset($_GET['update_data'])) { if ($_GET['update_data'] == 'error') { ?> <p class='inlinemsg err'>Gagal update data. Silakan coba lagi nanti.</p> <?php } else { if ($_GET['update_data'] == 'success') { if (isset($_GET['passwd']) && $_GET['passwd'] == 'changed') { ?> <p class='inlinemsg suc'>Data admin berhasil diupdate. Sistem akan melakukan logout otomatis dalam 2 detik...</p> <meta http-equiv='refresh' content='2; url=logout.php'> <?php } else { ?> <p class='inlinemsg suc'>Data berhasil diupdate.</p>