Em Andamento

PHP & MySQL Database Record Merging Across multiple tables

I have a database which contains a table that stores projects such as Movies, Television Shows, Theatre, Music Videos etc. In a series of other tables, there is information stored that relates to each of these projects, such as who the producers are, who the director is, the date that the project starts, the location etc. This information is linked via a foreign key field.

Our database contains many duplicates of the same projects. For example, the same TV show might be in the database 3 separate times - but some records might contain more information than others.

I would like to create a module in PHP that will allow the user to find duplicate projects and merge them. The merge would essentially gather all of the information associated with the projects, delete any replications, update only ONE of the projects and delete the rest. There are approximately 5 other tables that contain data which is linked to the projects table.

There should be a landing page that allows the user to "confirm" before the merge & delete occurs.

Habilidades: Programação de Banco de Dados, HTML, MySQL, PHP, Arquitetura de software

Ver mais: php mysql email record created, php mysql attendance record, php mysql jquery record search, php mysql subtract record, php mysql add record datagrid, php mysql update record, php mysql delete record, php mysql retrieve record summaries links record details, php mysql edit record script, php mysql compare record, php mysql edit record form script, php mysql edit record, php mysql copy record, php mysql overwrite record, create multiple choice quiz using php mysql tables

Acerca do Empregador:
( 9 comentários ) Beverly Hills, United States

ID do Projeto: #15379179

Premiar a:

wcliffe

I can create this in PHP, with applicable tests, within two days. Relevant Skills and Experience Expert PHP developer for 15 years. Over 20 years of RDBMS experience. Operated two companies that specialized in custom Mais

$155 USD em 3 dias
(0 Avaliações)
0.0

15 freelancers estão ofertando em média $170 para este trabalho

WebInfoSolutions

I saw the sample record attached in the image. Can you please confirm the expected output? Relevant Skills and Experience PHO Dev Proposed Milestones $210 USD - End

$210 USD in 3 dias
(182 Comentários)
7.7
hoangvandungbk

hello. i can help you check database. marge and remove duplicate data. please vontact with me to start.

$166 USD in 2 dias
(392 Comentários)
7.3
webXpart

Hi, I checked your project details and checked the attachment. Please come online and give me the php files and databases so i can start working. Relevant Skills and Experience Please check my profile at freelancer - Mais

$208 USD in 3 dias
(54 Comentários)
6.7
swapnilchavan18

I can do as per screenshot and description of project for records merging, lets chat Relevant Skills and Experience php mysql Proposed Milestones $150 USD - Initial Milestone

$150 USD in 3 dias
(67 Comentários)
6.4
ruwanjayawardena

[url removed, login to view] A Nice Day! I read your project details.I can build PHP MySQL script for find duplicates and merge info into one and reset delete .Please Send me a [url removed, login to view] can discuss more Thank you Relevant Skills and Ex Mais

$166 USD in 3 dias
(30 Comentários)
5.9
dlbinfotech

I have checked your job details carefully regarding to hire an expert PHP & MYSQL guru for accomplished the work of your existing Database Record Merging Across multiple tables. Relevant Skills and Experience http://w Mais

$200 USD in 2 dias
(22 Comentários)
4.7
janggang

Hi, I have reviewed your job post carefully, your job is very matched to me. I have many good skills and experiences about jquey, mysql, php and etc. so, I can do your job perfectly. Best regards Relevant Skills and E Mais

$155 USD in 3 dias
(14 Comentários)
4.0
ajay786singh

I am having 8 years of experience and I can do your job. Please let me know when to start... Relevant Skills and Experience PHP, MYSQL Proposed Milestones $155 USD - Final

$155 USD in 2 dias
(8 Comentários)
3.2
veanturait

A highly Experienced Team of developer and Desiger with advance expertise. We provide Web and Application Design and Development for PHP & MySQL Database Record Merging Across multiple tables Relevant Skills and Exp Mais

$31 USD in 3 dias
(1 Comentário)
3.1
$155 USD in 3 dias
(2 Comentários)
3.1
freestar1987

I am an expert of Database Management with MySQL. I am free for you now. I will immediately start to work and provide you full service when you award me. Looking to your reply Relevant Skills and Experience MySQL prog Mais

$277 USD in 3 dias
(0 Comentários)
0.0
Chafaa

A proposal has not yet been provided

$222 USD in 2 dias
(0 Comentários)
0.0
LuisJProgrammer

I can help you with optimizing your database by developing php code to find duplicate data, and adding options in the program so you can decide what to do Relevant Skills and Experience I can develop, modify and / or Mais

$50 USD in 2 dias
(0 Comentários)
0.0
$250 USD in 0 dias
(0 Comentários)
0.0