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

  • Status Completed
  • Budget $250 - $750 USD
  • Total Bids 24

Project Description

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.


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: [url removed, login to view]

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:

Get free quotes for a project like this
Completed by:

Looking to make some money?

  • Set your budget and the timeframe
  • Outline your proposal
  • Get paid for your work

Hire Freelancers who also bid on this project

    • Forbes
    • The New York Times
    • Time
    • Wall Street Journal
    • Times Online