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.

Kemahiran: Pengaturcaraan Pangkalan Data, HTML, MySQL, PHP, Kejuruteraan Perisian

Lihat lagi: php mysql email record created, php mysql attendance record, php mysql jquery record search, php mysql subtract record, php mysql add record datagrid, can upload multiple image php mysql database, 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, sending flash data php mysql database flash cs3, php mysql database creator, php mysql database query script, php mysql database webpage examples, post ajax php mysql database, php mysql database load script, parse xml php mysql database, upload video php mysql database, php mysql database remote

Tentang Majikan:
( 16 ulasan ) Beverly Hills, United States

ID Projek: #15379179

12 pekerja bebas membida secara purata $168 untuk pekerjaan ini


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 dalam 3 hari
(200 Ulasan)

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

$166 USD dalam 2 hari
(406 Ulasan)

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 Lagi

$200 USD dalam 2 hari
(56 Ulasan)

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 - Lagi

$208 USD dalam 3 hari
(56 Ulasan)

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 dalam 3 hari
(68 Ulasan)

[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 Lagi

$166 USD dalam 3 hari
(32 Ulasan)

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 Lagi

$155 USD dalam 3 hari
(19 Ulasan)

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 dalam 2 hari
(8 Ulasan)

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 Lagi

$31 USD dalam 3 hari
(1 Ulasan)

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 Lagi

$277 USD dalam 3 hari
(0 Ulasan)

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 Lagi

$50 USD dalam 2 hari
(0 Ulasan)
$250 USD dalam 0 hari
(0 Ulasan)