Can phpcms use sql statements?

phpcms can use sql statements. Commonly used sql statements are as follows:

Set the workflow of all columns of the website to first-level review:

update v9_category set setting=REPLACE(setting,"'workflowid' => '',","'workflowid' => '1',")

Enter the website background to update the cache, and then try adding an article. When publishing an article, is there an additional review option in the status in the lower right corner?

SQL statement to change user name:

UPDATE `v9_admin` SET `username` = 'phpcms' WHERE `v9_admin`.`userid` =1 LIMIT 1 ;
UPDATE `v9_news` SET `username` = 'phpcms';

The first sentence modifies the user name of the user group, and the second sentence is the user name in the article.

Related recommendations: phpcms tutorial

The above is the detailed content of Can phpcms use sql statements?. For more information, please follow other related articles on the PHP Chinese website!