> <problem>
> How do I insert files inte BLOBs?
> </problem>
Tomas,
I use this PHP function to insert ASCII files into BLOBs. I think it would
also work for binary files but I have not tested it. Please note that there
are other (perhaps better) ways to insert into BLOBs but this works for me.
Good luck,
Philip
---------------------- code starts here ----------------------
function RecordFile($pathname, $filename) {
$filesize = filesize($pathname . "/" . $filename);
$fp = fopen($pathname . "/" . $filename, "r");
$content = fread($fp, $filesize);
fclose($fp);
$content = addslashes($content);
$filename = addslashes($filename);
$pathname = addslashes($pathname);
$s = "insert into files (path, name, size, content) values (";
$s = $s . "'" . $pathname . "', ";
$s = $s . "'" . $filename . "', ";
$s = $s . "'" . $filesize . "', ";
$s = $s . "'" . $content . "'";
$s = $s . ")";
if (mysql_query($s) == false) {
lprint("Query failed: " . $s);
lprint(mysql_error());
}
}
---------------------- code ends here ----------------------
---------------------------------------------------------------------
Before posting, please check:
http://www.mysql.com/manual.php (the manual)
http://lists.mysql.com/ (the list archive)
To request this thread, e-mail <[EMAIL PROTECTED]>
To unsubscribe, e-mail <[EMAIL PROTECTED]>
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
