javascript - php将图文文章保存在text字段里好还是将生成一个html文件还是其他办法？-PHP Tutorial-php.cn

Home

Backend Development

PHP Tutorial

javascript - php将图文文章保存在text字段里好还是将生成一个html文件还是其他办法？

WBOYWBOYWBOYWBOYWBOYWBOYWBOYWBOYWBOYWBOYWBOYWBOYWB

Jun 06, 2016 pm 08:41 PM

javascriptmysqlphp

请一个实战的方案？
我用的是ueditor

回复内容：

请一个实战的方案？
我用的是ueditor

生成文件的话，就是内容”静态化“了，那修改，删除的时候应该会麻烦点吧。
放text字段里的顾虑是内容太多查询会慢？
个人觉得应该跟站点类型有关，如果是博客，不轻易改动的内容，静态没什么问题，如果流量小，数据库查询text也没什么问题。

一般来说，在一个文章系统里面。是两种方式结合起来的。而跟你使用ueditor,'veditor'都没有关系.

比如你有一片文章，对应的html 内容可能是

文字 javascript - php将图文文章保存在text字段里好还是将生成一个html文件还是其他办法？又是文字

对应的标题可能是 xxx文章

那么你在数据库里面可能会存储一个 title,一个content。对应的数据库记录的ID是100.

那么可能有，read.php?id=100 查询出来，你这篇文章，然后根据一定的规则生成一篇对应的文章---此时的文章，还属于动态的（即便后端使用缓存）。

但是，一篇动态文章，每次都访问数据库，是不划算的，你可以索性将他声称一个 xxx.html。然后下次来访问的时候，你就直接“读取”或者“重定向”等方式，直接访问xxx.html。

类似的cms系统，博客系统，一般都会有这样的策略。

保存在表里好，因为好管理

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 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

How to make PHP applications fasterMay 12, 2025 am 12:12 AM

TomakePHPapplicationsfaster,followthesesteps:1)UseOpcodeCachinglikeOPcachetostoreprecompiledscriptbytecode.2)MinimizeDatabaseQueriesbyusingquerycachingandefficientindexing.3)LeveragePHP7 Featuresforbettercodeefficiency.4)ImplementCachingStrategiessuc

PHP Performance Optimization Checklist: Improve Speed NowMay 12, 2025 am 12:07 AM

ToimprovePHPapplicationspeed,followthesesteps:1)EnableopcodecachingwithAPCutoreducescriptexecutiontime.2)ImplementdatabasequerycachingusingPDOtominimizedatabasehits.3)UseHTTP/2tomultiplexrequestsandreduceconnectionoverhead.4)Limitsessionusagebyclosin

PHP Dependency Injection: Improve Code TestabilityMay 12, 2025 am 12:03 AM

Dependency injection (DI) significantly improves the testability of PHP code by explicitly transitive dependencies. 1) DI decoupling classes and specific implementations make testing and maintenance more flexible. 2) Among the three types, the constructor injects explicit expression dependencies to keep the state consistent. 3) Use DI containers to manage complex dependencies to improve code quality and development efficiency.

PHP Performance Optimization: Database Query OptimizationMay 12, 2025 am 12:02 AM

DatabasequeryoptimizationinPHPinvolvesseveralstrategiestoenhanceperformance.1)Selectonlynecessarycolumnstoreducedatatransfer.2)Useindexingtospeedupdataretrieval.3)Implementquerycachingtostoreresultsoffrequentqueries.4)Utilizepreparedstatementsforeffi

See all articles