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

SQLite database

This article describes how to create a project using an SQLite database. Most online tutorials show how to input one value. Here I will create a database of users with three values: first name, last name and age. This is then displayed in a ListView. This article includes adding and deleting users, using a Cursor, dynamically loading data to a ListView and using an AlertDialog to input user information.
Continue reading