I am trying to register a user in the registration page but getting error, i have converted every details i need to string but still not working,maybe the problem is from the php code.the insert doesn't work.
What I have tried:
this is the Registration activity
public class Register extends AppCompatActivity {
EditText name1, etpolicyNumber, etPassword;
Button bRegister;
@Override
protected void onCreate(Bundle savedInstanceState) {
super.onCreate(savedInstanceState);
setContentView(R.layout.register);
name1 = (EditText) findViewById(R.id.name);
etpolicyNumber = (EditText) findViewById(R.id.policy_number1);
etPassword = (EditText) findViewById(R.id.password1);
bRegister = (Button) findViewById(R.id.btnregister);
bRegister.setOnClickListener(new View.OnClickListener() {
@Override
public void onClick(View v) {
String name = name1.getText().toString();
String policyNumber = etpolicyNumber.getText().toString();
String password = etPassword.getText().toString();
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, MainActivity.class);
startActivity(intent);
Toast.makeText(Register.this, "Registration Successful", Toast.LENGTH_SHORT).show();
} 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, policyNumber, password, responseListener);
RequestQueue queue = Volley.newRequestQueue(Register.this);
queue.add(registerRequest);
}
});
}
}
this is the RegisterRequest java
public class RegisterRequest extends StringRequest {
private static final String REGISTER_REQUEST_URL = "http://beigecare.ga/Register.php";
private Map<String, String> params;
public RegisterRequest(String name, String policyNumber, String password, Response.Listener<String> listener){
super(Method.POST, REGISTER_REQUEST_URL, listener, null);
params = new HashMap<>();
params.put("name", name);
params.put("policyNumber", policyNumber);
params.put("password", password);
}
@Override
public Map<String, String> getParams(){
return params;
}
}
this is the register php code
<?php
$con = mysqli_connect("mysql.hostinger.in", "u608965245_user", "Engmann1", "u608965245_data");
$name = $_POST["name"];
$policynumber = $_POST["policyNumber"];
$password = $_POST["password"];
$statement = mysqli_prepare($con, "INSERT INTO user (name, policynumber, password) VALUES (?, ?, ?)");
mysqli_stmt_bind_param($statement, "siss", $name, $policynumber, $password);
mysqli_stmt_execute($statement);
$response = array();
$response["success"] = true;
echo json_encode($response);
?>
Please help me correctn it