Apache cordova dengan mysql database

PhoneGap PHP MySQL Example

In this article, I would like to write an article about PhoneGap with PHP & MySQL.we’ll see how to perform CRUD [Create, Read, Update, Delete] operations with MySQL Database.

Step By Step Guide:

• MySQL Database Creation
• Writing PHP code for Serverside
• Writing Jquery code for PhoneGap / Apache Cordova side

Dependencies: PHP, MySQL, JQuery

Learn More about PHP & MySQL //www.w3schools.com/php/php_mysql_intro.asp or //www.tutorialspoint.com/php/php_and_mysql.htm

Working with MySQL database

Let’s create a new table called course details where, we can store information about courses such as title, duration, and price.we also need to set primary key & auto increment for id

CREATE TABLE `course_details` [

`id` int[1] NOT NULL, 
`title` varchar[25] NOT NULL, 
`duration` varchar[50] NOT NULL, 
`price` varchar[10] NOT NULL

] ENGINE=InnoDB DEFAULT CHARSET=latin1 AUTO_INCREMENT=1 ; 

ALTER TABLE `course_details` ADD PRIMARY KEY [ `id` ]; 
ALTER TABLE `course_details` MODIFY `id` int[1] NOT NULL AUTO_INCREMENT;

After creating a new table, we need to create simple REST API

Working with PHP code

Let’s create a simple API [no security layer added] for fetching data from MySQL database & display as JSON.here we’re going to create multiple files for insert, delete, update operations. If you want you can merge all files into one single PHP file

Connecting Database Server [ db.php ]

This file allows you to connect your MySQL database

NOTE

header["Access-Control-Allow-Origin: *"]; use to allow cross domains

Insert data into MySQL database using PHP [ insert.php ]

This code will receive data from the mobile / PhoneGap Apache Cordova using POST method & It’ll insert data to MySQL, If it is successful it will return ok as output otherwise error as output