1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
|
<?php $page_settings = array( 'formid' => 'Supplier', // for permission 'section' => 'Supplier', // parent/page title 'subsection' => 'Supplier', // page title 'domain' => 'supplier', // table/model name 'access' => 'GNu', // for permission ); require_once "check_login.php";
$nowdate = date("Y-m-d H:i:s"); $id = (int)$_GET["id"];
$sql = "update supplier set status=case when status = 'ACTIVE' then 'INACTIVE' else 'ACTIVE' end, lastupdate=?, lastupby=? where id=?"; $parameters = array($nowdate, $_SESSION['cmsloginid'], $id); bind_pdo($sql, $parameters);
header("Location: supplier_index.php?msg=Update Successfully");
|