Android通过PHP向MySQL插入数据失败，点击注册按钮后应用崩溃

Hey there! Let's break down why your registration flow is crashing and failing to insert data into MySQL. I'll walk through common issues on both the Android (Java) side and PHP backend, plus actionable fixes to get things working.

App crashes almost always leave a trail in Logcat—start by checking that for specific error messages (like NetworkOnMainThreadException or NullPointerException). Here are the most likely culprits:

Missing Internet Permissions #

Android blocks network access by default. Add this to your AndroidManifest.xml (right above the <application> tag):

<uses-permission android:name="android.permission.INTERNET"/>

If you're targeting Android 9+, plain HTTP requests are blocked by default. Either switch to HTTPS for your PHP endpoint, or create a res/xml/network_security_config.xml file to allow HTTP for your domain:

<?xml version="1.0" encoding="utf-8"?>
<network-security-config>
    <domain-config cleartextTrafficPermitted="true">
        <domain includeSubdomains="true">restaurant.zpcoder.mobi</domain>
    </domain-config>
</network-security-config>

Then reference it in your manifest's <application> tag:

android:networkSecurityConfig="@xml/network_security_config"

Network Calls on the Main Thread #

Android won't let you run network operations on the main UI thread—it freezes the app and crashes. Use a library like Volley (simple for POST requests) or Retrofit instead of making direct calls in your button click listener. Here's a quick Volley example:

// Inside your REGISTER button click handler
RequestQueue queue = Volley.newRequestQueue(this);
StringRequest stringRequest = new StringRequest(Request.Method.POST, REGISTER_URL,
        response -> Toast.makeText(u_details_Activity.this, "Registration successful!", Toast.LENGTH_SHORT).show(),
        error -> {
            Log.e("RegError", "Failed: " + error.getMessage());
            Toast.makeText(u_details_Activity.this, "Something went wrong", Toast.LENGTH_SHORT).show();
        }) {
    @Override
    protected Map<String, String> getParams() {
        Map<String, String> params = new HashMap<>();
        // Double-check these keys match what your PHP expects!
        params.put("name", mname.getText().toString().trim());
        params.put("email", memail.getText().toString().trim());
        params.put("password", mpass.getText().toString().trim());
        params.put("conf_password", mconf.getText().toString().trim());
        return params;
    }
};
queue.add(stringRequest);

Unhandled Null References #

Make sure you've properly initialized your EditText fields in onCreate():

@Override
protected void onCreate(Bundle savedInstanceState) {
    super.onCreate(savedInstanceState);
    setContentView(R.layout.your_activity_layout);
    
    // Replace with your actual view IDs
    mname = findViewById(R.id.et_name);
    memail = findViewById(R.id.et_email);
    mpass = findViewById(R.id.et_password);
    mconf = findViewById(R.id.et_conf_password);
}

Forgetting this will throw a NullPointerException when you try to get text from the fields.

Even if the Android app stops crashing, your PHP might be failing to insert data. Let's fix that:

Enable Error Reporting #

Add these lines at the top of your PHP file to see explicit errors:

error_reporting(E_ALL);
ini_set('display_errors', 1);

Validate Database Connection #

Double-check your DB credentials—this is a super common mistake:

$conn = mysqli_connect("localhost", "your_db_username", "your_db_password", "your_db_name");
if (!$conn) {
    die("Connection failed: " . mysqli_connect_error());
}

Use Prepared Statements (Avoid SQL Injection & Fix Syntax Errors) #

Never directly concatenate user input into SQL queries. Use prepared statements instead:

if ($_SERVER['REQUEST_METHOD'] === 'POST') {
    // Get and validate inputs
    $name = trim($_POST['name'] ?? '');
    $email = trim($_POST['email'] ?? '');
    $password = trim($_POST['password'] ?? '');
    $conf_pass = trim($_POST['conf_password'] ?? '');

    // Check if passwords match
    if ($password !== $conf_pass) {
        echo "Passwords do not match";
        exit;
    }

    // Prepare and execute insert
    $stmt = $conn->prepare("INSERT INTO users (name, email, password) VALUES (?, ?, ?)");
    $stmt->bind_param("sss", $name, $email, $password); // "sss" = 3 string parameters

    if ($stmt->execute()) {
        echo "Registration successful";
    } else {
        echo "Error: " . $stmt->error;
    }

    $stmt->close();
    $conn->close();
}

Test the PHP API Directly #

Before blaming Android, test your PHP endpoint with a tool like Postman or a simple HTML form:

<form method="post" action="http://restaurant.zpcoder.mobi/u_data_insert.php">
    Name: <input type="text" name="name"><br>
    Email: <input type="email" name="email"><br>
    Password: <input type="password" name="password"><br>
    Confirm Password: <input type="password" name="conf_password"><br>
    <button type="submit">Register</button>
</form>

If this form doesn't insert data, fix the PHP issues first before debugging Android.

• Log Everything: Use Log.d() in Android to print the values you're sending to the server, and print_r($_POST) in PHP to confirm you're receiving them.
• Handle Empty Inputs: Add checks in Android to make sure users don't submit empty fields:

  if (TextUtils.isEmpty(mname.getText().toString())) {
      mname.setError("Name is required");
      return;
  }
  

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