GSoC/GCI Archive
Google Code-in 2012 The Fedora Project

Task A07 – Implement Interface and Logic for tbl_Accounts

completed by: KenDhia

mentors: bckurera

Design an interface with controllers (No need of formatting with CSS just use controllers).

Form Title : Add new Account

1.  Field Name - Account Name

1.  Value – String of 50 characters with only alphabetic characters.

2.  Field Name – Description

1.  Value – String with 100 max.

3.  Field Name – Valid Till

1.  Value – Date (yyyy/mm/dd)

4.  Field Name – Valid From

1.  Value – Date (yyyy/mm/dd)

5.  Field Name – Account Type

1.  Value – Capital, Income, Expenses, Liabilities, Assest

6.  Field Name – Remarks

1.  Value – Text


Then refer to https://fedoraproject.org/w/uploads/1/12/ER_Model.PNG for the tbl_Accounts table. Using PHP develop a script that fetch entered values from the designed interface and store in tbl_Accounts table. Data validation should be performed in both interface level and script level.

Valid Till and Valid From should be in above format on the form but in the script it should be converted to PHP timestamp and store which is a INT 10 value after conversion.