Insert Firebase token into my sql tables from Android












1















I've been watching a tutorial that inserts the firebase token into the sql table.I'm trying to do to the same but code goes to onErrorResponse



I have done everything that the tutorial has and it's not working.From postman works fine but from my android phone isn't.Here is where the code goes.



public class MainActivity extends AppCompatActivity implements View.OnClickListener {


//URL to RegisterDevice.php
private static final String URL_REGISTER_DEVICE = "https://9.147.69.74/storeFcmToken.php";

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

}

//storing token to mysql server
private void sendTokenToServer() {
progressDialog = new ProgressDialog(this);
progressDialog.setMessage("Registering Device...");
progressDialog.show();

final String token = SharedPrefManager.getInstance(this).getDeviceToken();
final String email = editTextEmail.getText().toString();

if (token == null) {
progressDialog.dismiss();
Toast.makeText(this, "Token not generated", Toast.LENGTH_LONG).show();
} else {
StringRequest stringRequest = new StringRequest(Request.Method.POST, URL_REGISTER_DEVICE,
new Response.Listener<String>() {
@Override
public void onResponse(String response) {
progressDialog.dismiss();
try {
JSONObject obj = new JSONObject(response);
Toast.makeText(MainActivity.this, obj.getString("message"), Toast.LENGTH_LONG).show();
} catch (JSONException e) {
e.printStackTrace();
}
}
},
new Response.ErrorListener() {
@Override
public void onErrorResponse(VolleyError error) { //****CODE GOES HERE******
progressDialog.dismiss();
Toast.makeText(MainActivity.this, error.getMessage(), Toast.LENGTH_LONG).show();
}
}) {

@Override
protected Map<String, String> getParams() throws AuthFailureError {
Map<String, String> params = new HashMap<>();
params.put("email", email);
params.put("token", token);
return params;
}
};
RequestQueue requestQueue = Volley.newRequestQueue(this);
requestQueue.add(stringRequest);
}
}

@Override
public void onClick(View view) {
if (view == buttonRegister) {
sendTokenToServer();
}
}
}


here is my php file



   <?php

$token=$_POST['token'];
$email=$_POST['email'];

$con =new mysqli('localhost','root','','gekon');

$stmt= $con->prepare("INSERT INTO devices (email,token) VALUES ($email,?)");
$stmt->bind_param("ss",$email,$token);

$response=array();

if($stmt->execute()){
$response['error']= false;
$response['message']='token stooored';
}
else{
$response['error']= true;
$response['message']='token NOT stooored';
}

echo json_encode($response);









share|improve this question


















  • 2





    And what is the error you are getting?

    – André Kool
    Nov 26 '18 at 12:56






  • 1





    @AndréKool the error.getmessage() returns null

    – Alex Kolydas
    Nov 26 '18 at 13:09
















1















I've been watching a tutorial that inserts the firebase token into the sql table.I'm trying to do to the same but code goes to onErrorResponse



I have done everything that the tutorial has and it's not working.From postman works fine but from my android phone isn't.Here is where the code goes.



public class MainActivity extends AppCompatActivity implements View.OnClickListener {


//URL to RegisterDevice.php
private static final String URL_REGISTER_DEVICE = "https://9.147.69.74/storeFcmToken.php";

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

}

//storing token to mysql server
private void sendTokenToServer() {
progressDialog = new ProgressDialog(this);
progressDialog.setMessage("Registering Device...");
progressDialog.show();

final String token = SharedPrefManager.getInstance(this).getDeviceToken();
final String email = editTextEmail.getText().toString();

if (token == null) {
progressDialog.dismiss();
Toast.makeText(this, "Token not generated", Toast.LENGTH_LONG).show();
} else {
StringRequest stringRequest = new StringRequest(Request.Method.POST, URL_REGISTER_DEVICE,
new Response.Listener<String>() {
@Override
public void onResponse(String response) {
progressDialog.dismiss();
try {
JSONObject obj = new JSONObject(response);
Toast.makeText(MainActivity.this, obj.getString("message"), Toast.LENGTH_LONG).show();
} catch (JSONException e) {
e.printStackTrace();
}
}
},
new Response.ErrorListener() {
@Override
public void onErrorResponse(VolleyError error) { //****CODE GOES HERE******
progressDialog.dismiss();
Toast.makeText(MainActivity.this, error.getMessage(), Toast.LENGTH_LONG).show();
}
}) {

@Override
protected Map<String, String> getParams() throws AuthFailureError {
Map<String, String> params = new HashMap<>();
params.put("email", email);
params.put("token", token);
return params;
}
};
RequestQueue requestQueue = Volley.newRequestQueue(this);
requestQueue.add(stringRequest);
}
}

@Override
public void onClick(View view) {
if (view == buttonRegister) {
sendTokenToServer();
}
}
}


here is my php file



   <?php

$token=$_POST['token'];
$email=$_POST['email'];

$con =new mysqli('localhost','root','','gekon');

$stmt= $con->prepare("INSERT INTO devices (email,token) VALUES ($email,?)");
$stmt->bind_param("ss",$email,$token);

$response=array();

if($stmt->execute()){
$response['error']= false;
$response['message']='token stooored';
}
else{
$response['error']= true;
$response['message']='token NOT stooored';
}

echo json_encode($response);









share|improve this question


















  • 2





    And what is the error you are getting?

    – André Kool
    Nov 26 '18 at 12:56






  • 1





    @AndréKool the error.getmessage() returns null

    – Alex Kolydas
    Nov 26 '18 at 13:09














1












1








1








I've been watching a tutorial that inserts the firebase token into the sql table.I'm trying to do to the same but code goes to onErrorResponse



I have done everything that the tutorial has and it's not working.From postman works fine but from my android phone isn't.Here is where the code goes.



public class MainActivity extends AppCompatActivity implements View.OnClickListener {


//URL to RegisterDevice.php
private static final String URL_REGISTER_DEVICE = "https://9.147.69.74/storeFcmToken.php";

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

}

//storing token to mysql server
private void sendTokenToServer() {
progressDialog = new ProgressDialog(this);
progressDialog.setMessage("Registering Device...");
progressDialog.show();

final String token = SharedPrefManager.getInstance(this).getDeviceToken();
final String email = editTextEmail.getText().toString();

if (token == null) {
progressDialog.dismiss();
Toast.makeText(this, "Token not generated", Toast.LENGTH_LONG).show();
} else {
StringRequest stringRequest = new StringRequest(Request.Method.POST, URL_REGISTER_DEVICE,
new Response.Listener<String>() {
@Override
public void onResponse(String response) {
progressDialog.dismiss();
try {
JSONObject obj = new JSONObject(response);
Toast.makeText(MainActivity.this, obj.getString("message"), Toast.LENGTH_LONG).show();
} catch (JSONException e) {
e.printStackTrace();
}
}
},
new Response.ErrorListener() {
@Override
public void onErrorResponse(VolleyError error) { //****CODE GOES HERE******
progressDialog.dismiss();
Toast.makeText(MainActivity.this, error.getMessage(), Toast.LENGTH_LONG).show();
}
}) {

@Override
protected Map<String, String> getParams() throws AuthFailureError {
Map<String, String> params = new HashMap<>();
params.put("email", email);
params.put("token", token);
return params;
}
};
RequestQueue requestQueue = Volley.newRequestQueue(this);
requestQueue.add(stringRequest);
}
}

@Override
public void onClick(View view) {
if (view == buttonRegister) {
sendTokenToServer();
}
}
}


here is my php file



   <?php

$token=$_POST['token'];
$email=$_POST['email'];

$con =new mysqli('localhost','root','','gekon');

$stmt= $con->prepare("INSERT INTO devices (email,token) VALUES ($email,?)");
$stmt->bind_param("ss",$email,$token);

$response=array();

if($stmt->execute()){
$response['error']= false;
$response['message']='token stooored';
}
else{
$response['error']= true;
$response['message']='token NOT stooored';
}

echo json_encode($response);









share|improve this question














I've been watching a tutorial that inserts the firebase token into the sql table.I'm trying to do to the same but code goes to onErrorResponse



I have done everything that the tutorial has and it's not working.From postman works fine but from my android phone isn't.Here is where the code goes.



public class MainActivity extends AppCompatActivity implements View.OnClickListener {


//URL to RegisterDevice.php
private static final String URL_REGISTER_DEVICE = "https://9.147.69.74/storeFcmToken.php";

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

}

//storing token to mysql server
private void sendTokenToServer() {
progressDialog = new ProgressDialog(this);
progressDialog.setMessage("Registering Device...");
progressDialog.show();

final String token = SharedPrefManager.getInstance(this).getDeviceToken();
final String email = editTextEmail.getText().toString();

if (token == null) {
progressDialog.dismiss();
Toast.makeText(this, "Token not generated", Toast.LENGTH_LONG).show();
} else {
StringRequest stringRequest = new StringRequest(Request.Method.POST, URL_REGISTER_DEVICE,
new Response.Listener<String>() {
@Override
public void onResponse(String response) {
progressDialog.dismiss();
try {
JSONObject obj = new JSONObject(response);
Toast.makeText(MainActivity.this, obj.getString("message"), Toast.LENGTH_LONG).show();
} catch (JSONException e) {
e.printStackTrace();
}
}
},
new Response.ErrorListener() {
@Override
public void onErrorResponse(VolleyError error) { //****CODE GOES HERE******
progressDialog.dismiss();
Toast.makeText(MainActivity.this, error.getMessage(), Toast.LENGTH_LONG).show();
}
}) {

@Override
protected Map<String, String> getParams() throws AuthFailureError {
Map<String, String> params = new HashMap<>();
params.put("email", email);
params.put("token", token);
return params;
}
};
RequestQueue requestQueue = Volley.newRequestQueue(this);
requestQueue.add(stringRequest);
}
}

@Override
public void onClick(View view) {
if (view == buttonRegister) {
sendTokenToServer();
}
}
}


here is my php file



   <?php

$token=$_POST['token'];
$email=$_POST['email'];

$con =new mysqli('localhost','root','','gekon');

$stmt= $con->prepare("INSERT INTO devices (email,token) VALUES ($email,?)");
$stmt->bind_param("ss",$email,$token);

$response=array();

if($stmt->execute()){
$response['error']= false;
$response['message']='token stooored';
}
else{
$response['error']= true;
$response['message']='token NOT stooored';
}

echo json_encode($response);






php android sql firebase






share|improve this question













share|improve this question











share|improve this question




share|improve this question










asked Nov 26 '18 at 12:37









Alex KolydasAlex Kolydas

346317




346317








  • 2





    And what is the error you are getting?

    – André Kool
    Nov 26 '18 at 12:56






  • 1





    @AndréKool the error.getmessage() returns null

    – Alex Kolydas
    Nov 26 '18 at 13:09














  • 2





    And what is the error you are getting?

    – André Kool
    Nov 26 '18 at 12:56






  • 1





    @AndréKool the error.getmessage() returns null

    – Alex Kolydas
    Nov 26 '18 at 13:09








2




2





And what is the error you are getting?

– André Kool
Nov 26 '18 at 12:56





And what is the error you are getting?

– André Kool
Nov 26 '18 at 12:56




1




1





@AndréKool the error.getmessage() returns null

– Alex Kolydas
Nov 26 '18 at 13:09





@AndréKool the error.getmessage() returns null

– Alex Kolydas
Nov 26 '18 at 13:09












0






active

oldest

votes












Your Answer






StackExchange.ifUsing("editor", function () {
StackExchange.using("externalEditor", function () {
StackExchange.using("snippets", function () {
StackExchange.snippets.init();
});
});
}, "code-snippets");

StackExchange.ready(function() {
var channelOptions = {
tags: "".split(" "),
id: "1"
};
initTagRenderer("".split(" "), "".split(" "), channelOptions);

StackExchange.using("externalEditor", function() {
// Have to fire editor after snippets, if snippets enabled
if (StackExchange.settings.snippets.snippetsEnabled) {
StackExchange.using("snippets", function() {
createEditor();
});
}
else {
createEditor();
}
});

function createEditor() {
StackExchange.prepareEditor({
heartbeatType: 'answer',
autoActivateHeartbeat: false,
convertImagesToLinks: true,
noModals: true,
showLowRepImageUploadWarning: true,
reputationToPostImages: 10,
bindNavPrevention: true,
postfix: "",
imageUploader: {
brandingHtml: "Powered by u003ca class="icon-imgur-white" href="https://imgur.com/"u003eu003c/au003e",
contentPolicyHtml: "User contributions licensed under u003ca href="https://creativecommons.org/licenses/by-sa/3.0/"u003ecc by-sa 3.0 with attribution requiredu003c/au003e u003ca href="https://stackoverflow.com/legal/content-policy"u003e(content policy)u003c/au003e",
allowUrls: true
},
onDemand: true,
discardSelector: ".discard-answer"
,immediatelyShowMarkdownHelp:true
});


}
});














draft saved

draft discarded


















StackExchange.ready(
function () {
StackExchange.openid.initPostLogin('.new-post-login', 'https%3a%2f%2fstackoverflow.com%2fquestions%2f53481282%2finsert-firebase-token-into-my-sql-tables-from-android%23new-answer', 'question_page');
}
);

Post as a guest















Required, but never shown

























0






active

oldest

votes








0






active

oldest

votes









active

oldest

votes






active

oldest

votes
















draft saved

draft discarded




















































Thanks for contributing an answer to Stack Overflow!


  • Please be sure to answer the question. Provide details and share your research!

But avoid



  • Asking for help, clarification, or responding to other answers.

  • Making statements based on opinion; back them up with references or personal experience.


To learn more, see our tips on writing great answers.




draft saved


draft discarded














StackExchange.ready(
function () {
StackExchange.openid.initPostLogin('.new-post-login', 'https%3a%2f%2fstackoverflow.com%2fquestions%2f53481282%2finsert-firebase-token-into-my-sql-tables-from-android%23new-answer', 'question_page');
}
);

Post as a guest















Required, but never shown





















































Required, but never shown














Required, but never shown












Required, but never shown







Required, but never shown

































Required, but never shown














Required, but never shown












Required, but never shown







Required, but never shown







Popular posts from this blog

Create new schema in PostgreSQL using DBeaver

Deepest pit of an array with Javascript: test on Codility

Costa Masnaga