Images Product on odoo

Question

I'm using odoo 10 , after a small research on google , I found that odoo stores their product in ir_attachement table ,
i need to know on what form is stored the images ?
and how to use it if i'm writing query to database directly to fetch images with php ?
for more details check this image
https://imgur.com/a/UUeuc

Hilar Andikkadavath · Accepted Answer

Images are stored in binary data under the table ir_attachment. please look here

https://www.odoo.com/forum/help-1/question/where-are-stored-the-images-128658#answer-128663 [1]

[1] https://www.odoo.com/forum/help-1/question/where-are-stored-the-images-128658#answer-128663

jebri houssem · Answer

@Hilar thx for your answer , any idea about retrieve this images and use it with my php application (ecommerce wesite)
ps : i already have an idea about the odoo api and the website module of odoo but i need to retrive data throught php from the database directly so i need to convert this data
if you can help ?

İlgili Gönderiler	Cevaplar	Görünümler
Create openerp database with Php postgresql php xmlrpc	2 Mar 15	5084
php webservice , connecting to the postgresql db postgresql php connection webservice	0 Tem 16	5124
When Odoo 14 connects to PostgreSQL 15.7, the connection is idle but cannot be released postgresql	0 Şub 25	1743
psycopg2.OperationalError: connection to server at "localhost" (::1), port 5432 failed: fe_sendauth: no password supplied postgresql	2 Oca 25	8427
How to change the width of a label in form view Çözüldü v10.0	3 Tem 24	29688

Bu soru işaretlendi

Enjoying the discussion? Don't just read, join in!