问个类似百科多版本的问题看哪个大神有好的思路-PHP Tutorial-php.cn

Home

Backend Development

PHP Tutorial

问个类似百科多版本的问题看哪个大神有好的思路

WBOYWBOYWBOYWBOYWBOYWBOYWBOYWBOYWBOYWBOYWBOYWBOYWB

Jun 06, 2016 pm 08:46 PM

phpwebweb developmentwebsitewebsite development

因为以前没做过关于多版本的网站，貌似网上也没有这些开源代码
最近要做一个比较奇怪的东西嗯就暂定为一个问答系统吧
A发布人可以发布问题
B、C、D 等等很多人可以回答问题

当A 发布了一个问题这个问题可以有很多人回答但是A 突然发现他发布的这个问题突然不清晰他想改一下于是这个问题就变成了第二个版本大家回答问题都是回答在第二个版本而且大家能够看到所有这个问题的历史版本也就是问题类似百度百科或者淘宝商品那样有多版本（貌似也能叫快照）这个应该如何实现呢

这里面有个和普通百科多版本不一样的问题是当前正在使用的版本并不只是可以看还可以标记问题成功或者问题下架问题失败等等

我的第一次构思是把这新版本都放在 ask表里面但是我感觉这样做肯定不太好既然是问题表当然都是真实的问题不能把以前的版本也放在这里面吧

于是我想或许是不是可以再建立一个旧版本表把每次更改前的版本都放在旧版本表里面呢

大神们有没有什么想法？

回复内容：

这里面有个和普通百科多版本不一样的问题是当前正在使用的版本并不只是可以看还可以标记问题成功或者问题下架问题失败等等

我的第一次构思是把这新版本都放在 ask表里面但是我感觉这样做肯定不太好既然是问题表当然都是真实的问题不能把以前的版本也放在这里面吧

于是我想或许是不是可以再建立一个旧版本表把每次更改前的版本都放在旧版本表里面呢

大神们有没有什么想法？

一个问题被发表的时候生成一个父类ID，并且生成一个初始的子类ID，父类ID和子类ID进行关联，所有评论都与子类ID关联。
另外建议使用文本数据库，现在市场上的文本数据库还是比较稳定，可用考虑使用。

Statement

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

PHP Performance Tuning for High Traffic WebsitesMay 14, 2025 am 12:13 AM

ThesecrettokeepingaPHP-poweredwebsiterunningsmoothlyunderheavyloadinvolvesseveralkeystrategies:1)ImplementopcodecachingwithOPcachetoreducescriptexecutiontime,2)UsedatabasequerycachingwithRedistolessendatabaseload,3)LeverageCDNslikeCloudflareforservin

Dependency Injection in PHP: Code Examples for BeginnersMay 14, 2025 am 12:08 AM

You should care about DependencyInjection(DI) because it makes your code clearer and easier to maintain. 1) DI makes it more modular by decoupling classes, 2) improves the convenience of testing and code flexibility, 3) Use DI containers to manage complex dependencies, but pay attention to performance impact and circular dependencies, 4) The best practice is to rely on abstract interfaces to achieve loose coupling.

PHP Performance: is it possible to optimize the application?May 14, 2025 am 12:04 AM

Yes,optimizingaPHPapplicationispossibleandessential.1)ImplementcachingusingAPCutoreducedatabaseload.2)Optimizedatabaseswithindexing,efficientqueries,andconnectionpooling.3)Enhancecodewithbuilt-infunctions,avoidingglobalvariables,andusingopcodecaching

PHP Performance Optimization: The Ultimate GuideMay 14, 2025 am 12:02 AM

ThekeystrategiestosignificantlyboostPHPapplicationperformanceare:1)UseopcodecachinglikeOPcachetoreduceexecutiontime,2)Optimizedatabaseinteractionswithpreparedstatementsandproperindexing,3)ConfigurewebserverslikeNginxwithPHP-FPMforbetterperformance,4)

PHP Dependency Injection Container: A Quick StartMay 13, 2025 am 12:11 AM

APHPDependencyInjectionContainerisatoolthatmanagesclassdependencies,enhancingcodemodularity,testability,andmaintainability.Itactsasacentralhubforcreatingandinjectingdependencies,thusreducingtightcouplingandeasingunittesting.

Dependency Injection vs. Service Locator in PHPMay 13, 2025 am 12:10 AM

Select DependencyInjection (DI) for large applications, ServiceLocator is suitable for small projects or prototypes. 1) DI improves the testability and modularity of the code through constructor injection. 2) ServiceLocator obtains services through center registration, which is convenient but may lead to an increase in code coupling.

PHP performance optimization strategies.May 13, 2025 am 12:06 AM

PHPapplicationscanbeoptimizedforspeedandefficiencyby:1)enablingopcacheinphp.ini,2)usingpreparedstatementswithPDOfordatabasequeries,3)replacingloopswitharray_filterandarray_mapfordataprocessing,4)configuringNginxasareverseproxy,5)implementingcachingwi

PHP Email Validation: Ensuring Emails Are Sent CorrectlyMay 13, 2025 am 12:06 AM

PHPemailvalidationinvolvesthreesteps:1)Formatvalidationusingregularexpressionstochecktheemailformat;2)DNSvalidationtoensurethedomainhasavalidMXrecord;3)SMTPvalidation,themostthoroughmethod,whichchecksifthemailboxexistsbyconnectingtotheSMTPserver.Impl

See all articles