function update_address($party_id, $addr_house_num, $addr_street, $addr_apt, $addr_city, $addr_state, $addr_zip, $db_conn) { // First, get the old info $old_info = get_party_data($party_id, $db_conn); if (is_null($old_info)) { return false; } else { $update_address_query = $db_conn->prepare("CALL update_address(:party_id, :addr_house_num, :addr_street, :addr_apt, :addr_city, :addr_state, :addr_zip)"); $update_address_query->bindParam(":party_id", $party_id); $update_address_query->bindParam(":addr_house_num", $addr_house_num); $update_address_query->bindParam(":addr_street", $addr_street); $update_address_query->bindParam(":addr_apt", $addr_apt); $update_address_query->bindParam(":addr_city", $addr_city); $update_address_query->bindParam(":addr_state", $addr_state); $update_address_query->bindParam(":addr_zip", $addr_zip); if ($update_address_query->execute()) { // If the update was successful, log it first log_address_update($old_info, $addr_house_num, $addr_street, $addr_apt, $addr_city, $addr_state, $addr_zip); return true; } else { return false; } } }
} else { $login_code = strtoupper(trim($_POST["login_code"])); $login_hash = md5($login_code); $login_query = $db_conn->prepare("CALL lookup_party_id(:login_hash)"); $login_query->bindParam(":login_hash", $login_hash); $login_query->execute(); $results = $login_query->fetchAll(PDO::FETCH_ASSOC); if (count($results) > 0) { $login_query->closeCursor(); $party_id = $results[0]["party_id"]; $return_value["login_successful"] = true; // Generate the login token $return_value["auth_token"] = generate_login_token($party_id, $db_conn); $return_value["party_id"] = $party_id; // Get party data $return_value["party_info"] = get_party_data($party_id, $db_conn); $return_value["party_info"]["current_plus_ones"] = get_current_plus_ones($party_id, $db_conn); // Get people in party $return_value["party_people"] = get_party_people($party_id, $db_conn); // Get music suggestions $return_value["music_suggestions"] = get_music_suggestions($party_id, $db_conn); // Get the food choices $return_value["food_choices"] = get_food_choices($db_conn); } else { $return_value["login_successful"] = false; $return_value["reason"] = "Invalid login code"; } } } } header("Content-type: application/json");