[Honeybun]

Keep it short and simple.

Doc 1 is a list of names and artists, it looks like this -




Doc 2 is a list of names and artists, it looks like this -



I need to cross reference these. If Doc 1 has something that doc 2 doesn't, I need a flag. Vice Versa.

Any way to do this? I've been doing it by hand. It's 2400 songs long and it'll take months if I don't find a work around..

note: doc 1 is also a mysql database, if that helps any.

[Nachfolger]

Why not just run a loop against them using PHP? It won't be hard, especially if doc 2 is a text file.

[Honeybun]

Why not just run a loop against them using PHP? It won't be hard, especially if doc 2 is a text file.

Not incredibly skilled with php, got a tut for something like this or some pointers?

[Nachfolger]

Not incredibly skilled with php, got a tut for something like this or some pointers?

Sure. Start with grabbing everything from the database, then use a loop to check if the line from the DB is in the text file.

PHP Code


<?php
// Doc 1
$doc1 = Array(); // Grab the DB lines
// Doc 2
$file = file_get_contents('somefile.txt');

// Loop through DB 
foreach($doc1 as $line) {
 $pattern = "/^.*$pattern.*\$/m";
 if(!preg_match_all($pattern, $file, $line)){
    echo "<br>Document 2 does not contain " . $line;
 }
} 


Taken and modified from https://stackoverflow.com/questions/3686...whole-line

I'm extremely hungry and my code usually contains errors when I'm hungry so just brace for that. The concept is pretty simple, so just follow it when building the script.