将上传的文件（id）与另一个表关联
我正在使用 Filestore 以表单形式上传。 这是一个很好的实现，但我对将上传的文件与表中的寄存器关联起来存有疑问。
当我运行 filestore.001.sql 时，它在数据库中添加 4 个表（filestore_image、filestore_file、filestore_volume、filestore_extension）。
然后在另一个表中我有：
id
field1
idfile
当我提交表单时，我正在考虑如何进行这种关联。 也许是 dsql() 然后选择最后插入的文件，但我不知道这是否是最好的选择。
谢谢 亚历杭德罗
I'm using Filestore to make uploads in a form.
It's a great implementation but I've a doubt about associating that file uploaded with a register in a table.
When I run the filestore.001.sql, it add 4 tables in Database (filestore_image, filestore_file, filestore_volume, filestore_extension).
Then in anoter table I have:
id
field1
idfile
I was thinking in how to do that association when I submit the form.
Maybe a dsql() and then selecting the last inserted file, but I don't know if this is the best option.
Thanks
Alejandro
如果你对这篇内容有疑问，欢迎到本站社区发帖提问 参与讨论，获取更多帮助，或者扫码二维码加入 Web 技术交流群。
绑定邮箱获取回复消息
由于您还没有绑定你的真实邮箱，如果其他用户或者作者回复了您的评论，将不能在第一时间通知您！
发布评论
评论（1）
当您将图像字段添加到表单时，它会在提交时返回您的 ID（或上传文件 ID 的列表）。因此理论上用户可以上传图像而不提交表单，因此它不会关联。
您可以拥有下表：
并将图片定义为图像类型，网站上应该有示例 - 它将自动从 filestore_file 表接收 ID。
您还可以采用另一种方法，这正是 Filestore_Image 的构建方式。您可以制作自己的模型，并将其与必要的图像链接，并将其用于您的图像字段。由于它是您的模型，因此您现在可以控制插入之前发生的情况，您可以覆盖 beforeInsert 和 afterInsert 事件以构建正确的关联。
两种方法都有各自的用途，选择你喜欢的一种。
When you add a image field to a form, it will return you ID (or list of uploaded file id's) on submission. So theoretically user can upload image and never submit form, hence it wouldn't be associated.
You can have the following table:
and define picture as type image, there should be examples on the site - it will automatically receive ID from the filestore_file table.
There is another way you can do and it's exactly how Filestore_Image is being built. You can make your own model, and link it with necessary image and use that for your image field. Since it's your model, you can now control what happens before inserting, you can override beforeInsert and afterInsert events to build the proper associations.
Both methods have their own uses, pick the one which you like.