note 69071 deleted from function.pg-escape-bytea by betz
| From: | betz@php.net | Date: | Tue, 22 Aug 2006 08:56:10 +0000 |
| Subject: | note 69071 deleted from function.pg-escape-bytea by betz | ||
| References: | 1 | Groups: | php.notes |
| Request: | Send a blank email to php-notes+get-116160@lists.php.net to get a copy of this message | ||
Note Submitter: pj at eni.pl
----
Hello
I had a weird problem.
When I want insert some bytea data from previous select query, pgsql return an error.
But that prepared data inserted in a query works fine:
<?php
$sql="
INSERT INTO file_mini (fileid,body) VALUES
(".$new_fileid[$i]['fid'].", '".
pg_escape_bytea(pg_unescape_bytea($photo[$i]['fm_body']))."');
";
?>