问个类似百科多版本的问题看哪个大神有好的思路
因为以前没做过关于多版本的网站，貌似网上也没有这些开源代码
最近要做一个比较奇怪的东西 嗯 就暂定为一个 问答系统吧
A发布人可以发布问题
B、C、D 等等 很多人可以回答问题
当A 发布了一个问题 这个问题可以有很多人回答 但是A 突然发现他发布的这个问题突然不清晰 他想改一下 于是 这个问题 就变成了 第二个版本 大家回答问题 都是回答在第二个版本 而且大家能够看到所有这个问题的历史版本 也就是问题 类似百度百科 或者 淘宝商品 那样 有多版本 （貌似也能叫快照） 这个应该如何实现呢
这里面有个和普通百科多版本不一样的问题是 当前正在使用的版本 并不只是可以看 还可以 标记问题成功 或者问题下架 问题失败等等
我的第一次构思是把这新版本 都放在 ask表里面 但是我感觉这样做 肯定不太好 既然是问题表 当然都是 真实的问题 不能把以前的版本 也放在这里面吧
于是我想 或许是不是可以再建立一个 旧版本表 把每次更改前的版本都放在旧版本表里面呢
大神们有没有什么想法 ？
回复内容：
因为以前没做过关于多版本的网站，貌似网上也没有这些开源代码
最近要做一个比较奇怪的东西 嗯 就暂定为一个 问答系统吧
A发布人可以发布问题
B、C、D 等等 很多人可以回答问题
当A 发布了一个问题 这个问题可以有很多人回答 但是A 突然发现他发布的这个问题突然不清晰 他想改一下 于是 这个问题 就变成了 第二个版本 大家回答问题 都是回答在第二个版本 而且大家能够看到所有这个问题的历史版本 也就是问题 类似百度百科 或者 淘宝商品 那样 有多版本 （貌似也能叫快照） 这个应该如何实现呢
这里面有个和普通百科多版本不一样的问题是 当前正在使用的版本 并不只是可以看 还可以 标记问题成功 或者问题下架 问题失败等等
我的第一次构思是把这新版本 都放在 ask表里面 但是我感觉这样做 肯定不太好 既然是问题表 当然都是 真实的问题 不能把以前的版本 也放在这里面吧
于是我想 或许是不是可以再建立一个 旧版本表 把每次更改前的版本都放在旧版本表里面呢
大神们有没有什么想法 ？
一个问题被发表的时候生成一个父类ID，并且生成一个初始的子类ID，父类ID和子类ID进行关联，所有评论都与子类ID关联。
另外建议使用文本数据库，现在市场上的文本数据库还是比较稳定，可用考虑使用。
Hot AI Tools
Undresser.AI Undress
AI-powered app for creating realistic nude photos
AI Clothes Remover
Online AI tool for removing clothes from photos.
Undress AI Tool
Undress images for free
Clothoff.io
AI clothes remover
Video Face Swap
Swap faces in any video effortlessly with our completely free AI face swap tool!
Hot Article
Hot Tools
Notepad++7.3.1
Easy-to-use and free code editor
SublimeText3 Chinese version
Chinese version, very easy to use
Zend Studio 13.0.1
Powerful PHP integrated development environment
Dreamweaver CS6
Visual web development tools
SublimeText3 Mac version
God-level code editing software (SublimeText3)
Hot Topics
1666
14
1426
52
1328
25
1273
29
1254
24
PHP and Python: Different Paradigms Explained
Apr 18, 2025 am 12:26 AM
PHP is mainly procedural programming, but also supports object-oriented programming (OOP); Python supports a variety of paradigms, including OOP, functional and procedural programming. PHP is suitable for web development, and Python is suitable for a variety of applications such as data analysis and machine learning.
PHP's Purpose: Building Dynamic Websites
Apr 15, 2025 am 12:18 AM
PHP is used to build dynamic websites, and its core functions include: 1. Generate dynamic content and generate web pages in real time by connecting with the database; 2. Process user interaction and form submissions, verify inputs and respond to operations; 3. Manage sessions and user authentication to provide a personalized experience; 4. Optimize performance and follow best practices to improve website efficiency and security.
PHP: Handling Databases and Server-Side Logic
Apr 15, 2025 am 12:15 AM
PHP uses MySQLi and PDO extensions to interact in database operations and server-side logic processing, and processes server-side logic through functions such as session management. 1) Use MySQLi or PDO to connect to the database and execute SQL queries. 2) Handle HTTP requests and user status through session management and other functions. 3) Use transactions to ensure the atomicity of database operations. 4) Prevent SQL injection, use exception handling and closing connections for debugging. 5) Optimize performance through indexing and cache, write highly readable code and perform error handling.
Choosing Between PHP and Python: A Guide
Apr 18, 2025 am 12:24 AM
PHP is suitable for web development and rapid prototyping, and Python is suitable for data science and machine learning. 1.PHP is used for dynamic web development, with simple syntax and suitable for rapid development. 2. Python has concise syntax, is suitable for multiple fields, and has a strong library ecosystem.
PHP and Python: A Deep Dive into Their History
Apr 18, 2025 am 12:25 AM
PHP originated in 1994 and was developed by RasmusLerdorf. It was originally used to track website visitors and gradually evolved into a server-side scripting language and was widely used in web development. Python was developed by Guidovan Rossum in the late 1980s and was first released in 1991. It emphasizes code readability and simplicity, and is suitable for scientific computing, data analysis and other fields.
Why Use PHP? Advantages and Benefits Explained
Apr 16, 2025 am 12:16 AM
The core benefits of PHP include ease of learning, strong web development support, rich libraries and frameworks, high performance and scalability, cross-platform compatibility, and cost-effectiveness. 1) Easy to learn and use, suitable for beginners; 2) Good integration with web servers and supports multiple databases; 3) Have powerful frameworks such as Laravel; 4) High performance can be achieved through optimization; 5) Support multiple operating systems; 6) Open source to reduce development costs.
The Future of HTML, CSS, and JavaScript: Web Development Trends
Apr 19, 2025 am 12:02 AM
The future trends of HTML are semantics and web components, the future trends of CSS are CSS-in-JS and CSSHoudini, and the future trends of JavaScript are WebAssembly and Serverless. 1. HTML semantics improve accessibility and SEO effects, and Web components improve development efficiency, but attention should be paid to browser compatibility. 2. CSS-in-JS enhances style management flexibility but may increase file size. CSSHoudini allows direct operation of CSS rendering. 3.WebAssembly optimizes browser application performance but has a steep learning curve, and Serverless simplifies development but requires optimization of cold start problems.
PHP's Impact: Web Development and Beyond
Apr 18, 2025 am 12:10 AM
PHPhassignificantlyimpactedwebdevelopmentandextendsbeyondit.1)ItpowersmajorplatformslikeWordPressandexcelsindatabaseinteractions.2)PHP'sadaptabilityallowsittoscaleforlargeapplicationsusingframeworkslikeLaravel.3)Beyondweb,PHPisusedincommand-linescrip
