How to Display Products in a table format?

PHP/MySQLi - how do I add ability to display images with records?

• I'm still fairly new to PHP/MySQLi. Trying to get a grasp on some basics. Currently, I have: db_gallery, tb_gallery, columns: item_id, title, artist. I display the item list in table format on the web page using printf. I'd like to be able to display an image (or two) with each record. What is the best way to do this? I think that images can be stored in the database itself (something about BLOB), or maybe I should just store the filename of the image, and put the images in a folder? Eventually, the page will go live online, but for now I'm working on my home computer using apache on Windows. So my question(s): > What is the best way to set up the images in the database and/or folders. (Hundreds of images). > How do I then display the image with each record on the web page

• Answer:

  I would opt for the second option. Store the files on your hard disk, and just reference them in the database. Storing them as a blob is a bit messy and will make your table huge and have a nasty impact on it's query performance. To display the image on your webpage, you will need to use an img tag and set the src in the tag to point to the image file. Check out the w3schools example if that doesnt make any sense: http://www.w3schools.com/tags/tag_IMG.asp :-)