Closed

small MYSQL and PHP web page programming project

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)

----------------------------------------------------------

Skills: MySQL, PHP

See more: write php small project, help programming project php mysql, web programming learn online, web page php develop, web page development online, web for learn php programming, web development programming, web development online project, web development learn online, to learn programming, test your php skills, site to learn programming, site to find programming work, site for learn programming on c# online, project development site, program site web, programming works online, programming via web, programming test online, programming project help, programming learn, programming c++ web, php mysql online help, online task programming, online programming test in c++

About the Employer:
( 48 reviews ) East Lansing, United States

Project ID: #4383518

18 freelancers are bidding on average $149 for this job

netdevbiz

The requirements are understood. Only one question data from old db and new db both are in Mysql or one of them is in CSV or in a delimited file?

$150 USD in 3 days
(74 Reviews)
7.5
jsr3

I understand your requirements and ready to start right now. Please check your message box for more details.

$210 USD in 7 days
(49 Reviews)
6.2
leomedina01

Hi sir, your explanation is rather confuse. Could you please provide me some examples woth some sample data? I'm an experienced Web Developer having worked for 5+ years with PHP, Java, Solr/Lucene, Sphinx Search, Smar More

$99 USD in 3 days
(47 Reviews)
5.7
Eswar87

Hi , I can easily do this job and start right away. Please check PM. Thank you, Regards, Eswar

$100 USD in 2 days
(30 Reviews)
5.6
cakephp2012

HI im expert php/mysql and DBA optimisation ,i can help you and will available on skype most of time. please check your PM.Thanks.

$247 USD in 3 days
(6 Reviews)
5.6
spalshmedia

Hello, I'm applying my proposal for your job I'll provide you work with 100% satisfaction Please review my portfolio and Feel free for disucss on budget and choose me.

$144 USD in 3 days
(2 Reviews)
4.1
sirajcse

Dear Sir I have experience in PHP/MySQL for more then 8 years. I can help you.

$140 USD in 6 days
(21 Reviews)
3.8
khanzakir

Hi, Php/Mysql developer with 5+ yrs experience. Please check my reviews and you will see that my client like the way I communicate.

$200 USD in 3 days
(9 Reviews)
3.8
pranotosh

Hi, I'm a Web-developer and i can do your job well because i have already teach one about codeigniter.I have a lot of experience on PHP,MySql,HTML,Javascript [url removed, login to view] consider my bid and let me start asap. Than More

$110 USD in 5 days
(14 Reviews)
3.7
prakashmondal

Hi, I am interested to make a SUMMARY REPORT with starting right now. Please see my PM. Thanks Prakash

$157 USD in 1 day
(16 Reviews)
3.3
BZim

This project looks fairly simple - pull data from two different databases and look for matches. The only trouble is explaining everything. Yes, I can explain what each line does but it would be very difficult for you t More

$210 USD in 5 days
(4 Reviews)
3.0
codejamer

Ready to start right now.........please consider my bid........

$120 USD in 5 days
(7 Reviews)
2.7
jasqwerty

Hello, I'm a native English speaker with extensive technical experience. I have a degree in Comp Sci and have worked in the industry on lots of backend sql projects. I can get the site done for you in a few days then w More

$250 USD in 5 days
(1 Review)
2.7
santosoftvw

Dear Sir, Dear Sir, I have 6 years work experience in software development using Java, Zend PHP, jQuery (Javascript), Ajax, CSS, XHTML. I will develop your application as required. I will develop the UI using XHTML, C More

$50 USD in 4 days
(5 Reviews)
2.0
erani

I am ready to start working on it.

$132 USD in 3 days
(1 Review)
1.2
yakob

hi, I'm software engineer with experience in PHP, SQL, CSS, javascript. I did many projects before like this one. So don't hesitate to contact with me. I will be helpful with you and will learn you any thing you need

$176 USD in 3 days
(0 Reviews)
1.0
hawkitsolution

Hi, Hawk it solution is a group of professionals with resources who are experienced and committed towards Work. Our resources expertise in a wide skill set ,which matches your requirement . We understand what yo More

$170 USD in 5 days
(0 Reviews)
0.0
ejazsaeed46

i will ready to help you . my latest product [url removed, login to view] Hope you give me chance to work with u. Take care.

$140 USD in 7 days
(0 Reviews)
0.0
mahmoud91

Hi,I can help you

$140 USD in 7 days
(0 Reviews)
0.0
ashu1459

Hello.I will do this . Please check PM.

$200 USD in 10 days
(0 Reviews)
0.0