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

Veja mais: php mysql email record created, php mysql attendance record, php mysql jquery record search, how to fetch data from database in php with multiple tables, how to fetch data from two tables in mysqli using php, php mysql select from multiple tables, fetch data from multiple tables with php and mysql, how to select data from two tables in mysql php, how to fetch data from two tables in mysql using php, how to retrieve data from multiple tables in mysql, how to fetch data from two tables in mysql without join, cms, php, software testing, mysql, css, html, website design, software development, website testing

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

ID do Projeto: #15379179

12 freelancers estão ofertando em média $168 para esse trabalho


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
(200 Comentários)

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

$166 USD in 2 dias
(406 Comentários)

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
(56 Comentários)

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
(56 Comentários)

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
(68 Comentários)

[login to view URL] 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 [login to view URL] can discuss more Thank you Relevant Skills and Ex Mais

$166 USD in 3 dias
(32 Comentários)

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
(19 Comentários)

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)

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)

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)

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)
$250 USD in 0 dias
(0 Comentários)