Mapping binary data into the filesystem

[Rudi Menter]

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
--

[Andy Hassall]

Re: Mapping binary data into the filesystem

On Tue, 7 Nov 2006 15:10:49 +0100, Rudi Menter <spamcowgirl@sp amgourmet.com>
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?

PHP can read and write to the filesystem:

http://uk.php.net/manual/en/ref.filesystem.php

It can also communicate with MySQL:

http://uk.php.net/manual/en/ref.mysql.php

--
Andy Hassall :: andy@andyh.co.u k :: http://www.andyh.co.uk
http://www.andyhsoftware.co.uk/space :: disk and FTP usage analysis tool

[Chung Leong]

Re: Mapping binary data into the filesystem


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
--

See http://fi.php.net/stream-wrapper-register/

[Rudi Menter]

Re: Mapping binary data into the filesystem

Chung Leong 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
>--

>
See http://fi.php.net/stream-wrapper-register/

Wow, that's quite interesting,

thx a lot,
Regards
--

[Jerry Stuckle]

Re: Mapping binary data into the filesystem

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?

--
=============== ===
Remove the "x" from my email address
Jerry Stuckle
JDS Computer Training Corp.
jstucklex@attgl obal.net
=============== ===

[Rudi Menter]

Re: Mapping binary data into the filesystem

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
--

[Jerry Stuckle]

Re: Mapping binary data into the filesystem

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().

The main problem you will run into is the file size. The default memory
limit for PHP is 8M. 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.


--
=============== ===
Remove the "x" from my email address
Jerry Stuckle
JDS Computer Training Corp.
jstucklex@attgl obal.net
=============== ===

[Rudi Menter]

Re: Mapping binary data into the filesystem

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
>>>appropriat e 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,
--