Simple Databaase Interface website - PHP Codeigniter
Budget: $30 – $250 USD
I need a simple website that will serve as a postgresql database interface. There are only 3 tables on this database (provinces, districts, and facilities). The user will have to be able to add, delete and modify all records.
* It must be written in PHP using the Codeigniter framework
* User/Session management is required so users must login
-> There is a table called users in the database_structure_only file provided. You can use that table for the user management/session but I am open if you have another table structure that you can re-use.
* I have purchased and will provide a Codeigniter template that must be used. (https://themeforest.net/item/minible-codeigniter-admin-dashboard-template/28535533)
* The 3 tables are linked via external keys. The external keys should be available via dropdowns. Here is the hierarchy structure
|->provinces
| ----->districts
| --------->facilities
So to create/modify a new district record the website must display a dropdown with all provinces so the district record is linked to a province. To create a facilites record the website must display a dropdown with all provinces once the user selects a province another dropdown with all districts linked to the selected province must be loaded and only after the user selects the district they can save the record.
* It must be written in PHP using the Codeigniter framework
* User/Session management is required so users must login
-> There is a table called users in the database_structure_only file provided. You can use that table for the user management/session but I am open if you have another table structure that you can re-use.
* I have purchased and will provide a Codeigniter template that must be used. (https://themeforest.net/item/minible-codeigniter-admin-dashboard-template/28535533)
* The 3 tables are linked via external keys. The external keys should be available via dropdowns. Here is the hierarchy structure
|->provinces
| ----->districts
| --------->facilities
So to create/modify a new district record the website must display a dropdown with all provinces so the district record is linked to a province. To create a facilites record the website must display a dropdown with all provinces once the user selects a province another dropdown with all districts linked to the selected province must be loaded and only after the user selects the district they can save the record.