Build a website using Perl and MySQL

Project Requirements (website) (ver. b): Overview: We need a website that will: 1) Display the website in a eye pleasing format. 2) Allow a user to register so they can access our 'entity' database. 2a) The new user will be prompted to enter their data into a form, then the server will send a verification e-mail to their e-mail address with an embedded link. Upon clicking the embedded link they can then access the website. This should be fully automatic. 3) Once a user is logged in they will be able to query the database 10 times for free within 30 days. If they exceed 10 queries then they must wait for 30 days to elapse from their most recent query. 4) The user has the option of using PayPal or to send us a check so they can perform more queries. 5) If the user has money on deposit, then each match from the query (after the 10 free ones) will debit $0.50USD from their balance. Before displaying (or sending the data) the number of matches should be displayed in a pop-up window with the total amount for this query and their balance, asking them if they want to continue if so then the data will be displayed. 5) Everything the user does (free or registered) needs to be saved into a "use" database. this means their IP address, location (using IP), time, and the parameters they use when performing their query. 7) The "user" database containing the user information needs to be be easily modified using forms or a GUI interface. There are three MySQL database's: 'user' - this has the information on registered users. 'entity' - this is our main database with data on various companies. 'use_log' - this logs the user id, and related information. ------------- Please see attached file for all details. Please note: I really need the basic website up and running - yesterday. The ability to query the database is not critical - within 2 weeks. thanks for your bid! ## Deliverables Project Requirements (website) (ver. b): Overview: We need a website that will: 1) Display the website in a eye pleasing format. 2) Allow a user to register so they can access our 'entity' database. 2a) The new user will be prompted to enter their data into a form, then the server will send a verification e-mail to their e-mail address with an embedded link. Upon clicking the embedded link they can then access the website. This should be fully automatic. 3) Once a user is logged in they will be able to query the database 10 times for free within 30 days. If they exceed 10 queries then they must wait for 30 days to elapse from their most recent query. 4) The user has the option of using PayPal or to send us a check so they can perform more queries. 5) If the user has money on deposit, then each match from the query (after the 10 free ones) will debit $0.50USD from their balance. Before displaying (or sending the data) the number of matches should be displayed in a pop-up window with the total amount for this query and their balance, asking them if they want to continue if so then the data will be displayed. 5) Everything the user does (free or registered) needs to be saved into a "use" database. this means their IP address, location (using IP), time, and the parameters they use when performing their query. 7) The "user" database containing the user information needs to be be easily modified using forms or a GUI interface. There are three MySQL database's: 'user' - this has the information on registered users. 'entity' - this is our main database with data on various companies. 'use_log' - this logs the user id, and related information. ------------- When a user registers for access I would like it to work like: [login to view URL] ------------- The Query function should work like this one: [login to view URL] Main Field: "Legal Name" If "Add a Filter" is clicked then a category box opens with a drop down menu. "Stock Symbol" with a box to the right where the user can enter the symbol code. "State" with a box to the right where the user can enter the State-Terriority code (no drop down box). "Country" with a drop down box to the right where the user can select the Country code. "CUSIP" with a box to the right where the user can enter the CUSIP code which is checked for correct format. "ISIN" with a box to the right where the user can enter the ISIN code. "LEI (CICI)" with a box to the right where the user can enter the CICI code. "CEO Last Name" with a box to the right where the user can enter the last name of the CFO. "CFO Last Name" with a box to the right where the user can enter the last name of the CFO. "Description" with a box to the right where the user can enter all or part of a description. If "Add a Filter" is clicked once again then the above process repeats. This allows the user to drill down and limit the matches. Note: We may add 2 or 3 more fields to the above list. The columns returned as a result of the queries are pre-defined. Please see: Database [login to view URL] The match on the "Legal Name" and "Description" should match on the full or partial field. All other fields must match in full. ------------- The general look and feel for the website should look like this: [login to view URL] Note: It can not be a exact copy. ---------- I have created the content for the freely accessible web pages. I would like to have these webpages up and running by Monday 9/17/2012. Please see: webpages [login to view URL] --------- The website must be coded in Perl. The database must be MySQL.