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?
– Willian Coqueiro
@Elvisroberto phpMyAdmin is a Gui for mysql database access
– Otto
Yes, made in mysql.
– Elvis Roberto
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.
– Wagner Soares