Completed

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

This project was successfully completed by marketingmindz for $526 USD in 10 days.

Get free quotes for a project like this
Employer working
Completed by:
Project Budget
$250 - $750 USD
Completed In
10 days
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.

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: [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:

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