Store pdf remote file in postgres DB with php

Question

I have little pdf (or txt, odt, doc) file to be store in Postgres DB with php. I use this php functions to read file:

$fp = fopen($name, 'rb');

$content = fread($fp, filesize($name));

$content = addslashes($content);

fclose($fp);

and then try to store in db:

$sql = "insert into Table(column) values ('$content'::bytea)";

$result = @pg_query($sql);

"column" is bytea type.

When I execute the script with pdf file, I get the follow error:

ERROR: invalid byte sequence for encoding "UTF8": 0xe2e3cf HINT: This error can also happen if the byte sequence does not match the encoding expected by the server, which is controlled by "client_encoding".

When I execute the script with doc file, I get the follow error:

ERROR: invalid input syntax for type bytea

When I execute the script with txt file, NO error:

What's wrong and what is the proper way to store files?

araqnid · Accepted Answer · 2011-03-11 12:21:30Z

1

Have you tried using pg_escape_string instead of addslashes? http://www.php.net/manual/en/function.pg-escape-string.php

answered Mar 11, 2011 at 12:21

araqnid

135k25 gold badges164 silver badges139 bronze badges

Sign up to request clarification or add additional context in comments.

1 Comment

teosantoro Over a year ago

Thanks, pg_escape_bytea() instead of addslashes() is exactly what I wanted.

Collectives™ on Stack Overflow

Store pdf remote file in postgres DB with php

1 Answer 1

1 Comment

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

1 Comment

Your Answer

Sign up or log in

Post as a guest

Related