[RESOLVED] ***image To Display On Page***

[RESOLVED] image To Display On Page

limao

yeah im back you guys,

My new problem is I wanna know how I can display an image from my mySQL table on my website. I've heard that its a bad idea to have it in my database and I've heard that theres a better way but they don't show how to do it. Any answers would be apreciated..... again! thanks in advance you guys!

halojoy

so you have an image
first you need to store it in DB in some suitable way
after this you can try to get it out of DB
and display image

how far have you got now?
🙂

limao

well, i've stored it in the database so now i just need to display it on my website

halojoy

what code did you use to INSERT into database?
and in what format is the image stored?
because we need to know to get it out

I guess it is not possible just to
INSERT 'image.jpg' into TABLE 'images'

limao

sorry I took so long to reply back,here's all the info i got (let me know if you need anything else).....

I used phpMyAdmin to create a database called 'CCTVPRODUCTS'. I then created a table called products (more like a testing table to see if it works). Then in that table I made a column for the images called prodImage and I made it a BLOB and the image will be stored as a jpg.

limao

I figured it out, but i do appreciate your input and help as always you guys 😃