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: 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, 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

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)

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