帝国CMS 批量修改字段内容sql语句
在后台系统-执行sql语句update phome_ecms_download set titleurl=replace(titleurl,'http://www.daixiao360.cn','http://127.0.0.1');update phome_ecms_download set titlepic=replace(titlepic,'http://www.daixi……
在后台系统-执行sql语句
update phome_ecms_download set titleurl=replace(titleurl,'http://www.daixiao360.cn','http://127.0.0.1');update phome_ecms_download set titlepic=replace(titlepic,'http://www.daixiao360.cn','http://127.0.0.1');update phome_ecms_download set username=REPLACE(username,'admin','发布者') WHERE id BETWEEN 1 AND 100; 指定批量修改ID=1-100;update phome_ecms_download set userid=REPLACE(userid,'1','55'),username=REPLACE(username,'admin','改变'),ismember=REPLACE(ismember,'0','1') WHERE id BETWEEN 1 AND 100; 一次批量修改三个字段- 上一篇
帝国CMS统计今日文章数,昨日文章数,总文章数,会员数,最新会员
<?php$members=$empire->gettotal("select count(*) as total from phome_enewsmember");$newmember=$empire->fetch1("select userid,username from phome_enewsmember order by userid desc limit 1");$tzcount=$em
- 下一篇
帝国CMS批量更新标题首字母
以下代码加到自定义页面即可运行生成新闻标题的首字母<?$sql=$empire->query("select id,title from {$dbtbpre}ecms_news where id>5000 order by id limit 1000");while($r=$empire->fetch($sql)){if($r[title]){$z