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.