php - 如何将虚拟机中 postgrsql 数据库中的图像显示到我的本地

Question

我正在尝试显示来自 PostgreSQL 数据库的图像，并且正在检索黑屏。在字段 store_fname中， 我拥有该字段将为您提供我的 Odoo 文件存储中图像文件的路径，格式为 'ab/abcdef0123456789'

<?php
$conn = pg_connect("user = admin password = admin host = 192.168.1.11 dbname = odoo");
$res = pg_query($conn, "SELECT id, store_fname FROM ir_attachment
WHERE res_model = 'res.partner' AND res_field = 'image' AND res_id = 3; ");
$raw = pg_fetch_result($res, 'store_fname');
header('Content-type: image/jpeg');
echo pg_unescape_bytea($raw);
?>

标签： phppostgresqlodoo