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:
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 :
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 :
