Re: [PHP] Some kind of checksum From: Mike Eheler (meheler <email protected>)
Date: 10/15/01

md5 :)

"SELECT * FROM table WHERE MD5(blob_field) = '" . md5($filecontents) . "'"

Or even less strenuous on the server, alter the DB so it has a
varchar(32) field, call it 'md5sum' or something:

"SELECT * FROM table WHERE md5sum = '" . md5($filecontents) . "'"

Which would have been created by doing:

"INSERT INTO table (blob_field,md5sum) VALUES ('$filecontents','" .
md5($filecontents) . "')"

Mike

Boget, Chris wrote:

>I'm using MySQL and that is the context with which I write
>this email.
>
>I have a buch of text files that I want to add to a database so
>we can add all kinds of search functionality for those files.
>Each would be stored in either a TEXT or BLOB field. These
>files can have all kinds of special characters ( ", ', etc) so it
>would be necessary that I use addslashes().
>
>What I would like to do is make it so that I can check to see if
>the file has already been added to the database. I'm having a
>problem where if the text is too large, I can't query to see if the
>contents of the current file equals the contents of the field I'm
>storing it in. Is there any way that I can do some kind of
>checksum on both the contents of the file and the contents of
>the field to determine if that file has already been added? I'm
>trying to make it so that I don't have duplicate files in the DB.
>Has anyone done something like this?
>
>Chris
> 

-- 
PHP General Mailing List (http://www.php.net/)
To unsubscribe, e-mail: php-general-unsubscribe <email protected>
For additional commands, e-mail: php-general-help <email protected>
To contact the list administrators, e-mail: php-list-admin <email protected>