Memory limit for variables?

[Anon]

Hi,

I am using this snippet to store an image as binary data into a database later:

$attachmentFileName = $DOCUMENT_ROOT . "/attachments/test.jpg";
$fp = fopen($attachmentFileName, "r");
$fileData = fread($fp, filesize($attachmentFileName));
$fileData = addslashes($fileData);
fclose($fp);

It seems that images larger than 64kb can not be stored completely into the database. I am sure that the database is not that problem. There I am using BLOB fields etc.

Is it possible that the size of variables (here $fileData) is limited to 64kb? I could not find an entry in the php.ini to increase that value.

Can anyone help me quickly or give me an advice?

Thanks,
Danny

[van__]

$fileData = addslashes($fileData);
is your problem
Do not addslashes to binary data
BLOB is never attempted to be understood or interpretted by the database, that is why we use Blob to store potentially dangerous and unknown data.
Using addslashes corrupts the data and prevents the image from being displayed after retrieval.

[Anon]

addslashes() was not the problem. But I had to use mediumblob instead of blob in the mysql database.

bye,
Danny

[[deleted]]

Addslashes is required when you insert binary data into a database through a query.

Why?

Because the query looks like this:

INSERT INTO table (field) VALUES ("BINARY_DATA_HERE")

If you don't use addslashes, every single quote, EOL, EOF, NULL etc will break the query.