Sql从文件夹中检索图像 [英] Sql retrieve images from folder
问题描述
新来的这个
想知道是否有人可以提供帮助
我正在学习sql并且已经搜索了一天以上的答案，没有运气。我找到了这个网站，看起来你们都互相帮助。
我有一个名为listing_photo的数据库
其中有行photo_listing （独特的物业编号）
&行photo_caption （保留照片的标题）
图像保存在名为mysite / photo_big的文件夹中
我想展示相关内容每个特定属性的照片。在我的网站的属性模板中。还会在每个下方显示照片标题。每个房产有8张照片。
有人能告诉我在sql php中执行此操作的正确方法吗？
Hi, new here
Wonder if anyone can help
I am learning sql and have searched for the answer for over a day, with no luck. I found this site and it seems you all help each other.
I have a database called "listing_photo"
In that there is row "photo_listing" (unique property number)
& row "photo_caption" (holds the caption for the photo)
The images are kept in a folder called mysite/photo_big
I would like to show the relevant photos for each particular property. in the property template in my site. Also show the photo caption under each. There are 8 photos for each property.
Can anyone show me the correct way to do this in sql php?
推荐答案
嘿。
我不知道你的照片和标题是如何与列表相关联的。您可以在数据库中发布真实数据的示例吗？
一般情况下，我们只需执行以下操作：
Hey.
I''m not getting how your photos and captions are linked to the listing. Could you maybe post an example of real data from your database?
In general, we just do something like this:
您好Atli
感谢您的帮助，非常感谢！
我附上了访问图片的数据库视图。
这是一个单独的属性127，给你一个想法。
图片在文件夹中
/ holidays / files / photo_big
我如何在你的代码中实现这一点好吗？
我想要显示图片...
Pic1 Pic2
Pic3 Pic4
Pic5 Pic6
等
问候
Hi Atli
Thanks for your help, really appreciate it!
I have attached a view of the database that accesses the pictures.
This is for a single property 127, to give you an idea.
The pictures are in folder
/holidays/files/photo_big
How would I implement this in your code exactly?
I would like the pictures to display...
Pic1 Pic2
Pic3 Pic4
Pic5 Pic6
etc.
Regards
任何人都可以提供帮助，它让我疯狂
Anyone help with this please, its driving me crazy
这篇关于Sql从文件夹中检索图像的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！
