array_diff problems

vaska

hmmm...i'm trying to read a directory and then compare the results with a table in the db...so, obviously, then i can input the html files into the db...

i'm getting an error message that says -

"Warning: Argument #1 to array_diff() is not an array in ...path/index.php on line 21"

line 21 is the "$output..." line...

the search on the directory is working just great...it's returning the results i want...

suggestions?

if ($handle = opendir('.')) {
while (false !== ($file = readdir($handle))) {
if ($file != "." && $file != "..") {
echo "<a href=\"$file\">$file</a>\n";
}
}
closedir($handle);
}

///// db connection info...

$query = mysql_query ("SELECT * FROM temp" ) or die ("Unexpected error for MySQL database [3b]");
$row_html = mysql_fetch_array($query);

$output=array_diff($file,$row_html);

Weedpacket

My guess would be that the problem is that $file is not an array; and it wouldn't be, it's only a string (containing, as it happens, the last filename in the directory listing.)
Immediately after the echo line have a line saying $files[]=$file;

Then use $files in your array_diff.

PyroX

$handle=opendir('.') or die("Cannot Open Dir");

while ($file=readdir($handle)) {

if ($file != "." && $file != "..") {
echo "<a href=\"$file\">$file</a>\n";
$files[]=$file;
}
}
closedir($handle);

$query = mysql_query ("SELECT * FROM temp" ) or die ("Unexpected error for MySQL database [3b]");
$row_html = mysql_fetch_array($query);

$output=array_diff($files,$row_html);

vaska

ok...i wondered about that and i tried that but then it didn't work...so i thought it was something else...argh...

that worked though...

but i'm not getting the correct results at all...i think my query is wrong...i'm trying to get ONLY the html files that DO NOT show up in the db...

i'm starting to get completely mixed up now...am i going in the right direction?

thanks W...jv

Weedpacket

Well, yes; unless all your files are in a single row in the temp() table... you'll need to loop through all the records returned by the query, and fetch their contents into the $row_html array, much the same way you build up the array of files.

vaska

woops...spoke too soon...

the results...it's just returning the info from the db...if a file exists in the directory but not in the db, it's not showing up...

is this really what i should be using to display the outputs?

<? echo $row_html['html']; ?> shouldn't it be something like...
<? echo $output['files']; ?>

another thing...is there an issues with HOW the array_diff works? does it check ALL the records or just in a specific order...argh...how do i say this?

does it check like this
1 -> 4
2 -> 12

or does it check 1,2 against all resultss in the db?

would something like array_assoc be better?

thanks...jv

vaska

in my test dir i have...

52.html
53.html
55.html
61.html

in my test db i have...

53.html
54.html
61.html

when i do the queries i should get...

52.html
55.html

but i'm getting

53.html
54.html
61.html

?????

this is what i am using to get the info...

<? echo $row_html['html']; ?>

help?

thanks...jv