Find nearest based on GPS

SELECT ( 3959 * acos( cos( radians(28.6219459) ) * cos( radians( Latitude ) ) * 
cos( radians( Longitude ) - radians(77.384108) ) + sin( radians(28.6219459) ) * 
sin( radians( Latitude ) ) ) ) AS distance,DealerName,DealerID 
FROM jcb.tbl_dealer_list HAVING distance < 10 ORDER BY distance LIMIT 0 , 20;

Call php page from url

Syntax

http://localhost:90/jcb_api_session/login.php?email=admin@gmail.com&password=admin


OUTPUT

[{"status":1,"msg":"login success..!","Key":"82f36a9bcc570b6250292cc2b1e68376"}]



login.php

<?php
include("include/connection.php");
session_start();

if(isset($_GET['email']) && isset($_GET['password']))
{
    $email=mysqli_real_escape_string($con,$_GET['email']);
    $password=mysqli_real_escape_string($con,$_GET['password']);
   $query="select * from tbl_user_master where Email='$email' AND Password='$password'";
    $res=mysqli_query($con,$query);
    $count=mysqli_num_rows($res);
    if($count == 1)
    {
     $key=$_SESSION['token']=md5(uniqid(mt_rand(),true));
         $json[] = array("status"=> 1, "msg"=>"login success..!" ,"Key"=>$key);
        echo json_encode($json);
    }
    else
    {
         $json[] = array("status"=> 0, "msg"=>"login failed..!" );
        echo json_encode($json);
    }
   
}
else
{
    $json[] = array("status"=> 0, "msg"=>"Not receive required data..!" );
        echo json_encode($json);
   
}

?>


MySQL Database

Showing Gif Image in Android

1. Add below code to app level gradle

dependencies {
    compile 'pl.droidsonroids.gif:android-gif-drawable:1.1.+'}

2. activity_main.xml

<?xml version="1.0" encoding="utf-8"?><LinearLayout    xmlns:android="http://schemas.android.com/apk/res/android"    android:orientation="vertical"    android:layout_width="fill_parent"    android:layout_height="fill_parent"    android:gravity="center_horizontal"    >  <pl.droidsonroids.gif.GifImageView      android:id="@+id/test1"      android:layout_width="wrap_content"      android:layout_height="wrap_content"      />  </LinearLayout>

3. MainActivity.java

public class MainActivity extends AppCompatActivity {

    GifImageView gifImageView;    /** Called when the activity is first created. */    @Override    public void onCreate(Bundle savedInstanceState) {
        super.onCreate(savedInstanceState);        setContentView(R.layout.activity_main);
        gifImageView = (GifImageView)findViewById(R.id.test1);        gifImageView.setImageResource(R.drawable.icons_animation);
    }
}