“Collect All” To Make Professional Mobile Application in Flash Lite 1.1 Enable Device

[marlopax]

• Create a table in the same database named user_information.

• Create required columns named First Name, Last Name, Sex, Age, Country, Email ID, Date and userName.

• userName column will be same as you did in the login table with Primary Key.

• FirstName VARCHAR (40) user’s first name.

• LastName VARCHAR (50) user’s last name.

• Sex CHAR (10).

• Age TINYINT (2) Attributes “UNSIGNED”.

• Country VARCHAR (50).

• Email VARCHAR (50) user’s e-mail address.

• CreateDate DATE.


Storing Data into Database:

Storing data into database with php from Flash Lite 1.1 need the SQL code to INSERT into the database. The code bellow will generated from the phpadmin page from the localhost server page. You will get this option “Create PHP Code” after inserting a data from the Insert tab. You can follow both the code to know how php store data into the database table.

Table user_information:

$sql_01 = "INSERT INTO `db01sep2009mob_app`.`user_information` (`FName`, `LName`, `Age`, `Sex`, `Country`, `CreateDate`, `Email`, `userID`) VALUES (\'your first name\', \'your last name\', \'your age\', \'your sex\', \'your country\', \'date in this format 0000-00-00\', \'your email address\', \'your user name\');";

Table login:

$sql_02 = "INSERT INTO `db01sep2009mob_app`.`login` (`userID`, `Password`, `createDate`,`subscribe`) VALUES (\'your user name\', MD5(\'your password\'));";
The above code will insert the data into two tables in the database “db01sep2009mob_app”.


continue...

marlopax


Tuesday, January 26, 2010