StargazeR82
MIS
I need to be able to store an image file (.jpg) with each of my product records in my database. What is the best way to go about this? Any help appreciated.
Tek-Tips is the largest IT community on the Internet today!
Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!
-
Congratulations Chriss Miller on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!
Storing Images in MySQL
- Thread starter StargazeR82
- Start date
- Status
My 'inventory' table has a column for 'thumbnail' and another for the full size image. The data for the graphics columns is the path to the image.
product_id thumbnail
2101 /grfx/bookcover/2101.jpg
SELECT product_id, thumbnail FROM inventory
The beginning of your directory path may differ according to what your shopping cart script requires.
Ashford
product_id thumbnail
2101 /grfx/bookcover/2101.jpg
SELECT product_id, thumbnail FROM inventory
The beginning of your directory path may differ according to what your shopping cart script requires.
Ashford
- Status