mysql - php filectime returns an error -

i trying make site in display digital movies own. working on page scan movies directory , read each movie in there , extract name , insert mysql database.

i need pull creation date file , insert well. yet when searched here on os tried examples find , errors of them , cannot figure out error coming from. need format creation date way fits format in mysql database.

i working on windows based machine.

code:

include("config.php");  echo '<ul>'; if ($handle = opendir('m:/movies/')) {  while (false !== ($entry = readdir($handle))) {     if ($entry != '$recycle.bin' && $entry != 'system volume information' && $entry != '.' && $entry != '..') {     $replace = array(".avi",".mkv",".mp4");     $title = str_replace($replace, "", $entry);     $exists = mysql_query('select * `mdw_movies` `title` "'.$title.'%"');     $exists1 = mysql_num_rows($exists);         if ($exists1 == 0) {             $date = date('y-m-d', filectime($entry)); // line 15             $query = "insert `mdw_movies` (`title`) values ('".$title."')";             mysql_query($query);             print "<li>inserted movie <b>".$title."</b> (<b>".$date."</b>).</li>";         }     } } } echo '</ul>'; 

error:

warning: filectime(): stat failed assassin's creed - embers.mp4 in c:\xampp\htdocs\movies\read.php on line 15 

i found answer after awhile of reading through php manual on filectime. missing directory listing file in filectime() function.

here correct code people reference:

include("config.php");  $dir = 'm:/movies/';  echo '<ol>'; if ($handle = opendir($dir)) {  while (false !== ($entry = readdir($handle))) {     if ($entry != '$recycle.bin' && $entry != 'system volume information' && $entry != '.' && $entry != '..') {     $replace = array(".avi",".mkv",".mp4");     $title = str_replace($replace, "", $entry);     $exists = mysql_query('select * `mdw_movies` `title` "'.$title.'%"');     $exists1 = mysql_num_rows($exists);         if ($exists1 == 0) {             $date = date('y-m-d', filectime($dir.$entry));             $query = "insert `mdw_movies` (`title`,`posted`) values ('".$title."','".$date."')";             mysql_query($query);             print "<li>inserted movie <b>".$title."</b> (<b>".$date."</b>).</li>";         }     } } } echo '</ol>';