Create / customize and install php script and sql dbase which will create, maintain, search and produce output of sql database variables.
To access report
Create account - fb login, email address, username, password
All new accounts – access level 2
admin acess changes account level
Login
“Welcome to admin panel”
Admin options
Log - Log all access attempts - date, ip, username
Assign/change admin rights - 1 - enter data [s4 personnel], 2 - users [access, browse, print], 3 - all priviliges [delete users, make dbase changes - very few people]
Create Record -- > opens form input screen
Delete Record
Edit Record
Create Record [30 input fields]
Search Function
Search on 9 variables
Search will produce list of cases
Click on case to find details
Output Report 1 [admin rights 1 only]
Date report generated
Display all input fields for all entries
'Print report'
'Email report'
Output Report 2
Date report generated
Display list of cases by search criteria showing: [search on multiple variables also]
[all variables]
'Print report'
'Email report'