Community Learn Tools Library Leisure
search
English
Home > Backend Development > PHP Tutorial > body text

一个商品表与商品图片怎么建表呢？

WBOY
Release： 2016-06-06 20:23:56
Original
1918 people have browsed it

一个商品有商品图，大概可能有十张图片，可以随意调整顺序，然后可以设置一张作为首图。

是否要考虑图片去重的问题，建一张专门的图片去重表。

如果商品只有一张图片还好说，但是有十张图片，那这个怎么建表比较合理呢？

回复内容：

一个商品有商品图，大概可能有十张图片，可以随意调整顺序，然后可以设置一张作为首图。

是否要考虑图片去重的问题，建一张专门的图片去重表。

如果商品只有一张图片还好说，但是有十张图片，那这个怎么建表比较合理呢？

三张表，一个商品，一个图片文件，一个关联表（外加顺序）

图片存储统一格式，直接用id-n.格式 保存就行了， 再加一个字段保存图片总数 写代码查到id 再拼成 id-1.格式 id-n.格式

Related labels：
php sql thinkphp
source：php.cn
Previous article：Zend Framework form怎么获取isValid失败的原因？ Next article：composer 安装yii 框架2.0.6 安装报错？
Statement of this Website
The content of this article is voluntarily contributed by netizens, and the copyright belongs to the original author. This site does not assume corresponding legal responsibility. If you find any content suspected of plagiarism or infringement, please contact admin@php.cn
Latest Articles by Author
Latest Issues
PHP arrays obtained from URL parameters do not behave as expected I have a URL parameter that contains the category ID and I want to treat it as an array li...
From 2024-04-06 22:09:02
0
1
1428
Where should I place CustomLog directive in apache I'm using php:7.2-apachedocker. I need to disable health check url login access log. Based...
From 2024-04-06 22:03:59
0
1
990
What is the format of the variables in the return value? I am a new learner of php. I found a piece of code: if($x<time()){return[false,'error']...
From 2024-04-06 21:55:20
0
1
778
Problems encountered when using opentbs to generate odt files: values ​​of the same key are displayed in the same row instead of separate columns. I'm using a library called OpenTbs to create odt using PHP, I'm using it because columns a...
From 2024-04-06 20:18:18
0
1
483
Group MySQL results by ID for looping over I have a table with flight data in mysql. I'm writing a php code that will group and displ...
From 2024-04-06 17:27:56
0
1
406
Related Topics
More>
Popular Recommendations
Popular Tutorials
More>
Related Tutorials
Popular Recommendations
Latest courses
Latest Downloads
More>
Web Effects
Website Source Code
Website Materials
Front End Template