BLOB from DB to temp file.

[TomGoodacre]

Hi,

I need to extract a blob (actually a php file) from a database into a temp. file and then include this temp file in another PHP file i.e.:

<?php

extract BLOB (temp_file) from MySQL DB.

include 'temp_file.php'

?>

Can anyone help me on how I go about doing this?

Regards,

Tom

[drew010]

<?php

//connect to database

$q = "select blobfield from table where (where clause)";
$r = mysql_query($q);

$data = mysql_result($r, 0);

$fp = fopen("temp_file.php", "w+");
flock($fp, LOCK_EX);
fwrite($fp, $data);
flock($fp, LOCK_UN);
fclose($fp);

include "temp_file.php";

?>