Hi, I've been trying to get this script to read a directory and then pass the
information into a Mysql table. I can open the directory and print it's contents, or
I can get other information from variables passed to the mysql table, but I can't seem
to do both. If you have any idea what I've done wrong or have an idea where I can
read more about this problem your thoughts will be greatly appreciated.
Sincerely,
Gavin Tong
<?php
$handle=opendir('.');
while (false!==($file = readdir($handle))) {
if ($file != "." && $file != "..") {
echo "$file\n";
}
}
closedir($handle);
$db = mysql_connect("local host", "person", "pasword");
mysql_select_db("photos",$db);
$result = mysql_query("insert into template (name) values ('$file')",$db);
?>