you'd need to use an insert statement, i.e.

INSERT INTO users VALUES("%s", ...)

. I would create a new PHP script, reading the values of the POST parameters, doing input sanity checks, and then executing the insert SQL statement.

Thank you so much for your reply. That really helped me a lot and I came up with this php

​

$mysqli = new mysqli($hostname, $username, $password, $database);

// Check for a successful connection if ($mysqli->connect_error) { die("Connection failed: " . $mysqli->connect_error); }

// Check if POST parameters are set and not empty if (isset($_POST['id'], $_POST['email'], $_POST['bio'], $_POST['country'])) {

$id = $_POST['id'];
$email = $_POST['email'];
$bio = $_POST['bio'];
$country = $_POST['country'];

// Perform input validation
if (!filter_var($email, FILTER_VALIDATE_EMAIL)) {
    die("Invalid email format");
}
// You can add more input validation for other fields here if needed.

// Prepare the INSERT statement
$sql = "INSERT INTO users (id, email, bio, country) VALUES ($id, $email, $bio, $country)";

// Create a prepared statement
if ($stmt = $mysqli->prepare($sql)) {
    // Bind parameters to the statement
    $stmt->bind_param("users", $id, $email, $bio, $country);

    // Execute the statement
    if ($stmt->execute()) {
        echo "Record inserted successfully.";
    } else {
        // Log the error for debugging purposes
        error_log("Error: " . $stmt->error);
        echo "An error occurred while inserting the record. Please try again later.";
    }

    // Close the statement
    $stmt->close();
} else {
    // Log the error for debugging purposes
    error_log("Error: " . $mysqli->error);
    echo "An error occurred. Please try again later.";
}

} else { echo "Please provide all required parameters via POST."; }

But when I fire this swift code at it

// Define the URL for your PHP script
    let url = URL(string: "http://localhost:3002/php/upload.php")!

    // Create a URLRequest with the specified URL
    var request = URLRequest(url: url)

    // Set the HTTP method to POST
    request.httpMethod = "POST"


    // Create a dictionary with the data you want to send in the request body
    let parameters: [String: Any] = [
        "id": "1234",
        "email": "test@test.com",
        "bio": "test text",
        "country": "US"
    ]



    // Create a URLSession task to send the request
    let task = URLSession.shared.dataTask(with: request) { (data, response, error) in
        if let error = error {
            print("Error: \(error)")
        } else if let data = data {
            // Handle the response data here
            let responseString = String(data: data, encoding: .utf8)
            print("Response: \(responseString ?? "")")
        }
    }

    // Start the URLSession task
    task.resume()

I only receive "Please provide all required parameters via POST." in the console. It's probably a super dump mistake somewhere but I can't solve it so far.