ajloun
02-21-2010, 09:16 PM
Hello
I use this Code to List Files in My director .. I need to inser the Name of the Files into Mysql ..
How So ..this wht i tried and did not work ..
$dir = 'images/';
if ($dh = opendir("$dir")) {
$files = array();
while (($file = readdir($dh)) !== false) {
if ($file == "." or $file == ".." or $file == "Thumbs.db" or $file == "index.php" or $file == "index.html" ){
continue; }
$files[] = $file; }
$files_num=count($files);
echo " we found".$files_num." file<br><hr>";
$counter=0;
while($counter<$files_num){
echo" $files[$counter]<br>";
$counter++;
} }
///
$sql = "INSERT INTO test_tble (title) VALUES ('$files[$counter]')";
$ret = mysql_query($sql);
if (!$sql){
echo "<center>err</center>";
}else{
echo "<center>ok</center>";
}
I use this Code to List Files in My director .. I need to inser the Name of the Files into Mysql ..
How So ..this wht i tried and did not work ..
$dir = 'images/';
if ($dh = opendir("$dir")) {
$files = array();
while (($file = readdir($dh)) !== false) {
if ($file == "." or $file == ".." or $file == "Thumbs.db" or $file == "index.php" or $file == "index.html" ){
continue; }
$files[] = $file; }
$files_num=count($files);
echo " we found".$files_num." file<br><hr>";
$counter=0;
while($counter<$files_num){
echo" $files[$counter]<br>";
$counter++;
} }
///
$sql = "INSERT INTO test_tble (title) VALUES ('$files[$counter]')";
$ret = mysql_query($sql);
if (!$sql){
echo "<center>err</center>";
}else{
echo "<center>ok</center>";
}