How to delete content in dedecms

Dedecms method to delete content: 1. Log in to the website backend, click "System" -> "SQL Command Line Tool"; 2. In the page that opens, execute the SQL command "delete dede_addonarticle, dede_archives" ,dede_arctiny from..." That's it.

The operating environment of this tutorial: Windows 10 system, DedeCMS version 5.7, Dell G3 computer.

dedecmsHow to delete content?

Quickly and completely delete the article content of Dreamweaver:

1. How to clear the article content in Dreamweaver’s recycle bin with one click?

Dreamweaver cms recycle bin can select all and delete only the current page. If there are hundreds of pages, it will need to be operated hundreds of times. Needless to say, it is cumbersome. How to delete all the files in the recycle bin at once? Deleting content in bulk?

1. If the database can be managed, delete it directly in the database. If it cannot be managed, you can use the sql command to execute it.

2. Use the sql command to complete it and log in to the website background. Click "System" → "SQL Command Line Tool", in the page that opens, enter the following command in the sql command on the right

delete dede_addonarticle,dede_archives,dede_arctiny from dede_addonarticle,dede_archives,dede_arctiny where dede_addonarticle.aid=dede_archives.id and dede_arctiny.id=dede_archives.id and dede_archives.arcrank='-2'

Note: Change the data table prefix to your own

and confirm directly. When the sql command is run, it will prompt that the execution is successful, and then you can check the recycle bin. Please note that when executing any sql command, please make a backup yourself!

2. How to delete articles without entering the recycle bin by Dreamweaver dedecms

Sometimes deleting articles does not require the recycle bin, we can turn off this function

The closing method is as follows, so that you will not have to clear the recycle bin in a tedious manner

Click System Settings-"Core Settings-"Article Recycle Bin "Select No"

3. Modification of the default number of DEDECMS backend article lists

The default number of DEDECMS backend article lists is 30, as shown below

No problem under normal circumstances, but if I want to delete hundreds or thousands of articles, I can only choose to delete up to 30 articles at a time, which requires multiple operations. For example, collect articles from a certain column. Wait for the collection to be completed. All the collected articles contain problems. You need to delete all the articles you just collected. After looking at more than a hundred pages, if you delete 30 articles per page, you will probably be too weak to delete them. The following method can increase the number of displayed items.

Open dede/content_list.php, search

$dlist->pageSize = 30;

and change the default 30 to 300. In the future, 300 articles will be displayed on each page when opening the article list. The number can be set by yourself, but if this value If the setting is too large, loading will be very slow. Add more according to your needs.

Similarly, if you want to delete junk registered members in batches. Just open dede\templets\member_main.htm, find dede:config.pagesize value=”30″, and change 30 to the amount you need.

After the deletion is completed, modify it back. After all, if too much is displayed, the background will load very slowly.

Recommended learning: dedecms tutorial

The above is the detailed content of How to delete content in dedecms. For more information, please follow other related articles on the PHP Chinese website!