pg_unescape_bytea
Unescape binary for bytea type
Description
string pg_unescape_bytea(string $string)
Note:
When you SELECT a bytea type, PostgreSQL returns octal byte values
prefixed with '\' (e.g. \032). Users are supposed to convert back to
binary format manually.
Parameters
-
string
-
A string containing PostgreSQL bytea data to be converted into
a PHP binary string.
Return Values
A string containing the unescaped data.
Examples
Example #1 pg_unescape_bytea example
<?php
// Connect to the database
$dbconn = pg_connect('dbname=foo');
// Get the bytea data
$res = pg_query("SELECT data FROM gallery WHERE name='Pine trees'");
$raw = pg_fetch_result($res, 'data');
// Convert to binary and send to the browser
header('Content-type: image/jpeg');
echo pg_unescape_bytea($raw);
?>
See Also
- pg_escape_bytea
- pg_escape_string