Can not insert word file into mysql table (in blob field)

prabhatsoni · 07-21-2006, 02:45 AM

Hello gurus,
I have a mysql table with one of field created as "mediumblob". This filed planned to use for saving files uploaded by users through apache+php.
Now I have this insert statement for inserting the file into the fields:

Code:

$data=fread(fopen($file_ln, "rb"), filesize($file_ln));   
$query="insert into mes values (\"" . $_SESSION['user_id'] . "\",\"" . $to[$i] . "\",\"" . $_POST['message'] . "\",now(),\"\",\"".$file_name."\",\"".$data."\")";

Where file_ln is the uploaded file.
Now this query works perfectly if a text file is uploaded, but fails when MS-word (or .xls etc) files are uploaded.
The error reported is

Quote:

1064: You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near '' at line 1

What is the problem in this, folks. I feel there is som emismatch between the field type and the $data.
After uploading the .doc file, I have checked that the $data variable does save the file. This I have done by checking its size by "strlen($data)".

Any pointer friends.
Thanks in advance.

Prabhat Soni

zeitounator · 07-21-2006, 03:25 AM

I would bet this is a character escape problem....

http://dev.mysql.com/doc/refman/5.0/...ng-syntax.html

Quote:

Originally Posted by mysql doc

If you want to insert binary data into a string column (such as a BLOB column), the following characters must be represented by escape sequences:
NUL NUL byte (ASCII 0). Represent this character by ‘\0’ (a backslash followed by an ASCII ‘0’ character).
\ Backslash (ASCII 92). Represent this character by ‘\\’.
' Single quote (ASCII 39). Represent this character by ‘\'’.
" Double quote (ASCII 34). Represent this character by ‘\"’.

Have a look at the documentation for php mysql_real_escape_string() function

prabhatsoni · 07-21-2006, 05:01 AM

Thanks Mr Zeitounator,

You have been of immense help.

Thanks onece again.

Prabhat Soni