php check if file exist

Question

can someone guide me on how to do checking to tell if file already exist in database or not before we upload it?

i wanna upload a file into database, but before it save, i want to check whther file already exist first. if yes then dont do the insert execution.

i used this reference on uplaoding a files.

thank you very much.

Answer 1

I'm not sure if this is what you're asking, but have you used PHP's built in function, file_exists(ABSOLUTE-PATH-TO-FILE)?

$exists = file_exists('myfile.doc');
if(!$exists) {
// do your processing
}

http://php.net/manual/en/function.file-exists.php

If you're checking the database, then just query whatever column might hold your file, for example:

SELECT * FROM my-table WHERE my-column = 'my-uploaded-file-name';