I have a project that needs to accomplish the following.
The site is a real estate/home buying site. Our users are real estate agents that are located through out the USA. What we need is a form processor that does the following.
1. Writes the visitors query to a database.
2. Checks to see if the postal code in the visitors query matches a postal code assigned to an agent.
3. Forwards the query to the matching agent via email.
4. Forwards the query to admin via email.
Agents will have multiple postal codes assigned to them (maybe an administration console that allows postal codes separated by commas).
Admin console should allow for the following entered.
First Name, Last Name, Company, Address, City, State, Postal Code, ***Postal Codes Assigned***, Phone Number, ***Email Address to be used to forward visitor query***, Notes
Admin console should also allow for writing queries to database that is sortable and exportable to csv.
There will only be one admin and users will not have access to the backend console. Admin will be manually entering agent info as new agents are added.
Should be written in PHP and MYSQL.
PMB with any questions. Thanks!
PMB me with any questions.