I need a script that will allow us to input data into mysql database and be able to search that db.
Data input:
Allows input of first name, last name, address, phone #, email, date of birth into mysql. Level 1 password is required to input data. There could be a level 0 password where customers can input their own data as above but it would just sit in a “pending” section until someone with level 1, 2 or 3 password can approve it.
Simple search:
You enter the last 4 digits of phone # and/or first name and/or last name and it shows you all entries with that data. Only displays First name, Last name, last 4 digits of phone #, date joined. Level 2 password required for simple search.
Master search:
You enter the last 4 digits of phone # and/or first name and/or last name and it shows you all entries with that data. Will displays First name, Last name, address, phone #, email, date of birth, date joined. This search also allows you to set filters such as list all entries with birthday in a specified time frame (example: July birthdays, birthdays in the next 40 days, specified zipcode etc). Once filter is created, an email can be generated and sent to all emails on the list. Level 3 (master) password required for master search.
Security:
Level 1, 2 & 3 security password needed. Script should be limited to only specified IP addresses.
Please note that I will not be able to give you access to my ftp or mysql for security reasons. You will have to give me a finished script & mysql file and I can install them myself.