如何将PHP变量（含mysqli_insert_id()获取的ID）传入Android Studio的EditText？

Hey there! Let's walk through exactly how to get that auto-generated ID from your PHP backend into an Android EditText, and tie it all together with your two-form database flow. Here's a step-by-step breakdown:

Step 1: Update Your PHP Endpoint to Return the Inserted ID #

First, when you submit the first form to your MySQL database, use mysqli_insert_id() to grab the auto-generated primary key, then send it back to Android as a JSON response. This is clean and easy to parse on the Android side.

Here's a simplified PHP example:

<?php
// Connect to your database (replace with your credentials)
$conn = mysqli_connect("your_host", "your_username", "your_password", "your_db");

if (!$conn) {
    die(json_encode(["success" => false, "error" => "Connection failed: " . mysqli_connect_error()]));
}

// Handle first form submission
if ($_SERVER["REQUEST_METHOD"] === "POST" && isset($_POST['first_form_data'])) {
    // Sanitize input to prevent SQL injection
    $formData = mysqli_real_escape_string($conn, $_POST['first_form_data']);
    
    $insertQuery = "INSERT INTO first_table (your_column) VALUES ('$formData')";
    
    if (mysqli_query($conn, $insertQuery)) {
        // Get the auto-generated ID
        $generatedId = mysqli_insert_id($conn);
        // Send success response with the ID
        echo json_encode(["success" => true, "id" => $generatedId]);
    } else {
        echo json_encode(["success" => false, "error" => mysqli_error($conn)]);
    }
}

mysqli_close($conn);
?>

Step 2: Send First Form Data from Android & Retrieve the ID #

On the Android side, you'll need to send the first form data to your PHP endpoint, parse the JSON response, and then set the retrieved ID into your EditText.

Option 1: Using Retrofit (Recommended for Clean Code) #

Retrofit handles network threading and JSON parsing automatically. First, add the Retrofit dependencies to your build.gradle (Module level), then define an API interface and response model:

// API Interface
public interface FormApi {
    @FormUrlEncoded
    @POST("your_php_endpoint.php")
    Call<InsertResponse> submitFirstForm(@Field("first_form_data") String formData);
}

// Response Model Class
public class InsertResponse {
    private boolean success;
    private int id;
    private String error;

    // Getters (required for Gson parsing)
    public boolean isSuccess() { return success; }
    public int getId() { return id; }
    public String getError() { return error; }
}

Then, in your Activity/Fragment, use Retrofit to submit the form and set the ID to EditText:

// Initialize Retrofit (replace with your server base URL)
Retrofit retrofit = new Retrofit.Builder()
        .baseUrl("http://your_server_ip/")
        .addConverterFactory(GsonConverterFactory.create())
        .build();

FormApi formApi = retrofit.create(FormApi.class);

// Submit first form data (replace with your actual input)
String firstFormInput = "Your first form data here";
Call<InsertResponse> call = formApi.submitFirstForm(firstFormInput);

call.enqueue(new Callback<InsertResponse>() {
    @Override
    public void onResponse(Call<InsertResponse> call, Response<InsertResponse> response) {
        if (response.isSuccessful() && response.body() != null) {
            if (response.body().isSuccess()) {
                // Get the generated ID and set it to EditText
                int foreignKeyId = response.body().getId();
                EditText foreignKeyEditText = findViewById(R.id.your_edittext_id);
                foreignKeyEditText.setText(String.valueOf(foreignKeyId));
            } else {
                // Show error message
                Toast.makeText(getApplicationContext(), "Error: " + response.body().getError(), Toast.LENGTH_SHORT).show();
            }
        }
    }

    @Override
    public void onFailure(Call<InsertResponse> call, Throwable t) {
        Toast.makeText(getApplicationContext(), "Network error: " + t.getMessage(), Toast.LENGTH_SHORT).show();
    }
});

Option 2: Using HttpURLConnection (No External Libraries) #

If you prefer not to use Retrofit, you can use Android's built-in HttpURLConnection with an AsyncTask (or coroutines for newer Android versions):

new AsyncTask<Void, Void, String>() {
    @Override
    protected String doInBackground(Void... voids) {
        String response = "";
        try {
            URL url = new URL("http://your_server_ip/your_php_endpoint.php");
            HttpURLConnection conn = (HttpURLConnection) url.openConnection();
            conn.setRequestMethod("POST");
            conn.setDoOutput(true);

            // Encode and send first form data
            String postData = "first_form_data=" + URLEncoder.encode("Your first form data", "UTF-8");
            OutputStream os = conn.getOutputStream();
            os.write(postData.getBytes());
            os.flush();
            os.close();

            // Read the response
            BufferedReader br = new BufferedReader(new InputStreamReader(conn.getInputStream()));
            String line;
            while ((line = br.readLine()) != null) {
                response += line;
            }
            br.close();
            conn.disconnect();
        } catch (Exception e) {
            e.printStackTrace();
        }
        return response;
    }

    @Override
    protected void onPostExecute(String s) {
        super.onPostExecute(s);
        try {
            JSONObject jsonResponse = new JSONObject(s);
            if (jsonResponse.getBoolean("success")) {
                int foreignKeyId = jsonResponse.getInt("id");
                EditText foreignKeyEditText = findViewById(R.id.your_edittext_id);
                foreignKeyEditText.setText(String.valueOf(foreignKeyId));
            } else {
                Toast.makeText(getApplicationContext(), "Error: " + jsonResponse.getString("error"), Toast.LENGTH_SHORT).show();
            }
        } catch (JSONException e) {
            e.printStackTrace();
            Toast.makeText(getApplicationContext(), "Invalid server response", Toast.LENGTH_SHORT).show();
        }
    }
}.execute();

Step 3: Submit the Second Form with the Foreign Key #

Once the ID is in your EditText, you can retrieve it when submitting the second form and send it to your PHP endpoint to insert into the second table as the foreign key.

PHP Endpoint for Second Form: #

<?php
$conn = mysqli_connect("your_host", "your_username", "your_password", "your_db");

if (!$conn) {
    die(json_encode(["success" => false, "error" => "Connection failed: " . mysqli_connect_error()]));
}

if ($_SERVER["REQUEST_METHOD"] === "POST" && isset($_POST['second_form_data'], $_POST['foreign_key_id'])) {
    $secondData = mysqli_real_escape_string($conn, $_POST['second_form_data']);
    $foreignKey = intval($_POST['foreign_key_id']); // Sanitize as integer
    
    $insertQuery = "INSERT INTO second_table (your_column, foreign_key_column) VALUES ('$secondData', $foreignKey)";
    
    if (mysqli_query($conn, $insertQuery)) {
        echo json_encode(["success" => true]);
    } else {
        echo json_encode(["success" => false, "error" => mysqli_error($conn)]);
    }
}

mysqli_close($conn);
?>

Android Code to Submit Second Form: #

// Retrieve the foreign key from EditText
String foreignKey = foreignKeyEditText.getText().toString();
// Send this foreignKey along with your second form data to the PHP endpoint (similar to Step 2)

Important Notes to Keep in Mind #

• Security First: Always sanitize input in PHP (use prepared statements instead of mysqli_real_escape_string() for even better protection against SQL injection). Use HTTPS instead of HTTP in production to encrypt data in transit.
• Network Threading: Never make network calls on Android's main UI thread—use Retrofit, AsyncTask, or coroutines to handle background operations.
• Error Handling: Add proper error messages for cases like failed network calls, database errors, or invalid responses so users know what went wrong.

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