|
|
Posted by Rudi Menter on 11/07/06 21:25
Am Tue, 07 Nov 2006 16:05:24 -0500 schrieb Jerry Stuckle:
> Rudi Menter wrote:
>> Jerry Stuckle write:
>>
>>
>>>Rudi Menter wrote:
>>>
>>>>Hi, I would like to store binary data (as data-type blob) in
>>>>a (MySql-) database, so I require functionality that allows
>>>>a mapping from and back into the filesystem. Now, is there
>>>>a library for this task that you know of?
>>>>
>>>>Thx,
>>>>Regards
>>>
>>>No library I know of. It's not that hard to do. Just have a column in
>>>your database which has the equivalent filename and search for the
>>>appropriate one. i.e. if you were mapping "/members/memberpage.html",
>>>just have a field with that string in it. Then you can easily search
>>>for the string.
>>>
>>>Or am I missing something here?
>>
>>
>> For instance, I'd like to
>> 1) convert, say, a file 'explorer.exe' into a string, say, $blobbdata
>> 2) store that in a blob of a database, which is straightforward
>> 3) reread that, from the database into a string, say, $blobbdata
>> 4) convert $blobbdata into a file, say 'explorer.exe', (and execute it)
>>
>> Sounds easy, no! ;)
>>
>> Regards
>
> Not hard at all. Just read the file with fread() in binary mode.
> INSERT it into your database with an appropriate key (i.e. 'explorer.exe');
>
> When you want it, SELECT the blob from your database into a string. If
> it's an executable, you'll need to write it to disk in binary mode, then
> execute it with exec().
Aha...
> The main problem you will run into is the file size. The default
> memory limit for PHP is 8M.
I cee.
> You can change that in your php.ini file if necessary.
> Alternatively, you can split the file into blocks and store
> it in multiple rows with a sequence number.
Thank you!
Regards,
--
Navigation:
[Reply to this message]
|