laabroo

//on model
function getUserDetails(){

        $this->db->select('coment,name,dob,contry,main_photo');
        $this->db->from('user');
        $this->db->join('coment', 'coment.email = user.email');
        $query = $this->db->get();
        if ($query->num_rows() > 0) {
            return $query->result();
        }

laabroo

//how to get user where name = laabroo

select u.name as name 
from User u
where u.name = 'laabroo'

laabroo

public class ConvertJakson {
 private JsonData jsonData;
 private Gson gson;
 private String json;
 
 public ConvertJakson() {
  Log.i("Hasil Json : ", jsonData + "");
  String data = objJson();
  Log.i("ConvetJakson : ", data + "");
 

laabroo

public String loadData(double lat, double lon, double rad) {
		httpGet = new HttpGet("http://laabroo.cu.cc/lokasi.php?lat=" + lat
				+ "&lon=" + lon + "&rad=" + rad);
		StringBuilder builder = new StringBuilder();
		httpClient = new DefaultHttpClient();
		try {
			response = httpClient.execute(httpGet);
			StatusLine statusLine = response.getStatusLine();
			int statuscode = statusLine.getStatusCode();
			if (statuscode == 200) {

laabroo

        private void getAll(double lat, double lon, double rad) {
		String posisis = loadData(lat, lon, rad);
		Log.i("Posisi : ", posisis);
		try {
			JSONObject obj = new JSONObject(posisis);
			JSONArray jsonArray = obj.getJSONArray("items");

			for (int i = 0; i < jsonArray.length(); i++) {
				JSONObject jsonObject = jsonArray.getJSONObject(i);

laabroo

@SuppressWarnings("serial")
public class Place implements Serializable {

	public double lat;
	public double lon;
	public double rad;
	public String name;
	public String address;
	
	public Place() {

laabroo

        protected void tampilkanPosisikeMap(Location newLocation) {
		List<Overlay> overlays = mapView.getOverlays();

		if (overlays.size() > 0) {
			for (Iterator<Overlay> iterator = overlays.iterator(); iterator
					.hasNext();) {
				iterator.next();
				iterator.remove();
			}
		}

laabroo

	private void initMap() {
		mapView = (MapView) findViewById(R.id.mymap);
		mapView.displayZoomControls(true);
		mapView.getController().setZoom(16);

	}

laabroo

         private void initPosition() {
		locManager = (LocationManager) getSystemService(Context.LOCATION_SERVICE);
		locListener = new LocationListener() {

			public void onStatusChanged(String provider, int status,
					Bundle extras) {
				// TODO Auto-generated method stub

			}

laabroo

	public void onCreate(Bundle savedInstanceState) {
		super.onCreate(savedInstanceState);
		setContentView(R.layout.main);

		initPosition();
		initMap();
		// initLocationManager();
	}