BLOB file in MySql, can I attach to an email?

[LLLLLLL]

On MySQL 5.1.47, PHP 5.2.14

 

I have some PDFs stored in a database as BLOBs. Using PHP code, how can I attach these BLOBs to an email?

[Mchl]

Yes you can

[LLLLLLL]

Right... could you provide an example of how to do this? Is it necessary to turn the BLOB into a file and then attach it, or can the BLOB be attached directly?

[Mchl]

It can be attached directly. How exactly, depends on how you're sending your mails.

[LLLLLLL]

Hello again.

 

I had planned on using the standard "mail" function:

mail($to, $subject, $message, $from);

 

[LLLLLLL]

I've looked all around for the answer on this, and I still cannot find it. I'm most confused about getting the file out of the database and turning it into a stream of data to attach. fread() and fopen() don't work because they require file paths.

:'(

[fenway]

There must be countless tutorials on this -- no different than an image.

[LLLLLLL]

There really aren't. I've looked everywhere, and I only asked here because there was nothing to find.

 

As it is, I'm now using PHPMailer to attach real files -- not storing files in the database.

[fenway]

Then you don't know where to look -- see here.