PostgreSQL 中使用 PHP 处理图像

testdb=> CREATE TABLE images(id INT PRIMARY KEY, data BYTEA);

<?php 

host = "localhost";user = "user12"; 
pass = "34klq*";db = "testdb"; 

con = pg_connect("host=host dbname=db user=user password=pass")
    or die ("Could not connect to server\n");file_name = "woman.jpg";

img = fopen(file_name, 'r') or die("cannot read image\n");
data = fread(img, filesize(file_name));es_data = pg_escape_bytea(data);
fclose(img);

query = "INSERT INTO images(id, data) Values(1, 'es_data')";
pg_query(con,query); 

pg_close($con); 

?>

$file_name = "woman.jpg";

$img = fopen($file_name, 'r') or die("cannot read image\n");
$data = fread($img, filesize($file_name));

$es_data = pg_escape_bytea($data);

fclose($img);

$query = "INSERT INTO images(id, data) Values(1, '$es_data')";
pg_query($con, $query); 

<?php 

host = "localhost";user = "user12"; 
pass = "34klq*";db = "testdb"; 

con = pg_connect("host=host dbname=db user=user password=pass")
    or die ("Could not connect to server\n");query = "SELECT data FROM images WHERE id=1";
res = pg_query(con, query) or die (pg_last_error(con)); 

data = pg_fetch_result(res, 'data');
unes_image = pg_unescape_bytea(data);

file_name = "woman2.jpg";img = fopen(file_name, 'wb') or die("cannot open image\n");
fwrite(img, unes_image) or die("cannot write image data\n");
fclose(img);

pg_close($con); 

?>

$query = "SELECT data FROM images WHERE id=1";

$data = pg_fetch_result($res, 'data');

$unes_image = pg_unescape_bytea($data);

$file_name = "woman2.jpg";
$img = fopen($file_name, 'wb') or die("cannot open image\n");

fwrite(img,unes_image) or die("cannot write image data\n");