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

Comments On: Blobbing Data With PHP and MySQL

· AM devolping a website in which am using PHP and MYSQL, and here any member can...    · this will not transfer the variable $_FILE. After a bit of research i found if you...    · Not seeing this "Support Material" I keep seeing.. Can someone direct me to it?    · I am on Apache 2.0 server. When I enter the grabfile page I do not see how the...    · I tried creating a generalized version for storing files into mysql, and retrieving...   >>> Post your comment now!