Build a report using MySQL and PHP to be completed within 2 weeks

The full list of assets and tools: We will provide: MySQL database Approximately 500mb Around 160 fields An Excel file detailing the MySQL database fields will explain the purpose of each table and row of the database. Infusionsoft tags, capture form, specific fields, payment system, email automation Wordpress development environment to test and host the scripts. Report page layout & design You will provide: Script to generate reports from the provided MySQL database onto Wordpress pages Infusionsoft API scripting to check values within the Infusionsoft database Scripting to validate and direct first time or returning visitors Dynamically generated report page to print within Wordpress Any necessary validation scripts (php or jquery) Using the provided database (mysql) create the necessary scripts (php) to generate a web page report. The database (about 500mb) has already been imported to MySQL and will be provided as a .sql export file. The scripts you are building should run independant of any other web framework. The final product will run on a Wordpress website but should not be dependant on Wordpress. We will use Infusionsoft as a lead capture for this project. An Infusionsoft form will request: First Name Email Address Phone Number Postal Code Infusionsoft will then automatically send an email confirmation to the customer which will have a link to the reporting tool you are building. This link will provide their email address and the postal code. Your script will use the Infusionsoft API to look up if the details provided in the URL are the same as what is reflected in the Infusionsoft database. *Note: The first generated report for any email address for free. But any additional requested reports after the first will require payment. The method of checking this is through Infusionsoft tags and the postal code field in Infusionsoft for the specific email address. If the email address is not found, redirect to the initial signup page. If the email address is valid, but the postal code is not existing, then redirect to the initial signup page. If the email address and postal code are valid and the same, proceed forward. If the email address is valid but postal code are not the same check if the visitor has paid: If the customer has already paid, proceed forward. If the customer has not paid then redirect them to a payment screen (we will provide). See Attached Document for full detail. Must be reviewed prior to placing proposal. The dynamically generated report page layout will be provided. It may be your responsibility to finalize any html, css or jquery. EXAMPLES Find good examples either on your own or by other peoples websites. The initial Infusionsoft capture form on this home page is similar to what ours will look and function: [login to view URL] Layout for the report will be provided at the time of an agreement. Expect it to involve 4 data tables with 5 - 10 columns each. Rows will be dynamic based on zip code. Some of the columns will be aggregate data calculated from the database. When placing a proposal expect this piece to have revisions. The Infusionsoft API is well documented and for what we are doing is very easy to access. Here is the developer starting for for reference: