public function updateAction($params) { $db = new connection(); $pk = $params['pk']; if ($pk != "") { $columns_values = array("exam_type" => $params['exam_type'], "description" => trim($params['description']), "modified_at" => $db->now_time, "modified_by" => $_SESSION['sys_user_id'], "flag" => 0); $msg = ""; if ($db->alreadyExists("Select * from exam_type where flag=0 and exam_type='" . $params['exam_type'] . "' and exam_type_id!=" . $pk)) { $res = $db->updateData($this->table_name, $columns_values, " exam_type_id={$pk}"); if ($res == true) { $msg = "Success"; } else { $msg = "Failed"; } } else { $msg = "Data Already Exists"; } } else { $msg = "System Error"; } return $msg; }
public function updateAction($params) { $db = new connection(); $pk = $params['pk']; if ($pk != "") { $columns_values = array("sys_role_id" => $pk, "sys_role" => $params['sys_role'], "created_at" => $db->now_time, "flag" => 0); $msg = ""; if ($db->alreadyExists("Select * from system_role where sys_role='" . $params['sys_role'] . "' and sys_role_id!=" . $pk)) { $res = $db->updateData($this->table_name, $columns_values, " sys_role_id={$pk}"); if ($res == true) { $msg = "Success"; } else { $msg = "Failed"; } } else { $msg = "Data Already Exists"; } } else { $msg = "System Error"; } return $msg; }
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; }