how to connect Android app and php mysql Connection

 how to connect Android app and php mysql Connection

In this Tutorial Today learn how to connect Android app and php mysql Connection follow this Stpes:

1.Open Notepad and type a php code

2. Open File C:XAMP/Htdocs/Create php File

3.CREATE DATABASE statement creates the database

Name Below Connection.php:

<?php

   $con=mysqli_connect("example.com","username","password");

   $sql="CREATE DATABASE my_db";

   if (mysqli_query($con,$sql)) {

      echo "Database my_db created successfully";

   }

?>

4.MainActivity.java:

 import android.os.AsyncTask;

        import android.support.v7.app.AppCompatActivity;

        import android.os.Bundle;

        import android.widget.ArrayAdapter;

        import android.widget.ListView;

        import android.widget.Toast;

        import org.json.JSONArray;

        import org.json.JSONException;

        import org.json.JSONObject;

        import java.io.BufferedReader;

        import java.io.InputStreamReader;

        import java.net.HttpURLConnection;

        import java.net.URL;

public class MainActivity extends AppCompatActivity {

    ListView listView;

    @Override

    protected void onCreate(Bundle savedInstanceState) {

        super.onCreate(savedInstanceState);

        setContentView(R.layout.activity_main);

        listView = (ListView) findViewById(R.id.listView);

        downloadJSON("http://192.168.25.102/Connection/connection.php");

    }

    private void downloadJSON(final String urlWebService) {

        class DownloadJSON extends AsyncTask<Void, Void, String> {

            @Override

            protected void onPreExecute() {

                super.onPreExecute();

            }

            @Override

            protected void onPostExecute(String s) {

                super.onPostExecute(s);

                Toast.makeText(getApplicationContext(), s, Toast.LENGTH_SHORT).show();

                try {

                    loadIntoListView(s);

                } catch (JSONException e) {

                    e.printStackTrace();

                }

            }

            @Override

            protected String doInBackground(Void... voids) {

                try {

                    URL url = new URL(urlWebService);

                    HttpURLConnection con = (HttpURLConnection) url.openConnection();

                    StringBuilder sb = new StringBuilder();

                    BufferedReader bufferedReader = new BufferedReader(new InputStreamReader(con.getInputStream()));

                    String json;

                    while ((json = bufferedReader.readLine()) != null) {

                        sb.append(json + "\n");

                    }

                    return sb.toString().trim();

                } catch (Exception e) {

                    return null;

                }

            }

        }

        DownloadJSON getJSON = new DownloadJSON();

        getJSON.execute();

    }

    private void loadIntoListView(String json) throws JSONException {

        JSONArray jsonArray = new JSONArray(json);

        String[] stocks = new String[jsonArray.length()];

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

            JSONObject obj = jsonArray.getJSONObject(i);

            stocks[i] = obj.getString("name") + " " + obj.getString("price");

        }

        ArrayAdapter<String> arrayAdapter = new ArrayAdapter<String>(this, android.R.layout.simple_list_item_1, stocks);

        listView.setAdapter(arrayAdapter);

    }

}

5.activity_main:

<RelativeLayout xmlns:android="http://schemas.android.com/apk/res/android"

    xmlns:app="http://schemas.android.com/apk/res-auto"

    xmlns:tools="http://schemas.android.com/tools"

    android:layout_width="match_parent"

    android:layout_height="match_parent"

    tools:context="net.simplifiedlearning.androidjsonparsing.MainActivity">

 

 

    <!-- listview to display our stocks --> 

    <ListView

        android:id="@+id/listView"

        android:layout_width="match_parent"

        android:layout_height="match_parent"

        android:layout_alignParentLeft="true"

        android:layout_alignParentStart="true"

        android:layout_alignParentTop="true" />

 

</RelativeLayout>

6.Mainefaist:

<?xml version="1.0" encoding="utf-8"?>

<manifest xmlns:android="http://schemas.android.com/apk/res/android"

    package="com.java2blog.helloworldapp">

    <uses-permission android:name="android.permission.INTERNET" />

 

    <application

        android:allowBackup="true"

        android:icon="@mipmap/ic_launcher"

        android:label="@string/app_name"

        android:supportsRtl="true"

        android:theme="@style/AppTheme">

        <activity android:name=".HelloWorldActivity">

            <intent-filter>

                <action android:name="android.intent.action.MAIN" />

 

                <category android:name="android.intent.category.LAUNCHER" />

            </intent-filter>

        </activity>

    </application>

 

</manifest>