Selective list of dir contents

[israfel]

I want to get every file in a directory except files who's filename matches the value of a mysql table.

Here's what I have so far that just gets everyting in a directory.

$handle=opendir("items/");
$query=mysql_query("SELECT dbitemname FROM table");
$dbitems=mysql_fetch_array($query);
extract($dbitems, EXTR_OVERWRITE);
while (false!==($file=readdir($handle))) {
if ($file!="." and $file!=".." and !$dbitems[$file])) {
// echo or whatever, maybe I might want to add everything from into a database that isn't already there or print the stuff that isn't there to add it selectively, etc
}
}

The problem is the if case. To me that says it should display execute the code if an entry in the array by that name is not present. Instead it just outputs everything and gives me 'undefined index' errors for every entry in the array.

Can anyone tell me what I'm doing wrong?

[Anon]

Hi,

"$dbitems=mysql_fetch_array($query);" only catchs one row after the other with every call, so you have to recall this method:
while($dbitems = mysql_fetch_array($query)) {... } to access every entry

why do you use the extract function?? " extract($dbitems, EXTR_OVERWRITE);"

"$dbitems[$file]" would mean, that $file contains the name of a column in your database and you want to get the value of your actual row with that column. As you have no file named as your column name "dbitemname", you get an 'undefined index'. I guess, that's not what you want? 😉

Read some mySQL-PHP Tutorial, which describes mySQL-data-access.
e.g. http://www.selfphp.com/ It is in german but maybe regardless helpful with many examples