在图像目录中循环访问

Question

我需要遍历.png图像目录并将文件名插入到mysql数据库中。

这是我到目前为止有：

mysql_connect('localhost', 'admin', ''); 
mysql_select_db('database'); 

// Each file is formated like this 
$file = 'Abe+Froman+SK_HG.png'; 

$player_name = urldecode(str_replace("_HG.png", "", $file)); 
//echo $player_name; 

mysql_query("INSERT IGNORE INTO signatures SET gamertag = '".$player_name."'"); 

Answer 1

使用opendir通过它打开一个目录，并readdir循环：

<?php 
// From the manual entry for opendir 
$dir = "/etc/php5/"; 

// Open a known directory, and proceed to read its contents 
if (is_dir($dir)) { 
    if ($dh = opendir($dir)) { 
     while (($file = readdir($dh)) !== false) { 
      //Do your sql insert - the filename is in the $file variable 
     } 
     closedir($dh); 
    } 
} 
?> 

Answer 2

做的另一种方式是与glob它允许你如果其他文件也存在于同一目录中，则只选择png图像。

foreach (glob("*.txt") as $filename) { 
    $player_name = urldecode(str_replace("_HG.png", "", $filename)); 
    mysql_query("INSERT IGNORE INTO signatures SET gamertag = '".$player_name."'"); 
}