Compare directory list to dbase and print difference

Inpresif

Hi all,

I have this little code:

<?
include ("global.php");

$movie = "movie";
$images_found = array();
$dir = "/" . $content_dir . "/";
echo $dir;

$images = array();
$fileArr = array();

$dbi = mysql_connect ("$hostName", "$userName", "$password");
mysql_select_db($databaseName);

function getFiles($dir) {
    $d = opendir($dir);

if($d) {
   while (false !== ($file = readdir($d))){
	    if(($file!=".") && ($file!="..") && (!ereg("[!|\(|\)|\?|@|%|&|\*|;|,|~|\{|\}]",$file)))
        {
           	if (@is_dir($dir.$file)){
			$pad = $dir.$file."/";
			echo "<BR>dir plus file = ".$pad;
           	$fileArr[] = $pad;
			getFiles($pad);
			}
		}	

   }
   closedir($d);

   }
   return $fileArr;

} // close func


$result = mysql_query("SELECT path FROM sets WHERE movie != '$movie' ORDER BY path");

while($row = mysql_fetch_assoc($result)){

if(in_array($row["path"], $fileArr)){
   //do the stuff to show because it has been added
   echo " added";
}else{
   // do the stuff to show it hasn't been added
   echo " not added yet<br>";
}

}

getFiles($dir);

?>

What I need is to be able print out all the files on my server that are not yet in the database. Any idea how I can have those printed in the echo " not added yet<br>"; sections?

I've been fighting this for quite some time now, I really would appreciate the help.

The format of the path in my database is:
/usr/home/domain/content/

The same format gets printed now as for the files being on my server.

Thanks!!

s_shrum

Here's what I'd do (don't know if this is the right way)

Dump the contents of the DIR to a temp table. Then do a duplicates search against the temp table and your table singling out the ones that are not duplicates and therefore not in the table (SQL "ON DUPLICATE").

With the results that came back you could do a 1-liner INSERT of all the new records into your table.

HTH

Inpresif

Ok, I am not familiar with that SQL command, but I will look into it, I can always dump my directories in a temp table and drop it when done with it. I only have to store the data I manually click once displayed.

It sounds a little like 'beating a round the bush', but it is the best alternative I've heard so far. Not to mention the only usefull one :p

Inpresif

I was doing some research and came across this bit:

$colors = array("red", "green", "blue", "orange", "yellow");
$search = array("red", "green", "teal", "purple");
$matches = array_intersect($colors, $search);
foreach($matches as $val){
    $id=array_search($val, $colors);
    unset($colors[$id]);
}

Might it be easier to use a variation like this? Store the directorylisting, as well as the database result in an array and compare. Print the ones that are not duplicate and voila ?

I would only have to search for an array that just searches for the values NOT in both arrays 🙂