Blobbing Data With PHP and MySQL (Devarticles)

Showing how to store and retrieve binary data in a MySQL database by using PHP. -
[Read more]
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.
[Read more]