PHP get_no_usulan_pmk Exemples

Exemple #1

Fichier : pmk_acc_daftar_diusulkan.php Projet : suryamanik15/sistem_2014

<?php

session_start();
include "../koneksi.php";
include "../fungsi.php";
$mod = $_GET['mode'];
$id_usulan = mysql_real_escape_string($_GET['id_usul']);
$no_usulan = get_no_usulan_pmk($id_usulan);
if ($mod == 2) {
    // status penolakan
    $catatan = $_GET['catatan'];
    $sql = "UPDATE tbl_usulan_pmk SET catatan = '{$catatan}' ,status_supervisi = '1' WHERE no_usulan = '{$no_usulan}'";
    $query = mysql_query($sql);
    if ($query) {
        header("Location:../../?mod=pmk_diusulkan_proses&code=1&id_usul=" . $id_usulan);
    }
} else {
    $sql = "UPDATE tbl_usulan_pmk SET status_supervisi = '3' WHERE no_usulan = '{$no_usulan}'";
    $query = mysql_query($sql);
    if ($query) {
        header("Location:../../?mod=pmk_diusulkan_proses&code=2&id_usul=" . $id_usulan);
    }
}

Exemple #2

Fichier : pmk_daftar_diusulkan_hapus.php Projet : suryamanik15/sistem_2014

<?php

session_start();
include "../koneksi.php";
include "../fungsi.php";
$id_usul = mysql_real_escape_string($_GET['id_usul']);
$no_usul = get_no_usulan_pmk($id_usul);
$sql = "DELETE FROM tbl_usulan_pmk WHERE no_usulan = '" . $no_usul . "'";
$hapus = mysql_query($sql);
if ($hapus) {
    $code = 1;
    header("Location:../../?mod=pmk_daftar_usulan_diusulkan&code=" . $code . "&act=del");
} else {
    $code = 2;
    header("Location:../../?mod=pmk_daftar_usulan_diusulkan&code=" . $code . "&act=del");
}