PHP changes
- Change all db references to new structure and combine calls as much as possible (currently 22, try for 1-4).
- Remove absolute server links and make relational if possible.
- Add a namespace and remove all global vars, unless specifically needed.
- Separate presentation from functionality.
- Organize the php and move vars to the top of the section
- Add security for all incoming form data, and then sql filtering before sending to db.
Files that have db references and need to be updated
- request_form.php
- confirmation.php
- admin/index.php
- admin/actions.php
- admin/feed/index.php
- dashboard\includes\approve\cur_fis_year.php *
- dashboard\includes\approve\cur_month.php *
- dashboard\includes\approve\cur_year.php *
- dashboard\includes\approve\past_30days.php *
- dashboard\includes\approve\past_week.php *
- dashboard\includes\length\cur_fis_year.php *
- dashboard\includes\length\cur_month.php *
- dashboard\includes\length\cur_year.php *
- dashboard\includes\length\past_30days.php *
- dashboard\includes\length\past_week.php *
- dashboard\list_results.php *
- dashboard\results.php *
* Dashboard area does not need to be updated since it is non-functional now and will be completely re-written later.