public function updateAction($params) { $db = new connection(); $pk = $params['pk']; if ($pk != "") { $columns_values = array("sys_name" => $params['sys_name'], "sys_role_id" => $params['sys_role_id'], "dob" => $db->storeDBDate($params['dob']), "email" => $params['email'], "mobile" => $params['mobile'], "address" => $params['address'], "user_name" => $params['user_name'], "modified_by" => $_SESSION['sys_user_id'], "modified_at" => $db->now_time, "flag" => 0); $msg = ""; if ($db->alreadyExists("Select * from system_user where flag=0 and user_name='" . $params['user_name'] . "' and email='" . $params['email'] . "' and sys_user_id!='{$pk}'")) { $res = $db->updateData($this->table_name, $columns_values, " sys_user_id={$pk}"); if ($res == true) { $msg = "Success"; } else { $msg = "Failed"; } } else { $msg = "Data Already Exists"; } } else { $msg = "System Error"; } return $msg; }