Problem handling data to php with POST method

Question

I'm working on an application that registers users in a database of a domain I have. I developed it using Android Studio, and I'm having some problems handling the users info to the php file using the POST method.

The main problem I have is that my app returns a success while transfering the data to the database, but when I look at it it's empty.

Here's my Java code:

package com.test.application;

import com.android.volley.Response;
import com.android.volley.toolbox.StringRequest;

import java.util.HashMap;
import java.util.Map;

public class RegisterRequest extends StringRequest {

private static final String REGISTER_REQUEST_URL="http://www.mywebsite.com/Register.php";
private Map<String,String> params;
public RegisterRequest(String user, String password, String email, Response.Listener<String> listener){
    super(Method.POST, REGISTER_REQUEST_URL, listener, null);
    params = new HashMap<>();
    params.put("name", user);
    params.put("password", password);
    params.put("useremail", email);
}

@Override
public Map<String, String> getParams() {
    return params;
}
}

and here's my PHP code that recieves the data:

<?php
    $con = mysqli_connect("bbdd.mywebsite.com", "user", "password", "database");
    
    $Username = $_POST["name"];
    $Password = $_POST["password"];
    $UserEmail = $_POST["useremail"];
    $statement = mysqli_prepare($con, "INSERT INTO AccountsInfo (Username, Password, UserEmail) VALUES (?, ?, ?)");
    mysqli_stmt_bind_param($statement, "ssis", $Username, $Password, $UserEmail);
    mysqli_stmt_execute($statement);
    
    $response = array();
    $response["success"] = true;  
    
    echo json_encode($response);
?>

The problem I'm having is that it returns me back a success in transfering the data in the php code but when I look at the database it's empty — Altariii
– Altariii, Commented Dec 3, 2018 at 18:14
You may want to modify your question to tell us what the problem actually is. That said, that connection string looks pretty suspicious. Since you never check for errors you'll never know whether or not it failed. Try localhost instead of bbdd.mywebsite.com and see what happens. Oh and turn on error reporting while you are doing development. ini_set('display_errors', 1); ini_set('display_startup_errors', 1); error_reporting(E_ALL); — Dave
– Dave, Commented Dec 3, 2018 at 18:19

Joni · Accepted Answer · 2018-12-03 18:20:54Z

1

Assuming everything else is correct, your parameter type specification in the bind call has an i (integer) that doesn't match any parameter. For 3 string parameters, you'll want to use sss:

mysqli_stmt_bind_param($statement, "sss", $Username, $Password, $UserEmail);

You should enable error reporting so that things don't just fail silently. See how to get a detailed error report when a php-mysql script fails?

answered Dec 3, 2018 at 18:20

Joni

112k14 gold badges151 silver badges201 bronze badges

Sign up to request clarification or add additional context in comments.

1 Comment

Altariii Over a year ago

Oh true! I added it by mistake. Everything alright now. Thanks a lot ;)

Collectives™ on Stack Overflow

Problem handling data to php with POST method

1 Answer 1

1 Comment

Your Answer

Linked

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

1 Comment

Your Answer

Sign up or log in

Post as a guest

Linked

Related