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

Closed

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:

Skills: MySQL, PHP, Report Writing, Templates, WordPress

See more: wordpress website building developer, wordpress mysql database developer, wordpress independant developer, wordpress development tools, wordpress developer tools, wordpress developer reference, what to look for in a wordpress developer, what is a project proposal, website development tools free, web page developer tool, web page design using html and css, web development using html 5, web developer tool wordpress, web developer free tools, web design tags list html, web design generate using php, web design automation wordpress, using wordpress as a developer, tool php developer, the method of web developer, require a html 5 website developer, proposal report for project, proposal layout examples, product design project report, php to excel export

Project ID: #6253739

Awarded to:

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 More

$526 USD in 10 days
(47 Reviews)
6.7

21 freelancers are bidding on average $554 for this job

cheapestandbest

Hi, We are an experienced team of highly skilled and rated designers and developers who can create an unique identity for your business through customized designs and developing websites. We provide the best design More

$515 USD in 14 days
(622 Reviews)
8.8
Softmania

Hi, Thank you for reading our application. Please know that our main area of expertise is Wordpress. Please see our portfolio here on the website, under our profile, also some links example below: a. http:/ More

$747 USD in 30 days
(392 Reviews)
8.6
wildCat

Hi, My name is Marat, I am CEO of WEB4PRO company located in Ukraine. We offer the services of web development on WordPress. In general, my developers possess PHP, JavaScript, SQL, MySQL, AJAX, jQuery/jQuery UI, p More

$526 USD in 10 days
(302 Reviews)
8.4
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 More

$515 USD in 20 days
(174 Reviews)
7.1
xazoo

Hello! We would love to do this project professionally, please reply back to discuss further. Looking forward to hear from you soon. Thanks!

$1000 USD in 20 days
(131 Reviews)
7.0
AndrewSmith22

Hello, Greetings from VAPTechDesigns. I've looked into your job post and understand that you are looking for an expert coder familiar with wordpress themes. I am very much interested to work in your project. I can as More

$666 USD in 25 days
(46 Reviews)
6.7
webzin

Welcome to Webzin Infotech, Thank you for taking time to review our bid, we are ready to start the project. For more details please refer our profile,portfolio and some of our recent sites listed with this messag More

$789 USD in 15 days
(59 Reviews)
6.4
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 More

$650 USD in 6 days
(34 Reviews)
6.2
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 More

$526 USD in 10 days
(70 Reviews)
6.2
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 !! More

$631 USD in 10 days
(74 Reviews)
6.2
momentumsoftware

Dear Sir, Warm Greetings !! We are a website designing and application development agency from New Delhi (India). Having a competent team size of 40 plus designers and developers, completed more than 200 big or More

$526 USD in 25 days
(132 Reviews)
6.1
JonnaNueros121

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

$750 USD in 12 days
(60 Reviews)
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 in 10 days
(73 Reviews)
5.5
maxpl

Hi, We can discuss price and time frame for this project. I have 5+ years of experience in webdesign/ development, WordPress, OperCart, E-commerce, Mobile Development, SEO and I have done number of projects. More

$631 USD in 12 days
(15 Reviews)
5.5
achieveseo

Hello, I am an 5 years experienced freelancer in the website design field and I have knowledge of various technologies like PHP, Joomla, Wordpress, Magento, CSS, Java Script, Ajax, jquery, Photoshop, this is why I am More

$539 USD in 13 days
(8 Reviews)
5.5
PankajGupta007

Hello, I have 7+ year experience in web development and 4 year experience mobile application development. I am new in freelancer but not fresher in IT industry please review my previous work:- Magento Project List More

$526 USD in 20 days
(32 Reviews)
5.2
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 More

$525 USD in 11 days
(24 Reviews)
5.1
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 More

$481 USD in 14 days
(5 Reviews)
4.7
swift555

A proposal has not yet been provided

$526 USD in 10 days
(15 Reviews)
4.3
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 in 10 days
(5 Reviews)
4.3