Exemple #1
0
<?php

checkauthentication();
$table = "tb_unitkerja";
$field = array("id", "kdunit", "nmunit", "sktunit", "kdsatker");
$err = false;
$p = $_GET['p'];
extract($_POST);
$xusername_sess = $_SESSION['xusername'];
$kddept = setup_kddept_keu();
$kdunitx = setup_kdunit_keu();
$xmenu_p = xmenu_id($p);
$p_next = $xmenu_p->parent;
if (isset($form)) {
    if ($err != true) {
        $lastmodified = now();
        $modifiedby = $xusername_sess;
        $id = $q;
        foreach ($field as $k => $val) {
            $value[$k] = ${$val};
        }
        if ($q == "") {
            //ADD NEW
            $sql = sql_insert($table, $field, $value);
            $rs = mysql_query($sql);
            if ($rs) {
                update_log($sql, $table, 1);
                $_SESSION['errmsg'] = "Input data berhasil!";
            } else {
                update_log($sql, $table, 0);
                $_SESSION['errmsg'] = "Input data gagal!";
Exemple #2
0
<?php

checkauthentication();
$p = $_GET['p'];
$cari = $_GET['cari'];
$table = "t_satker";
$field = array("ID", "KDSATKER", "NMSATKER", "KDDEPT", "KDUNIT");
$ed_link = "index.php?p=" . get_edit_link($p);
$del_link = "index.php?p=" . get_delete_link($p);
$kddept = setup_kddept_keu($kode);
$kdunit = setup_kdunit_keu($kode);
#Halaman yang akan ditampilkan untuk pertengahan?
$adjacents = 3;
$query = "SELECT COUNT(*) as num FROM {$table} WHERE KDDEPT = '{$kddept}' AND KDUNIT = '{$kdunit}' AND (NMSATKER LIKE '%{$cari}%' OR KDSATKER LIKE '%{$cari}%' OR KDDEPT LIKE '%{$cari}%' OR KDUNIT LIKE '%{$cari}%') ";
$total_pages = mysql_fetch_array(mysql_query($query));
$total_pages = $total_pages[num];
#variabel query
$targetpage = "index.php?p={$p}&cari={$cari}";
#nama file  (nama file ini)
$limit = 20;
#berapa yang akan ditampilkan setiap halaman
$pagess = $_GET['pagess'];
if ($pagess) {
    $start = ($pagess - 1) * $limit;
} else {
    $start = 0;
}
#halaman awal
$oList = mysql_query("SELECT * FROM {$table} WHERE KDDEPT = '{$kddept}' AND KDUNIT = '{$kdunit}' AND ( NMSATKER LIKE '%{$cari}%' OR KDSATKER LIKE '%{$cari}%' OR KDDEPT LIKE '%{$cari}%' ) ORDER BY KDSATKER LIMIT {$start}, {$limit}");
$count = mysql_num_rows($oList);
while ($List = mysql_fetch_object($oList)) {