Using sha1_file() to idenify files

@HellgYNov 10.2006

Hi, I’m working on a upload-download system, i was wondering if i can run a query with the sha1 hash of the file the user is trying to upload, and that upon the results, either save the path to the file and the hash in the db, or redirect the user to an existent file.

Thanks to all helpers

to post a comment

PHP

@bokehNov 10.2006 — #Yeah of course you can. I use that model for 304 responses, although without the DB. Make the checksum column unique and try to do the insert, if the query fails the file has already been uploaded at some previous time so should not be saved. Also MD5 will be fine and use less space in the DB. [code=php]$checksum = MD5(file_get_contents($_FILES[$fieldname]['tmp_name']));[/code]

@HellgYauthorNov 10.2006 — #Yeah of course you can. I use that model for 304 responses, although without the DB. Make the checksum column unique and try to do the insert, if the query fails the file has already been uploaded at some previous time so should not be saved. Also MD5 will be fine and use less space in the DB. [code=php]$checksum = MD5(file_get_contents($_FILES[$fieldname]['tmp_name']));[/code][/QUOTE]
Yeah, i already set the hash column as unique, what was the function again you

recommended to that guy with the registration form in order to display customized error message?.

I might have more then one unique field in the table.

@bokehNov 10.2006 — #

[code=php]if(mysql_query($INSERT_query))
 {
 # success
 }
 else
 {
 $error = mysql_error();
 if(preg_match('/keys*(d+)/i', $error, $match))
 {
 echo 'Duplicate entry on UNIQUE KEY '.$match[1];
 }
 else
 {
 # some other problem
 }
 }[/code]

[I]$match[1][/I] will hold a number. For the PRIMARY KEY that number will be 1. For each additional KEY column that increases by one so the first UNIQUE column after the PRIMARY KEY will be 2 etc.

Using sha1_file() to idenify files

3 Comments(s) _↴

Also in #PHP _↴

Success!

Social

Version

Using sha1_file() to idenify files

3 Comments(s) ↴

Also in #PHP ↴

Success!

The web is an endless sea of information. Don't miss the boat... Subscribe!

Social

Version

3 Comments(s) _↴

Also in #PHP _↴