Closed

small MYSQL and PHP web page programming project

This project received 21 bids from talented freelancers with an average bid price of $152 USD.

Get free quotes for a project like this
Employer working
Skills Required
Project Budget
$30-$250 USD
Total Bids
21
Project Description

INTRODUCTION:

I'm looking to find someone to work with me, to help me with a small MYSQL and PHP web page programming project - I'd like to learn how to write a simple PHP/MYSQL program and web page and understand how all the pieces work. You will be on your own to develop the programming and web page, I will supply the data and the needed functionality. Once you complete the project, we will need to meet online via SKYPE and you will need to walk me though the program and web page and explain how everything works - so you will need good English skills and a SKYPE account.

You will be supplied with:
1) a hosted web account at [url removed, login to view] to use as the development site with PHP and mySQL installed
2) CVS data files and table descriptions for the OLD db and the NEW db


TASK DESCRIPTION:

There is an old database and a new database, the data (most of it I think?) has been migrated from the old db to the new db, I'd like to develop a simple PHP/mySQL program and web page to explore the OLD data set and the NEW data set to see how well the migration process went.

new data set ---------> test it against ----------> old data set
------------------------------------------------------------------ -----------------------------------------------------------------
(newID, fname, mname, lname, birthday, phone) (oldID, fname, mname, lname, birthday, phone)


I'd like to end up a SUMMARY REPORT

OLD DB records: xxxxxx
NEW DB records: xxxxxx
-------------------------------------
Difference: xxxxxxx

(There are 5 possibles field that can be matches: fname, mname, lname, birthday, phone - I'd like to know how many records match on less than 2 fields (1 or none), ONLY 2 fields, ONLY 3 fields, ONLY 4 fields, and ONLY 5 fields - i.e. a record could only fit into ONE of these categories)

total OLD db records matching on 5 fields of NEW db: xxxxx
total OLD db records matching on 4 fields of NEW db: xxxxx
total OLD db records matching on 3 fields of NEW db: xxxxx
total OLD db records matching on 2 fields of NEW db: xxxxx
total OLD db records matching < 2 fields of NEW db : xxxxx
-------------------------------------------------------------------------
total OLD db records: xxxxx


I'd also like a DETAIL REPORT with matching data in green, and non matching data in red

---------------------------------------------------------
total OLD db records matching on 5 fields: xxxxx in this case (5 matching) ALL data would be green
----------------------------------------------------------
[ oldID, newID ] fname, mname, lname, birthday, phone

---------------------------------------------------------
total OLD db records matching on 4 fields: xxxxx in this case (4 matching) data would be green (1 non matching) would be red
----------------------------------------------------------
[ oldID, newID ] fname, mname, lname, birthday, phone

---------------------------------------------------------
total OLD db records matching on 3 fields: xxxxx in this case (3 matching) data would be green (2 non matching) would be red
----------------------------------------------------------
[ oldID, newID ] fname, mname, lname, birthday, phone

---------------------------------------------------------
total OLD db records matching on 2 fields: xxxxx in this case (3 matching) data would be green (2 non matching) would be red
----------------------------------------------------------

---------------------------------------------------------
total OLD db records matching on < 2 fields: xxxxx in this case either 0 or 1 would be matching (green) and either 4 or 5 would be non matching (red)
----------------------------------------------------------

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