The plan was to 1) create a simple personal TODO application that can CRUD from multiple devices and 2) allow offline CRUD at Android and sync with the main database when the device connects to the internet.
The idea comes from the popular application "Wunderlist"
For the first part of the project (which is the easier part) I implemented two CRUDs in Laravel and Android.
Similar to Wunderlist, the application can be accessed from a web browser. This part was developed using Laravel. I started using the framework a week ago and I cannot believe how much I like it already. I never had an appetite for PHP before I came across Laravel.
Since it is a web app, it can be accessed from any device that is online. However the second part of the project also required creating and editing tasks while offline using an android device. Therefore, a separate CRUD application for android was developed. The database system that is native to Android is SQLite.
The database helper class:
The second part of the project will be to sync the SQLite Android database and the MySQL database in the server. I will have to do more research to accomplish that. Wait for Crud:2.