动态网页：将图像存储在单独的表/数据库中？

Question

I just started to use dynamic instead of static webpages so I store everything in my database now. The thing is that I don't really know what's the best way to save my images within the database.

I decided to store the image file paths instead of the images itself in a database. But should I save the urls (up to 50 images per article so that means 50 possible urls) in the same table or should I create another one just for these images? What's the best way to do this?

Related question: Do I need a seperate column for each image? In other words, do I have to create 50 columns for each possible image per news article?

Answer 1

You would create another table with two columns not 50. You can have several rows per page.

pageref | imagepath
--------+------------
home    | image01.jpg
home    | image02.jpg
home    | image24.jpg
home    | image65.jpg
about   | image03.jpg
about   | image04.jpg

I say two columns, you might want to store the order in which they appear, the datetime they were uploaded, their dimensions etc.