Skip to main content

Connecting mysql Database in ANDROID using PHP & JSON

 To implement this tutorial you should have basic knowledge of how to run PHP script and start server.  If we talk about client-server architecture, client is Android device and in server side there is a combination of PHP Script and MySQL. In short, PHP Script sits in middle as shown in image.



Lets suppose that we have a MySQL database named Employee, and a table int created, with the following SQL:



CREATE TABLE `employee` (
  `emp_id` int(11) NOT NULL auto_increment,
  `emp_name` varchar(100) NOT NULL,
  PRIMARY KEY  (`emp_id`)
) ENGINE=InnoDB  DEFAULT CHARSET=latin1 AUTO_INCREMENT=5 ;


The PHP code will be very simple:



Now Create Android Project : 


The Android part is only a bit more complicated:
-use a HttpPost to get the data

-convert response to string
-parse JSON data in to List



In Your First Activity :



O/P :





Comments

  1. Hi
    I tried ur coding.I have got an error that the variables "items" and "is" can not be resolved.Where it should be declared.

    ReplyDelete
    Replies
    1. Both items & is are Global Variable. like:

      public class mainActivity extends Activity{

      public ArrayList items = new arrayList();
      String is;

      @Override
      public void onCreate(Bundle savedInstanceState)
      // rest of all code
      }

      }

      Delete
  2. Thank you.But when the app starts i encounter this error
    05-21 17:11:58.115: E/log_tag(410): Error in HTTP connectionjava.net.SocketException: Permission denied
    05-21 17:11:58.146: E/log_tag(410): Error in convert Stringjava.lang.NullPointerException

    ReplyDelete
    Replies
    1. You have added internet permission in android manifest file??

      http://stackoverflow.com/questions/2378607/what-permission-do-i-need-to-access-internet-from-an-android-application

      Delete
  3. Can you please tell the declaration for sb and result? Thanks!

    ReplyDelete
  4. This comment has been removed by the author.

    ReplyDelete
  5. I've managed to make the program work. However, I seem to encounter an unexpected error. What is shown on the browser when I run the php file separately also shows when I run the application on my Android phone. Any thoughts on what may be the cause? Thanks!

    ReplyDelete

Post a Comment

Popular posts from this blog

Android show Data from Sqlite DB into Grid View

Shaadi.com Matrimonials Shaadi.com Indian Matrimonials Your Main Activity class package com . Sqlite_grid_view ; import java . util . ArrayList ; import java . util . List ; import android . app . Activity ; import android . os . Bundle ; import android . util . Log ; import android . view . View ; import android . widget . AdapterView ; import android . widget . AdapterView . OnItemClickListener ; import android . widget . ArrayAdapter ; import android . widget . GridView ; import android . widget . TextView ; import android . widget . Toast ; public class AndroidSQLiteTutorialActivity extends Activity { private GridView gridView ; public static ArrayList < String > ArrayofName = new ArrayList < String >(); /** Called when the activity is first created. */ @ Override public void onCreate ( Bundle savedInstanceState ) { super . onCreate ( savedInstanceState ); setContentView ( R . l...

Android Material Design - 3 (Android RecyclerView and CardView)

Android Lollipop features two new widgets to make your life easier,    RecyclerView      and   CardView . Download full example on  Github . RecyclerView This widget is a container for displaying large data sets that can be scrolled very efficiently by maintaining a limited number of views. Use the  RecyclerView  widget when you have data collections whose elements change at runtime based on user action or network events. The RecyclerView and CardView both are available in the Android support library, to use support library in android studio. your app root folder -> right click -> open module setting -> select your module -> select dependence tab -> click on + sign -> Library dependence, add both library. com.android.support:recyclerview-v7:22.1.1 com.android.support:cardview-v7:22.1.1 now create layout for RecycleView : <RelativeLayout xmlns:android="http://schemas.android.com/apk/res/and...

Android - Better alternative of expandable listview

This is alternate solution of Expandable ListView Android.  Your Main Activity Class: package com.example.my_demo; import java.util.ArrayList; import android.app.Activity; import android.os.Bundle; import android.view.Menu; import android.view.View; import android.view.View.OnClickListener; import android.view.ViewGroup; import android.widget.AdapterView; import android.widget.AdapterView.OnItemClickListener; import android.widget.ArrayAdapter; import android.widget.Button; import android.widget.ListAdapter; import android.widget.ListView; import android.widget.Toast; public class MainActivity extends Activity { private Button btn1; private Button btn2; private ListView list1; ArrayList<String> a = new ArrayList<String>(); public boolean LI1 = false; public boolean LI2 = false; public boolean LI3 = false; private ArrayAdapter<String...