Connect to MYSQL remote server database using PHP and display ListView

This article describes how to create/access a MYSQL database in a remote server from Android using PHP and display it on a ListView. Because most online tutorials did not show the full process or all source code, I decided how to create a fully functional prototype. Currently you can see my JSON objects by going to this link: http://www.ece301.com/food.php which accesses my database and extracts the information. This article uses Cpanel, php and Android API 2.1.
Continue reading

SSL Sockets Android and server using a certificate

This article describes how to create a secure socket from an android device to a server using a certificate. It explains how to create a key that Android can use, write a secure server socket, a client socket and send information back and forth between them.

First we can start by downloading the apk file for android and the jar file for your computer (server) along with the correct secure certificate and another certificate to test that other certificates will not work. Download link: http://ece301-examples.googlecode.com/files/ssl_sockets.zip

First I will go through the steps so you can see a working example before looking at the code.
Continue reading