RE: [PHP] file storing in mysql db column mediumblob

From: Date: Tue, 24 Oct 2000 13:33:37 +0000
Subject: RE: [PHP] file storing in mysql db column mediumblob
References: 1  Groups: php.general 
Request: Send a blank email to php-general+get-21829@lists.php.net to get a copy of this message
Is it possible I am having problems because the filesize is too big? Files under 100k is cool, above this the script doesn't work? D. -----Original Message----- From: Daniel Convissor [mailto:danielc@analysisandsolutions.com] Sent: dinsdag 17 oktober 2000 15:54 To: PHP List Subject: Re: [PHP] file storing in mysql db column mediumblob Heya Dominick: > How can I store a file content, size and name in a mysql db? Does anyone > have a good example? You're best off not storing the file itself, rather store the file path/name. Anyway, create the table with a blob column type to store the file, check out the PHP manual for filesize() and fread(). Insert the results of those two functions in your db. Enjoy, --Dan -- PHP scripts that make your job easier http://www.analysisandsolutions.com/code/ SQL Solution | Layout Solution | Form Solution T H E A N A L Y S I S A N D S O L U T I O N S C O M P A N Y 4015 7 Ave, Brooklyn NY 11232 v: 718-854-0335 f: 718-854-0409 -- PHP General Mailing List (http://www.php.net/) To unsubscribe, e-mail: php-general-unsubscribe@lists.php.net For additional commands, e-mail: php-general-help@lists.php.net To contact the list administrators, e-mail: php-list-admin@lists.php.net

« previous php.general (#21829) next »