In which table does PHPCMS article data exist?

# In which table does PHPCMS article data exist?

PHPCMS article additional data is stored in the "phpcms_c_news" table, and the main content data is stored in the "phpcms_content" table. The data in "phpcms_content" is all content data. When querying article data, just query "phpcms_c_news" "That's it.

PHPCMS

Phpcms is the leading website content management system in China and an open source PHP development framework. Phpcms is composed of more than 20 functional modules such as content model, membership, Q&A, special topics, finance, orders, advertising, email subscription, short messages, custom forms, and site-wide search. It has built-in news, pictures, downloads, information, and products 5 Big content model. Phpcms adopts modular development, supports custom content models and membership models, and can customize fields.

In today's ever-changing market environment, fast and efficient IT solutions are the key to your business success. We at PHPCMS are proud to be able to tailor solutions that fully meet your needs. Using our systems, we can make your business more efficient and gain greater profits in the market. Our long-term successful experience in the CMS field has made us the leader in the domestic CMS field. The services we provide you include: PHPCMS commercial authorization, program customization, data conversion, and video storage services. Join hands with PHPCMS to reach new heights in your career.

PHPCMS Features

Modular, open source, extensible

Developed in a modular way, providing custom models and module development interfaces, and Completely open source, easy for secondary development.

Powerful and flexible, supports custom models and fields

is composed of more than 20 functional modules such as content model, membership model, question bar, order, finance, etc., and has built-in news, pictures, downloads 5 commonly used models: , information and products.

Strong load capacity, supports tens of millions of data

Based on the many years of development experience of the Phpcms team, optimization is carried out from multiple perspectives such as caching technology, database design, code optimization, etc. It can store text in the content , supports tens of millions of data volumes, and fully ensures large and medium-sized applications and long-term development.

The template is easy to make and supports Chinese tags and universal tags for data calls

Adopts the MVC design pattern to achieve complete separation of programs and templates, supports Chinese tags in the {tag_focus news} format, and at the same time It also supports universal tags, which are suitable for artists and programmers. Data from this system can also be called from other mysql databases to easily integrate data from multiple website applications.

Has portal-level fragmentation function, supports visual preview and editing

For the first time, the portal-level fragmentation function is free and open sourced to small and medium-sized websites. It integrates the permission mechanism and supports complete visual addition in the background. Preview and edit can be traced back to any historical version, which is very suitable for maintaining website homepage, columns and topic pages.

Support recommendation function, easily achieve accurate delivery of the best content of the website

Commercial websites publish a large amount of information every day, but the homepage and the homepage of each channel are limited. If the best content is pushed to these golden Location is at the forefront of what editors do every day. The recommendation function integrates the permission mechanism, and allows editors to push information to the designated location at any time, and can also remove information from the designated location at any time. The operation is simple and practical.

Supports order and financial functions, and has a member charging mechanism

The order system can be automatically linked to the product model, and supports multiple payment and recharge mechanisms such as online payment, bank transfer, and point card recharge, making it easy Implement online store functionality. VIP membership annual and monthly services can be set up. Users can purchase completely by themselves, and the service will be automatically canceled when it expires. You can continue to enjoy it by renewing, similar to QQ's membership mechanism.

Can be integrated with a variety of systems to provide a complete website building solution

Can be integrated with Ucenter, PHPWIND, Dvbbs and other products to achieve membership system integration, and can be integrated with Alipay, Tenpay, and online banking Many payment platforms enable online payment, it can generate Baidu/Google maps for search engines to quickly include, it can generate Baidu Internet News Protocol for Baidu to quickly include news information, and it can also call any mysql database through universal tags.

Integrated into humanized experience

Supports the editor to automatically save data at regular intervals and can be restored at any time; supports previewing of information before publishing, with the same effect as actual publishing; supports full visual preview and modification of fragments; supports The editor can upload multiple images and can freely crop and zoom; there is no need to enter a verification code when logging in for the first time in the front or backend, and a verification code is only required after an error is entered, ensuring security while reducing user operations. The background navigation map shows all functions at a glance; menu search, enter keywords and relevant menus will be automatically listed.

Strengthened security mechanism

Can carry out Trojan scanning, so that website Trojans have nowhere to hide; can change the background entry file name; can limit the IP range of background login; can limit the same account from multiple users at the same time You can log in at any time; you can set up multiple consecutive background login failures to lock the IP; you can enable the anti-swipe mechanism to prevent CC attacks; you can automatically block illegal information; you have added security filtering to prevent xss cross-site attacks and SQL injection attacks.

Recommended tutorial: "PHPCMS Tutorial"

The above is the detailed content of In which table does PHPCMS article data exist?. For more information, please follow other related articles on the PHP Chinese website!