显示来自 MySQL 的随机引用而不重复
我正在尝试制作一个报价页面。我希望它在每次页面加载时显示一个随机报价，但也有一个“下一个报价”按钮，可以更改为另一个随机报价而不重复，除非粗略地您已经浏览了所有报价。我已经尝试了几天了，除了在页面加载时加载随机引用之外，还没有取得任何进展。如果有人可以帮助我。谢谢。
I am trying to make a quote page. I would like it to show a random quote every time the page loads but also have a "Next Quote" button that changes to another random quote without repeating, unless of coarse you have gone through all the quotes. I have been trying for a few days now and haven't gotten anywhere past loading a random quote on page load. If someone could please help me. Thanks.
如果你对这篇内容有疑问，欢迎到本站社区发帖提问 参与讨论，获取更多帮助，或者扫码二维码加入 Web 技术交流群。
绑定邮箱获取回复消息
由于您还没有绑定你的真实邮箱，如果其他用户或者作者回复了您的评论，将不能在第一时间通知您！
发布评论
评论（2）
有几种方法可以做到这一点。
标记用户已经看过的内容，然后在执行 SELECT 时过滤掉用户已经看过的内容。
预先创建随机顺序，然后跟踪用户上次查看的报价。例如，引用#8。然后你下次展示报价#9。是否
There are a couple of ways to do it.
Mark which ones the user has already seen, then when you do a SELECT, filter out the ones the user already saw.
Pre-create the random order, then keep track of which quote the user last viewed. For example, quote #8. You then show quote #9 next time. Whether y
假设网页和有限数量的引号，我只需将它们全部加载到页面加载的 html 中，然后使用滑块循环遍历它们。
您还可以做的就是随机加载一个到页面中，然后通过 xml 或 json 提供其余的。这样，如果用户没有 javascript（虽然很少见）或屏幕阅读器（残疾用户的辅助功能），他们将只能听到/看到一个引用，然后使用 javascript，您可以加载其余的引用。
Assuming web pages and a limited number of quotes, I would just load them all into the html on the page load, and then loop through them with a slider.
What you could also do, is just load one randomly into the page and then provide the rest via xml or json. That way if the user doesn't have javascript (though rare) or a screen reader (accessibility for disabled users) they will hear / see only one quote, and then with javascript you can load in the rest of the quotes.