| Server IP : 210.245.233.93 / Your IP : 216.73.216.226 Web Server : Apache/2.2.15 (CentOS) System : Linux webserver2.onesolution.com.hk 2.6.32-754.35.1.el6.x86_64 #1 SMP Sat Nov 7 12:42:14 UTC 2020 x86_64 User : apache ( 48) PHP Version : 5.3.3 Disable Function : exec, shell_exec, system, passthru, popen, proc_open, pcntl_exec MySQL : ON | cURL : ON | WGET : ON | Perl : ON | Python : ON | Sudo : ON | Pkexec : ON Directory : /var/www/onesolution.com.hk/onesupport/contract/ |
Upload File : |
<?php
require_once(__DIR__ . '/../checkuser.php');
if (isPost() && isset($_POST['contract_id'], $_POST['status'])) {
extract($_POST);
$sql = "UPDATE sup_contract set status = '".(int)$_POST['status']."' WHERE contract_id = ?";
$parameters = array((int)$_POST['contract_id']);
if (!($sth = $dbh->prepare($sql))) {
throw new Exception("sql prepare statement failure: $sql");
}
$sth->setFetchMode(PDO::FETCH_ASSOC);
if (!$sth->execute($parameters)) {
throw new Exception("sql execute statement failure: $sql");
}
$statusOptions = Contract::statusOptions();
$data = array(
'id' => $_POST['contract_id'],
'message' => 'Changed status to ' . $statusOptions[$_POST['status']] . '.',
);
redirectAndExit('modifyform.php?'.http_build_query($data));
}
?>