Jump to content


Photo

Joining Blobs?


  • Please log in to reply
1 reply to this topic

#1 seanlim

seanlim
  • Members
  • PipPipPip
  • Advanced Member
  • 355 posts
  • LocationLondon, United Kingdom

Posted 08 December 2005 - 05:01 PM

Hi all.

i am storing files into a mysql database with a php script. i know its not the best method but it'll do for now.

the php script breaks up the file into 512kb chunks for inserting into the database. i use several UPDATE queries to add to the blob field. however, the files are always corrupted when i join them back together.

i think its because of the way i update the field. i use the MySQL CONCAT function now.

any help here? i need it urgently..

thanks!!

#2 fenway

fenway
  • Staff Alumni
  • MySQL Si-Fu / PHP Resident Alien
  • 16,199 posts
  • LocationToronto, ON

Posted 24 December 2005 - 02:58 AM

I usually just stream the binary data out -- check out [a href=\"http://php.dreamwerx.net/forums/viewtopic.php?t=6\" target=\"_blank\"]this excellent tutorial[/a].
Seriously... if people don't start reading this before posting, I'm going to consider not answering at all.




0 user(s) are reading this topic

0 members, 0 guests, 0 anonymous users