blocks|key|5673581|text|你在正确的轨道上。我会使用时间戳(类型为DATETIME)来确定图片上传的确切时间，并按此进行排序。递增的ID并不总是与插入时间相对应。|type|unstyled|depth|inlineStyleRanges|offset|length|style|CODE|entityRanges|data|5673582|entityMap^0|K|8|0^^$0|@$1|2|3|4|5|6|7|H|8|@$9|I|A|J|B|C]]|D|@]|E|$]]|$1|F|3|-4|5|6|7|K|8|@]|D|@]|E|$]]]|G|$]]

You're on the right track. I'd use a timestamp (of type <code>DATETIME</code>) to determine exactly when the picture was uploaded, and sort by that. An incrementing ID doesn't always correspond with the time of insertion.

blocks|key|4205211|text|您可以通过auto_incremented+id字段来执行此操作，也可以存储时间戳并以此方式对其进行排序。这两个都是不错的选择，只要确保避免潜在的主键冲突即可。|type|unstyled|depth|inlineStyleRanges|entityRanges|data|4205212|entityMap^0|0^^$0|@$1|2|3|4|5|6|7|D|8|@]|9|@]|A|$]]|$1|B|3|-4|5|6|7|E|8|@]|9|@]|A|$]]]|C|$]]

You could do it by an auto_incremented id field, or you could store the timestamps and order them that way. Either one is an okay option, just make sure that you're avoiding potential primary key violations.

blocks|key|4205244|text|我觉得不错。如果你真的想获得技术，你可以使用一个时间戳字段，并按此对它们进行排序。然而，听起来你的想法很好用，只要你在插入图片时自动递增。|type|unstyled|depth|inlineStyleRanges|entityRanges|data|4205245|entityMap^0|0^^$0|@$1|2|3|4|5|6|7|D|8|@]|9|@]|A|$]]|$1|B|3|-4|5|6|7|E|8|@]|9|@]|A|$]]]|C|$]]

Sounds good to me. If you really wanted to get technical, you could use a timestamp field and order them by that. However, it sounds like your idea would work fine as long as you auto increment as you insert your images.

blocks|key|4205297|text|使用filemtime()，您可以获得文件的时间戳。因此，在你使用(例如)+readdir()获取文件之后，可以使用uasort()或其他php排序函数来定义排序。这不需要数据库。|type|unstyled|depth|inlineStyleRanges|offset|length|style|CODE|entityRanges|data|4205298|entityMap^0|2|B|12|9|1M|8|0^^$0|@$1|2|3|4|5|6|7|H|8|@$9|I|A|J|B|C]|$9|K|A|L|B|C]|$9|M|A|N|B|C]]|D|@]|E|$]]|$1|F|3|-4|5|6|7|O|8|@]|D|@]|E|$]]]|G|$]]

With <code>filemtime()</code> you get the timestamp of a file. So it is possible to define an ordering with <code>uasort()</code> - or one of the other php sorting functions - after you get the files with (for example) <code>readdir()</code>. No database is necessary for that.

blocks|key|1888844|text|在数据库中存储指向该文件的指针将是将图像保存在文件系统中的最佳方式。至于创建的日期，您可以使用DATETIME来跟踪它的创建时间，然后按照您想要的顺序查询它们。|type|unstyled|depth|inlineStyleRanges|offset|length|style|CODE|entityRanges|data|1888845|entityMap^0|1B|8|0^^$0|@$1|2|3|4|5|6|7|H|8|@$9|I|A|J|B|C]]|D|@]|E|$]]|$1|F|3|-4|5|6|7|K|8|@]|D|@]|E|$]]]|G|$]]

Storing a pointer to the file in your database would be the best way to go about it and have the images in a file system. As for the date created, you could use <code>DATETIME</code> to keep track of the time it was created and then query for them in the order you wanted them.

blocks|key|4205354|text|我看不出有这个必要。必须有一种方法在PHP中获得所有的文件列表，并按创建日期排序。由于此文件将上载到您的服务器，因此date_created时间将是在您的服务器上创建的日期；因此，不需要新的表和数据库调用等。|type|unstyled|depth|inlineStyleRanges|entityRanges|data|4205355|entityMap^0|0^^$0|@$1|2|3|4|5|6|7|D|8|@]|9|@]|A|$]]|$1|B|3|-4|5|6|7|E|8|@]|9|@]|A|$]]]|C|$]]

I don't see the need for this. There must be a way in PHP to get all the list of files and sort by date created. Since this files will be uploaded to your server, the date_created time will be the date created on your server; hence, no need for a new table and database call, etc.

blocks|key|1888904|text|如果您计划在系统中存储数千张(或更多)照片，则需要使用元数据数据库表，同时将实际的图像文件存储在硬盘上。|type|unstyled|depth|inlineStyleRanges|entityRanges|data|1888905|通过10,000次I/O命中来按日期对文件进行排序是非常愚蠢的。执行一个SQL查询返回按日期排序的所有文件名的列表要好得多，因为MySQL可能能够将整个表放入内存中。|1888906|table+image
{
++++id
++++user_id+(if+images+belong+to+certain+users)
++++path+(the+file+system+path+and/or+filename)
++++created+(timestamp)
}|code-block|syntax|javascript|1888907|entityMap^0|0|0|0^^$0|@$1|2|3|4|5|6|7|K|8|@]|9|@]|A|$]]|$1|B|3|C|5|6|7|L|8|@]|9|@]|A|$]]|$1|D|3|E|5|F|7|M|8|@]|9|@]|A|$G|H]]|$1|I|3|-4|5|6|7|N|8|@]|9|@]|A|$]]]|J|$]]

If you are planing on having thousands (or more) of photos on in your system you need to use a database table for meta-data while storing the actual image files on the hard drive.

Doing 10,000 I/O hits to sort the files by date is nuts. Doing one SQL query to return a list of all file names ordered by date is much better since MySQL will probably be able to fit the entire table into memory.

<pre><code>table image
{
 id
 user_id (if images belong to certain users)
 path (the file system path and/or filename)
 created (timestamp)
}
</code></pre>

I have a website with a lot of pictures in it. Currently I just have the pictures all on the server and I use php to get the files in the directory and display them all one my one in a table. However, when I do this the pictures are displayed alphabetically which I don't want. I want them to be displayed my insertion time. Which I was thinking I could create a table with a number field set to auto increment and then the file name of the inserted picture. and just leave the pictures on the server. So everytime I insert a picture it will insert a row with a number and file name. So when I display I just display by that number Desc, which should give me the pictures by newest inserted. Is this the best way to do this?

Thanks

Best way to implement a pictures table in my database

翻译质量差，导致语言生硬或混乱。

没有提供实际的解决方法或示例。

解答不清晰，无法理解或解决问题。

页面排版不美观，阅读体验差。

文章

问答

视频

学习中心

腾讯云实验室

直播

竞赛

腾讯云代码分析专区

腾讯iOA零信任安全管理系统专区

腾讯云架构师技术同盟交流圈

腾讯云数据库专区

腾讯云顾问专区

腾讯云原生专区

腾讯混元专区

腾讯云TCE专区

腾讯云Lighthouse专区

腾讯云HAI专区

腾讯云Edgeone专区

腾讯云存储专区

腾讯云智能专区

腾讯轻联专区 

腾讯云开发专区

TAPD专区

腾讯轻量云游戏服专区

腾讯云最具价值专家

腾讯云架构师技术同盟

腾讯云创作之星

腾讯云开发者先锋

腾讯云代码助手

云原生构建

TAPD 敏捷项目管理

Cloud Studio

SDK中心

API中心

命令行工具

涵盖代码开发、场景应用、自动测试全流程，助你从零构建专属AI助手

一站式MCP教程库，解锁AI应用新玩法

我有一个网站，里面有很多图片。目前，我只在服务器上有所有的图片，我使用php获取目录中的文件，并将它们显示在一个表格中。然而，当我这样做的时候，图片是按字母顺序显示的，这是我不想要的。我想让它们显示我的插入时间。我想我可以创建一个表格，其中的数字字段设置为自动递增，然后是插入图片的文件名。把照片留在服务器上。所以每次我...

问在我的数据库中实现图片表的最佳方法
EN

Stack Overflow用户

社区

活动

圈层

关于

腾讯云开发者

热门产品

热门推荐

更多推荐

问在我的数据库中实现图片表的最佳方法EN