Page History

PHP changes

1. Combine DB Change all db references to new structure and combine calls as much as possible (currently 22, try for 1-4).
2. Remove absolute server links and make relational if possible.
3. Add a namespace and remove all global vars, unless specifically needed.
4. Separate presentation from functionality. Controller page and then include the html needed for that view. View functionality like repeating table rows can go in the view page, any logic needs to stay in the php page. All formatting and layout of the view should be in the html/css.
5. Organize the php and move vars to the top of the section
6. Securely screen Add security for all incoming form data, and then sql screen filtering before sending to db.
7.  

Files to changethat have db references and need to be updated

1. request_form.php
2. confirmation.php
3. admin/index.php
4. admin/actions.php
5. admin/feed/index.php
6. dashboard\includes\approve\cur_fis_year.php *
7. dashboard\includes\approve\cur_month.phpphp *
8. dashboard\includes\approve\cur_year.phpphp *
9. dashboard\includes\approve\past_30days.phpphp *
10. dashboard\includes\approve\past_week.phpphp *
11. dashboard\includes\length\cur_fis_year.phpphp *
12. dashboard\includes\length\cur_month.phpphp *
13. dashboard\includes\length\cur_year.phpphp *
14. dashboard\includes\length\past_30days.phpphp *
15. dashboard\includes\length\past_week.phpphp *
16. dashboard\list_results.phpphp *
17. dashboard\results.phpphp *

* Dashboard area does not need to be updated since it is non-functional now and will be completely re-written later.