How the application work PHP & Android

How the application works -- PHP & Android

• The android application uses Java HTTP

private void insertToDatabase(final String truncate, final String sec, final String x,final String  y, final String z,final String lat, final String lon, final String datetime, final String alt){
    class SendPostReqAsyncTask extends AsyncTask<String, Void, String> {
        @Override
        protected String doInBackground(String... params) {

            try {
                List<NameValuePair> nameValuePairs = new ArrayList<NameValuePair>();
                nameValuePairs.add(new BasicNameValuePair("truncate", truncate));
                nameValuePairs.add(new BasicNameValuePair("sec", sec));
                nameValuePairs.add(new BasicNameValuePair("x", x));
                nameValuePairs.add(new BasicNameValuePair("y", y));
                nameValuePairs.add(new BasicNameValuePair("z", z));
                nameValuePairs.add(new BasicNameValuePair("lon", lon));
                nameValuePairs.add(new BasicNameValuePair("lat", lat));
                nameValuePairs.add(new BasicNameValuePair("datetime", datetime));
                nameValuePairs.add(new BasicNameValuePair("macid", value));
                nameValuePairs.add(new BasicNameValuePair("altitude", alt));
                HttpClient httpClient = new DefaultHttpClient();
               HttpPost httpPost = new HttpPost("https://x.000webhostapp.com/x.php");
                httpPost.setEntity(new UrlEncodedFormEntity(nameValuePairs));

                HttpResponse response = httpClient.execute(httpPost);

                HttpEntity entity = response.getEntity();

            } catch (ClientProtocolException e) {

            } catch (IOException e) {

            }
            return "Transfer Successful";
        }

        @Override
        protected void onPostExecute(String result) {
            super.onPostExecute(result);
           
        }
    }
    SendPostReqAsyncTask sendPostReqAsyncTask = new SendPostReqAsyncTask();
    sendPostReqAsyncTask.execute(sec,x,y,z,lon,lat,datetime,alt);
}

• In the PHP i receive the data from andriod

$truncate = $_POST['truncate'];
$sec= $_POST["sec"];  
$x= $_POST["x"];  
$y= $_POST["y"];  
$z= $_POST["z"];  
$datetime= $_POST["datetime"];  
$lat= $_POST["lat"]; 
$lon= $_POST["lon"]; 

$macid= $_POST["macid"]; 
$alt= $_POST["altitude"]; 

 
if($macid == "")
{
	if($truncate == "1")
	{
	$sql_query = "truncate table x";   
	$results = $conn->query( $sql_query );
	}
	else
	{
	$sql_query = "insert into x(sec,x,y,z,datetime,lat,lon,altitude) values('$sec','$x','$y','$z','$datetime','$lat','$lon','$alt')";   
	$results = $conn->query($sql_query);
	}
}
else
{
if($truncate == '1')
	{
	$sql_query = "DROP TABLE IF EXISTS ".$macid;   
	$results = $conn->query( $sql_query );
	}
	else
	{	
	$sql_query="CREATE TABLE IF NOT EXISTS ".$macid."(sec text, datetime text, x text, y text, z text, lat text, lon text,altitude text)";
	$results = $conn->query( $sql_query );
	
	$sql_query = "insert into " .$macid. "(sec,x,y,z,datetime,lat,lon,altitude) values('$sec','$x','$y','$z','$datetime','$lat','$lon','$alt')";   
	$results = $conn->query( $sql_query );
	}
}