如何通过Swift URLSession将ID数组传递给PHP执行SQL查询？

Hey there! Let's figure out why your URLSession calls aren't returning results when using multiple IDs in your array—this is a super common snag, so let's break it down step by step.

First, Let's Diagnose the Root Cause #

The problem you're seeing (works with 1 ID in NSArray, fails with multiple; no results with Swift Array) almost always boils down to how you're converting the ID array into a format your backend API understands. Here's what's likely happening:

• When you use a single ID in NSArray, the API might accidentally parse the raw array string (like (123)) as a valid single ID.
• With multiple IDs, the raw array format (like (123,456)) is unrecognizable to the API, so it returns no data (or silently fails).
• For Swift Arrays, you're probably not converting the array to a compatible string/parameter format at all, so the API gets nothing useful.

Fixes: Convert Your ID Array to API-Friendly Formats #

Below are the most common solutions, depending on what your backend expects:

1. Comma-Separated String (Most Common for GET Requests)

If your API expects a single query parameter like ids=123,456,789, convert your array to a comma-separated string:

let ids = [123, 456, 789] // Your Swift ID array
let idsString = ids.map(String.init).joined(separator: ",")

// Build the request URL
var components = URLComponents(string: "https://your-api-url.com/your-endpoint")!
components.queryItems = [URLQueryItem(name: "ids", value: idsString)]

guard let url = components.url else {
    print("Invalid URL—check your endpoint!")
    return
}

var request = URLRequest(url: url)
request.httpMethod = "GET"

2. Multiple Query Parameters (e.g., id=123&id=456)

If your API expects separate id parameters for each value, create a query item for every ID:

let ids = [123, 456, 789]
var components = URLComponents(string: "https://your-api-url.com/your-endpoint")!
components.queryItems = ids.map { URLQueryItem(name: "id", value: String($0)) }

guard let url = components.url else {
    print("Invalid URL")
    return
}

var request = URLRequest(url: url)
request.httpMethod = "GET"

3. JSON Array in Request Body (For POST/PUT Requests)

If your API expects an array in the request body (JSON format), serialize the array directly:

let ids = [123, 456, 789]
let parameters = ["ids": ids]

// Convert to JSON data
guard let jsonData = try? JSONSerialization.data(withJSONObject: parameters) else {
    print("Failed to serialize JSON")
    return
}

var request = URLRequest(url: URL(string: "https://your-api-url.com/your-endpoint")!)
request.httpMethod = "POST"
request.setValue("application/json", forHTTPHeaderField: "Content-Type")
request.httpBody = jsonData

Don't Forget the Critical URLSession Step! #

Double-check that you're calling resume() on your data task—this is an easy oversight that makes it look like no request is being sent:

let task = URLSession.shared.dataTask(with: request) { data, response, error in
    // Handle errors first
    if let error = error {
        print("Request failed: \(error.localizedDescription)")
        return
    }
    
    // Check for valid data
    guard let data = data else {
        print("No data received from API")
        return
    }
    
    // Parse and print the response
    do {
        let responseJSON = try JSONSerialization.jsonObject(with: data)
        print("Success! Response: \(responseJSON)")
    } catch {
        print("JSON parsing error: \(error.localizedDescription)")
    }
}

// THIS IS ESSENTIAL—start the request!
task.resume()

Why NSArray Worked for Single IDs #

When you used a single ID in NSArray, the API probably interpreted the raw string representation (like (123)) as a valid ID. But with multiple IDs, the format (123,456) doesn't match what the API expects, so it returns nothing. Swift Arrays have a different string representation, which is even less likely to be parsed correctly.

内容的提问来源于stack exchange，提问作者JamMan9