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

Completado Publicado Jul 30, 2014 Pagado a la entrega
Completado Pagado a la entrega

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:

MySQL PHP Redacción de informes Plantillas WordPress

Nº del proyecto: #6253739

Sobre el proyecto

20 propuestas Proyecto remoto Activo Aug 8, 2014

Adjudicado a:

marketingmindz

We've already worked with Vebralive, Amazon, CoinPayment, Stripe and Amazon API and would able to build a respond using MySQL and PHP using Infusionsoft API. We've gone through Infusionsoft API document and pretty m Más

$526 USD en 10 días
(136 comentarios)
8.5

20 freelancers están ofertando un promedio de $555 por este trabajo

zeke

Dear Customer! I am an expert PHP developer with over 6 years of experience and very interested to work on this project. Available to start immediately and finish as soon as possible. My bid is for fast professional s Más

$515 USD en 20 días
(199 comentarios)
7.5
JonnaNueros121

Consider it done professionally, Thanks .........................................................................................

$750 USD en 12 días
(235 comentarios)
7.4
SuiGenSolutions

Dear Sir, We are the globalized software services organization specialized in providing Mobile, ECommerce and Social media frameworks using cutting edge and emerging technology. Leveraging best-in-class people, process Más

$525 USD en 11 días
(94 comentarios)
6.8
VnBestSolutions

Dear Sir. We claim to get it done perfectly for you EXACTLY in the way you want it - Kindly give we a chance and we will prove myself - Ready to prove our words, let's get it done right away and I mean RIGHT AWAY !! Más

$631 USD en 10 días
(185 comentarios)
6.8
sheak

Quality writer at your service,please consider my bid for high quality work on time. Hi, Are you little worried and finding freelancer for your task, i am here to deliver beyond your expectations. Award me project with Más

$526 USD en 10 días
(151 comentarios)
7.2
LIMEXS

Hi there, I can do it if you like. Sir we're a small team of developers with our local business in Melbourne, have have served dozens of clients locally and globally, we pride our self at quality of work we do, and we Más

$650 USD en 6 días
(53 comentarios)
6.3
Handyman84

Hi My name is Ema and I'm leading a team of young and creative web designers and web developers, and I believe that every site or project it's different in it's own way, that's why a custom strategy/design must be appl Más

$481 USD en 14 días
(11 comentarios)
6.1
ibbuzz

Hi there! We have just read your project task. We are really interested in your project. Kindly check our profile and ratings. Our work will be guaranteed. Thanks and regards!

$555 USD en 10 días
(88 comentarios)
5.8
steffinjoseph

Sir, I am very good at your requirement. Ready to start immediately. Trust and try once it will never go waste. Awaiting to hear back soonest. Thank you

$250 USD en 10 días
(19 comentarios)
5.1
fabiomenza

Hi, I read through your specifications and I can do this project in less then 2 weeks for 400$. Let me know if you are interested in my bid. Kindly regards, Fabio

$400 USD en 12 días
(2 comentarios)
2.3
kangen333

With more than 15 years' combined writing experience, Kangen Solutions consistently provides insightful and engaging copy that will engage with your audience. We make it our priority to follow guidelines and meet deadl Más

$515 USD en 10 días
(6 comentarios)
2.6