Unable to store Firebase token in MySQL database

Question

I cannot figure out where I'm going wrong. I need to get the firebase token and store it in my database and by using those tokens I need to send notifications to those devices. Below is my code. I really need some help with this.

MainActivity.java

public class MainActivity extends AppCompatActivity {



@Override
protected void onCreate(Bundle savedInstanceState) {

    super.onCreate(savedInstanceState);
    setContentView(R.layout.activity_main);

    FirebaseInstanceId.getInstance().getToken();
    FirebaseMessaging.getInstance();


}

}

FirebaseInstanceIDService.java

public class FirebaseInstanceIDService extends 
FirebaseInstanceIdService {

@Override
public void onTokenRefresh() {

    String token = FirebaseInstanceId.getInstance().getToken();
    Log.e("Token :",token);
    registerToken(token);
}

private void registerToken(String token) {

    OkHttpClient client = new OkHttpClient();
    RequestBody body = new FormBody.Builder()
            .add("Token",token)
            .build();

    Request request = new Request.Builder()
            .url("http://localhost/notify.php")
            .post(body)
            .build();

    try {
        client.newCall(request).execute();
    } catch (IOException e) {
        e.printStackTrace();
    }
}
}

FirebaseMessagingService.java

public class FirebaseMessagingService extends 

com.google.firebase.messaging.FirebaseMessagingService{

@Override
public void onMessageReceived(RemoteMessage remoteMessage) {

    showNotification(remoteMessage.getData().get("message"));
}

private void showNotification(String message) {

    Intent i = new Intent(this,MainActivity.class);
    i.addFlags(Intent.FLAG_ACTIVITY_CLEAR_TOP);

    PendingIntent pendingIntent = PendingIntent.getActivity(this,0,i,PendingIntent.FLAG_UPDATE_CURRENT);

    NotificationCompat.Builder builder = new NotificationCompat.Builder(this)
            .setAutoCancel(true)
            .setContentTitle("FCM Test")
            .setContentText(message)
            .setSmallIcon(R.drawable.gas45)
            .setContentIntent(pendingIntent);

    NotificationManager manager = (NotificationManager) 
getSystemService(NOTIFICATION_SERVICE);

    manager.notify(0,builder.build());
}


}

notify.php

<?php 
if (isset($_POST["Token"])) {

       $fcm_Token=$_POST["Token"];
       $conn = mysqli_connect("localhost","root","","fcm") or 
 die("Error connecting");
       $q="INSERT INTO users (Token) VALUES ( '$fcm_Token')"
          ."ON DUPLICATE KEY UPDATE Token = '$fcm_Token';";

  mysqli_query($conn,$q) or die(mysqli_error($conn));
  mysqli_close($conn);
}
?>

Please check my previous answer [this](https://stackoverflow.com/a/40283178/4741746 ) — Sushant Gosavi, Sep 14 '17 at 10:40
What isn't working about your code? Keep in mind: you're the only one of us that can run this code in a debugger and tell us what happens. — Frank van Puffelen, Sep 14 '17 at 13:50

score 1 · Answer 1 · answered Jan 30 '19 at 22:35

onTokenRefresh() is deprecated the best way to get token is :

   FirebaseInstanceId.getInstance().getInstanceId().addOnSuccessListener(MainActivity.this, new OnSuccessListener<InstanceIdResult>() {
            @Override
            public void onSuccess(InstanceIdResult instanceIdResult) {
                String newToken = instanceIdResult.getToken();
                Log.e("newToken", newToken);
                SharedPreferences.Editor editor = getSharedPreferences("TOKEN_PREF", MODE_PRIVATE).edit();
                if (token!=null){
                    storetoken(newToken);
                }

            }
        });

score 0 · Answer 2 · answered Sep 14 '17 at 10:40

0

Please change your query

   $q="INSERT INTO users (Token) VALUES ( '$fcm_Token')"
      ."ON DUPLICATE KEY UPDATE Token = '$fcm_Token';";

to this

$q="INSERT INTO users (Token) VALUES ( '".$fcm_Token."')"
          ."ON DUPLICATE KEY UPDATE Token = '".$fcm_Token."';";

I think you made mistake in PHP string appending with a variable syntax. You should append the $fcm_Token like this because you are already append the strings by using . operator.

Please try this.

answered Sep 14 '17 at 10:40

Pranav MS

2,235
2
23
50

Sorry, i don't understand what you're saying. – Srikavi Kalyani Sep 14 '17 at 11:02
did you check that your query is working properly ... i missed `query`. – Pranav MS Sep 14 '17 at 11:03
@Pranav MS He didnt get token at android side after getting token PHP code is executed so firstly we need to check android side than php side – Sushant Gosavi Sep 14 '17 at 11:49

score 0 · Answer 3 · answered Sep 14 '17 at 11:55

You can check

Check your internet connection with no proxy and open internet connect
Replace your google-service.json with new one you can get this in firebaseconsol
Please check your device has google play service in it and it working or not , firebase not work without google play service

Check -FireBaseInstanceId service does not get registered

Did you register your Firebase service in AndroidManifiest.xml file

<!-- Firebase Notifications -->
        <service
            android:name="com.indus.corelib.notification.FirebaseMessagingService"
            android:exported="false" >
            <intent-filter>
                <action android:name="com.google.firebase.MESSAGING_EVENT" />
            </intent-filter>
        </service>
        <service
            android:name="com.indus.corelib.notification.FirebaseIDService"
            android:exported="false" >
            <intent-filter>
                <action android:name="com.google.firebase.INSTANCE_ID_EVENT" />
            </intent-filter>
        </service>

Please follow this step one anther example and best one Good Luck

Unable to store Firebase token in MySQL database

3 Answers3