public static function update($user_id, $info) { if (!($mysqli = UsersInfoDB::connect())) { return false; } $query_sql = " UPDATE\n users_info\n SET \n user_fname = ?,\n user_lname = ?,\n user_mobile = ?,\n user_gender = ?,\n user_birthdate = ?,\n user_marital = ?,\n user_about = ?\n WHERE\n user_id = ?"; $query = $mysqli->prepare($query_sql); $query->bind_param("ssssssss", $info[Users::FNAME_KEY], $info[Users::LNAME_KEY], $info[Users::MOBILE_KEY], $info[Users::GENDER_KEY], $info[Users::BIRTHDATE_KEY], $info[Users::MARITAL_KEY], $info[Users::ABOUT_KEY], $user_id); $query->execute(); $query->close(); $mysqli->close(); return $info; }
public static function update($response, $token, $info) { if (!TokensDB::check($token)) { return putError('invalid token', Users::ERROR_AUTH_INVALID, $response); } if (count($info) < 4) { return putError('invalid request parameters', Users::ERROR_FORMAT, $response); } $info[Users::FNAME_KEY] = Validator::filterName($info, Users::FNAME_KEY); $info[Users::LNAME_KEY] = Validator::filterName($info, Users::LNAME_KEY); $info[Users::GENDER_KEY] = Validator::filterGender($info, Users::GENDER_KEY); $info[Users::BIRTHDATE_KEY] = Validator::filterDate($info, Users::BIRTHDATE_KEY); $info[Users::MOBILE_KEY] = Validator::filterMobile($info, Users::MOBILE_KEY); $info[Users::ABOUT_KEY] = Validator::filterAbout($info, Users::ABOUT_KEY); $info[Users::MARITAL_KEY] = Validator::filterMarital($info, Users::MARITAL_KEY); if (!$info[Users::FNAME_KEY]) { return putError('invalid firstname parameter', Users::ERROR_FNAME_FORMAT, $response); } else { if (!$info[Users::LNAME_KEY]) { return putError('invalid lastname parameter', Users::ERROR_LNAME_FORMAT, $response); } else { if (!$info[Users::GENDER_KEY]) { return putError('invalid gender parameter', Users::ERROR_GENDER_FORMAT, $response); } else { if (!$info[Users::BIRTHDATE_KEY]) { return putError('invalid birthdate parameter', Users::ERROR_BIRTHDATE_FORMAT, $response); } } } } $info[Users::GENDER_KEY] = $info[Users::GENDER_KEY] == "male"; $info = UsersInfoDB::update($token[Users::ID_KEY], $info); if ($info === FALSE) { return putError('database connection error', DATABASE::ERROR_DATABASE_CONN, $response); } return putJsonBody(array('error' => false, 'info' => $info), 200, $response); }