Khalilo D & D

phonegap-cordova-login-system Phonegap login system (cordova login) using php & mysql:  In this tutorial, we’re going to build  simple login system  using phonegap with php and mysql backend. Creating database for storing user data ( mysql ) Creating Login page for authenticate existing user Creating Signup page for add new user account Database design for phonegap login system First we need to create database for storing new user’s data such as userid, full name, email address and password. CREATE TABLE `users` ( `userid` int(1) NOT NULL, `fullname` varchar(50) NOT NULL, `email` varchar(50) NOT NULL, `password` varchar(50) NOT NULL ) ENGINE=InnoDB DEFAULT CHARSET=latin1 AUTO_INCREMENT=1 ; ALTER TABLE `users` ADD PRIMARY KEY (`userid`); ALTER TABLE `users` MODIFY `userid` int(1) NOT NULL AUTO_INCREMENT; After creating database, we need to write a php code for validating new user. we’re going to validate user based on email address. if email address...

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  http://www.w3schools.com/php/php_mysql_intro.asp  or  http://www.tutorialspoint.com/php/php_and_mysql.htm Download Source Code 1. MYSQL DATABASE CREATION In this example, I’m going to create some basic database & table (course_details) with following fields such as id, title, price. 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 ; A...