Blobbing Data With PHP and MySQL
(Page 1 of 7 )
It seems that the latest and greatest use for databases is storing large amounts of binary data, known as BLOB's. These BLOB's can store just about any type of data imaginable, including MS Word documents, GIF/JPEG images, PDF files, MP3's, etc. In this article Mitchell shows us how to create a binary file repository using PHP and MySQL that can store and retrieve several different file types.It seems that the latest and greatest use for databases is storing large amounts of binary data, known as BLOB's. These BLOB's (Binary Large Objects) can store just about any type of data imaginable, including MS Word documents, GIF/JPEG images, PDF files, MP3's, etc.
In this article we're going to take a look at how to create a binary file repository using PHP and MySQL that can store several different file types. We will look at how to store each files binary data in a database, and then how to retrieve it... all using PHP.
To test the examples in this article, you should have access to an Apache/IIS server running PHP and MySQL. I will assume that you have administrative rights to create the MySQL databases, and that MySQL is on the same server as PHP.
Next: Creating the database >>
More MySQL Articles
More By Mitchell Harper
