| 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/(Del)pathways.org.hk/MIS_bk/staff_position/ |
Upload File : |
<?php
require_once(__DIR__ . '/../checkuser.php');
$ids = $_POST['staff_position']['selected'];
if (!empty($ids) && is_array($ids)) {
$in_values = array();
foreach ($ids as $id) {
$in_values[] = '?';
}
$in = implode(', ', $in_values);
$sql = "UPDATE `mis_staff_position` SET `lastupby` = ?, `lastupdate` = ?, `deleted` = ? WHERE `id` IN ($in)";
$parameters = array_merge(array($_SESSION['webadmin']['id'], date('Y-m-d H:i:s'), 1), $ids);
$sth = Db\Util::execute($dbh, $sql, $parameters);
$data = array(
'message' => 'Deleted',
);
redirectAndExit(Util::link(__DIR__ . '/index.php') . '?' . http_build_query($data));
}