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 :
Thank you ;)
ReplyDeleteHi
ReplyDeleteI tried ur coding.I have got an error that the variables "items" and "is" can not be resolved.Where it should be declared.
Both items & is are Global Variable. like:
Deletepublic class mainActivity extends Activity{
public ArrayList items = new arrayList();
String is;
@Override
public void onCreate(Bundle savedInstanceState)
// rest of all code
}
}
Thank you.But when the app starts i encounter this error
ReplyDelete05-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
You have added internet permission in android manifest file??
Deletehttp://stackoverflow.com/questions/2378607/what-permission-do-i-need-to-access-internet-from-an-android-application
Can you please tell the declaration for sb and result? Thanks!
ReplyDeleteresult is String, is = input stream....
DeleteThis comment has been removed by the author.
ReplyDeleteI'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