Help using filesize() function

[foxclone]

I'm trying to get the filesize() of a file based on a retrieval of filename from the database. The file is located in the download directory and the code calling the function is in the root of the website. Here's the code I've tried:

$test = $pdo->query("SELECT filename FROM files WHERE id =1");
   $isoname = $test->fetchColumn();
   $test = "download/".$isoname;
   $isosize = filesize($test)/1000000;

It always returns zero although is returns the correct filename.

 

Thanks for any guidance in advance.

[gw1500se]

I'm guessing there is a problem with the path. Make sure you have error reporting turned on.

error_reporting(E_ALL);

 

[MadTechie]

gw1500se is probably correct here, 

Quick update

$test = $pdo->query("SELECT filename FROM files WHERE id =1");
$isoname = $test->fetchColumn();
$test = "download/".$isoname;
if(!file_exists($test))  die("File missing:".$test); //<--added for testing
$isosize = filesize($test)/1000000;

 

Might be a path update like

$test = __DIR__."/download/".$isoname;

 

[dodgeitorelse3]

is the filename from files table stored with file extension?