Example #1
0
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;
        }
    }
}
Example #2
0
        } 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");