Recover Database data to Android using php!

Asked

Viewed 186 times

0

I need to retrieve the name, message, lat, long data from php. The problem is being in the part of Android, what I need to do to recover this data from the Activity "Android Part" saving these in variables?

Part php:

$sql = $dbcon->query("SELECT * FROM mensagem 
         INNER JOIN usuarios ON mensagem.idUsuarios = usuarios.idUsuarios

    ");

foreach ($sql as $value) {
    //$sql = $value['mensagem'];
    echo $value['nome']; 
    echo "<br>";
    echo $value['mensagem'];
    echo "<br>";
    echo $value['lat'];
    echo "<br>";
    echo $value['long'];
    echo "<br>";
}
?>

Android part:

package mundosenai.mundosenai.com.mundosenai;

import android.support.v4.app.FragmentActivity;
import android.os.Bundle;

import com.google.android.gms.maps.CameraUpdateFactory;
import com.google.android.gms.maps.GoogleMap;
import com.google.android.gms.maps.OnMapReadyCallback;
import com.google.android.gms.maps.SupportMapFragment;
import com.google.android.gms.maps.model.LatLng;
import com.google.android.gms.maps.model.MarkerOptions;

public class MapsFragment extends SupportMapFragment implements OnMapReadyCallback {

private GoogleMap mMap;

@Override
public void onCreate(Bundle savedInstanceState) {
    super.onCreate(savedInstanceState);
    getMapAsync(this);
}


/**
 * Manipulates the map once available.
 * This callback is triggered when the map is ready to be used.
 * This is where we can add markers or lines, add listeners or move the camera. In this case,
 * we just add a marker near Sydney, Australia.
 * If Google Play services is not installed on the device, the user will be prompted to install
 * it inside the SupportMapFragment. This method will only be triggered once the user has
 * installed Google Play services and returned to the app.
 */
   @Override
public void onMapReady(GoogleMap googleMap) {
    mMap = googleMap;


    // Add a marker in Sydney and move the camera
    LatLng sydney = new LatLng(-34, 151);
    mMap.addMarker(new MarkerOptions().position(sydney).title("Marker in Sydney"));
    mMap.moveCamera(CameraUpdateFactory.newLatLng(sydney));
}
}

  • Your bank and Mysql?

  • @Elvisroberto phpMyAdmin is a Gui for mysql database access

  • Yes, made in mysql.

  • Normally I work by making php return a json, ai on android I do the reading of it. The way you’re doing it will get complicated to read the returned values.

No answers

Browser other questions tagged

You are not signed in. Login or sign up in order to post.