putting a word doc in a mysql db?

[monomaniac21]

This one has been bugging me for months everytime i've tried i've had
to give up and do something else. Anyone know how to do this, any help
would be much appreciated.

I think that I need to use a blob field is that correct? But from then
on im stuck.

Kind regards

Marc

[janrom1]

monomaniac21 wrote:

This one has been bugging me for months everytime i've tried i've had
to give up and do something else. Anyone know how to do this, any help
would be much appreciated.

I think that I need to use a blob field is that correct? But from then
on im stuck.

Kind regards

Marc

yes, you have to use blod. You have to read file into any variable and
then just use insert into you blob field.

[Robert Lummert]

Marc,

you can put your binary data into a blob field (say named doc) using
straight sql just like:

$sql = 'update mytable set doc=0x';
$fh = fopen($_FILES['userfile']['tmp_name'],'rb');
while(true) {
$chunk = unpack('H*chunk ',fread($fh,512 ));
$sql .= $chunk['chunk'];
if(strlen($chun k['chunk'])<512) break;
}
fclose($fh);

where $_FILES['userfile']['tmp_name'] is the file coming with a post
request.
But this is just appropriate for personal use as it is consuming lots of
ram and costs performance on both sides, the php engine and the
database. Make also sure that driver specific settings allow huge query
strings.
Other solutions depend on the database and databasedriver
you use but should be much more efficient.
Cheers,

robert

[monomaniac21]

Robert Lummert wrote:

Marc,

you can put your binary data into a blob field (say named doc) using
straight sql just like:

$sql = 'update mytable set doc=0x';
$fh = fopen($_FILES['userfile']['tmp_name'],'rb');
while(true) {
$chunk = unpack('H*chunk ',fread($fh,512 ));
$sql .= $chunk['chunk'];
if(strlen($chun k['chunk'])<512) break;
}
fclose($fh);

Robert how do you then retrieve this data, as a word document that can
be opened right away?

Kind regards

Marc

[Peter Fox]

Following on from Robert Lummert's message. . .

But this is just appropriate for personal use as it is consuming lots of
ram and costs performance on both sides, the php engine and the
database. Make also sure that driver specific settings allow huge query
strings.
Other solutions depend on the database and databasedriver
you use but should be much more efficient.
Cheers,

ABSOLUTELY.
Be prepared for performance/capacity issues if you do things this way.


--
PETER FOX Not the same since the pancake business flopped
pe******@eminen t.demon.co.uk.n ot.this.bit.no. html
2 Tees Close, Witham, Essex.
Gravity beer in Essex <http://www.eminent.dem on.co.uk>

[Jim Michaels]

It will be in binary in the database. Use mysql_escape_st ring() to encode
the data and stripslashes() to decode the data.
<?php //viewdoc.php
$q=mysql_query( "SELECT doc FROM mytable WHERE doc_id=$_GET[id]", $link);
if ($row=mysql_fet ch_array($q)) {
header("Content-Type: application/msword");
header('Content-Disposition: attachment; filename="downl oad.doc"');
echo stripslashes($r ow['doc']);
}
?>

and to insert data into the table (the stuff at the bottom only updates),
$sql = 'INSERT INTO mytable(doc) VALUES (0x';
$fh = fopen($_FILES['userfile']['tmp_name'],'rb');
while(true) {
$chunk = unpack('H*',fre ad($fh,512));
$sql .= $chunk['chunk'];
if(strlen($chun k['chunk'])<512) break;
}
fclose($fh);
$sql .= ")";
mysql_query($sq l, $link);
wouldn't that unpack be simply unpack('H*',fre ad($fh,512))) ? chunk would
really mess things up when unpack tries to interpret it wouldn't it?

"monomaniac 21" <ma********@msn .com> wrote in message
news:11******** **************@ g49g2000cwa.goo glegroups.com.. .

Robert Lummert wrote:

Marc,

you can put your binary data into a blob field (say named doc) using
straight sql just like:

$sql = 'UPDATE mytable SET doc=0x';
$fh = fopen($_FILES['userfile']['tmp_name'],'rb');
while(true) {
$chunk = unpack('H*chunk ',fread($fh,512 ));
$sql .= $chunk['chunk'];
if(strlen($chun k['chunk'])<512) break;
}
fclose($fh);

$sql .= " WHERE doc_id=$docid";
Robert how do you then retrieve this data, as a word document that can
be opened right away?

Kind regards

Marc