java - 用户注册页面未验证

Question

<?php
    	
       

    $name = $_POST["name"];
    $age = $_POST["age"];
    $email = $_POST["email"];
    $password =$_POST["password"];

    $statement = mysqli_prepare($db, "INSERT INTO user_info(name,age,email,password) 
    VALUES
    (?,?,?,?)");  
    mysqli_stmt_bind_param($statement, "siss", $name, $age, $email, $password);
    mysqli_stmt_execute($statement);
     
      if($statement>0){
               $response["success"] = 1;
             }    
         else{
               $response["success"] = 0;
             }
        
         echo json_encode($response);



    ?>

我的用户注册页面不想验证。请告知 PHP 文本文件和 android 端之间编码的哪一侧验证将允许验证。请进一步协助，这是代码。

@Override
protected void onCreate(Bundle savedInstanceState) {
    super.onCreate(savedInstanceState);
    setContentView(R.layout.activity_register);

final EditText Name = (EditText) findViewById(R.id.edtName);
final EditText Age = (EditText) findViewById(R.id.edtAge);
final EditText Email = (EditText) findViewById(R.id.edtUsername);
final EditText Password = (EditText) findViewById(R.id.edtPassword);
final ImageButton validate = (ImageButton) findViewById(R.id.btnReg);

validate.setOnClickListener(new View.OnClickListener() {
@Override
public void onClick(View v) {
final int age = Integer.parseInt(Age.getText().toString());
final String name = Name.getText().toString();
final String email = Email.getText().toString();
final String password = Password.getText().toString();


Name.setText("");
Age.setText("");
Email.setText("");
Password.setText("");

                                                                         Response.Listener<String>responseListener=new                                    Response.Listener<String>() {
@Override
public void onResponse(String response) {
try {
JSONObject jsonResponse = new JSONObject(response);
boolean success = jsonResponse.getBoolean("success");
if (success) {
Intent intent = new Intent(Register.this, Login.class);
Register.this.startActivity(intent);
} else {
AlertDialog.Builder builder = new AlertDialog.Builder(Register.this);
builder.setMessage("Register Failed")
.setNegativeButton("Retry", null)
.create()
.show();
}
} catch (JSONException e) {
e.printStackTrace();
}
}
};
RegisterRequest registerRequest = new RegisterRequest(name, age, email,  password, responseListener);
RequestQueue queue = Volley.newRequestQueue(Register.this);
queue.add(registerRequest);
}
});
}

public void extBtn(View view) {
Intent intent = new Intent(this, MainActivity.class);
startActivity(intent);
}
}

Answer 1

尝试使用这部分代码:

$bind = mysqli_stmt_bind_param($statement, "siss", $name, $age, $email, $password);
$execute = $bind->mysqli_stmt_execute($bind);

 if(count($execute) > 0){
     $response["success"] = 1;
 } else{
     $response["success"] = 0;
 }       

 echo json_encode($response);

count 是对数据库中的行进行计数。