迅睿CMS框架是一款PHP8高性能·简单易用的CMS开源开发框架,基于MIT开源许可协议发布,免费且不限制商业使用,是免费开源的产品,以万端互联为设计理念,支持的微信公众号、小程序、APP客户端、移动端网站、PC网站等多终端式管理系统。
{php $query=urlencode('select * from dede_archives where id in(12,16,14,18)');} {sql db=dede sql='$query'} <p> <a href="{$t.url}" target="_blank" title="{$t.title}"> {$t.title} </a><em>{$t.pubdate}</em> </p> {/sql}
我这个语句为什么报错了,我用id in 方法 我应该怎么改
ERROR - 2021-02-09 12:49:58 --> Error connecting to the database: Access denied for user '****'@'%' to database 'dede' CRITICAL - 2021-02-09 12:49:58 --> Unable to connect to the database. #SQL:SELECT * FROM `dr_1_school` WHERE `dr_1_school`.`catid` = 2 AND `dr_1_school`.`status` = 9 ORDER BY `dr_1_school`.`updatetime` DESC #URL:http://wz.entem.cn/index.php?c=html&m=category&ids=&pp=1 #AGENT:Mozilla/5.0 (Windows NT 10.0 Win64 x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/87.0.4280.66 Safari/537.36 #REFERER:http://wz.entem.cn/admin.php?c=html&m=category_index& #0 /wwwroot/xunruiCMS/dayrui/System/Database/BaseConnection.php(602): CodeIgniter\Database\BaseConnection->initialize() #1 /wwwroot/xunruiCMS/dayrui/Fcms/Core/View.php(2143): CodeIgniter\Database\BaseConnection->query() #2 /wwwroot/xunruiCMS/dayrui/Fcms/Core/View.php(1047): Phpcmf\View->_query() #3 /wwwroot/xunruiCMS/cache/template/template_pc_newmoban_home_xila.html.cache.php(350): Phpcmf\View->list_tag() #4 /wwwroot/xunruiCMS/dayrui/Fcms/Core/View.php(222): include('/wwwroot/xunrui...') #5 /wwwroot/xunruiCMS/dayrui/Fcms/Control/Home/Module.php(215): Phpcmf\View->display() #6 /wwwroot/xunruiCMS/dayrui/Fcms/Control/Home/Module.php(638): Phpcmf\Home\Module->_Category() #7 /wwwroot/xunruiCMS/dayrui/Fcms/Control/Home/Module.php(978): Phpcmf\Home\Module->_Create_Category_Html() #8 /wwwroot/xunruiCMS/dayrui/Core/Controllers/Html.php(15): Phpcmf\Home\Module->_Category_Html() #9 /wwwroot/xunruiCMS/dayrui/System/CodeIgniter.php(931): Phpcmf\Controllers\Html->category() #10 /wwwroot/xunruiCMS/dayrui/System/CodeIgniter.php(427): CodeIgniter\CodeIgniter->runController() #11 /wwwroot/xunruiCMS/dayrui/System/CodeIgniter.php(333): CodeIgniter\CodeIgniter->handleRequest() #12 /wwwroot/xunruiCMS/dayrui/Fcms/Init.php(398): CodeIgniter\CodeIgniter->run() #13 /wwwroot/xunruiCMS/index.php(50): require('/wwwroot/xunrui...') #14 {main}
ERROR - 2021-02-09 14:13:37 --> Error connecting to the database: Access denied for user '****'@'%' to database 'dede' CRITICAL - 2021-02-09 14:13:37 --> Unable to connect to the database. #SQL:SELECT * FROM `dr_1_school` WHERE `dr_1_school`.`catid` = 2 AND `dr_1_school`.`status` = 9 ORDER BY `dr_1_school`.`updatetime` DESC #URL:http://wz.entem.cn/index.php?c=html&m=category&ids=&pp=1 #AGENT:Mozilla/5.0 (Windows NT 10.0 Win64 x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/87.0.4280.66 Safari/537.36 #REFERER:http://wz.entem.cn/admin.php?c=html&m=category_index& #0 /wwwroot/xunruiCMS/dayrui/System/Database/BaseConnection.php(602): CodeIgniter\Database\BaseConnection->initialize() #1 /wwwroot/xunruiCMS/dayrui/Fcms/Core/View.php(2143): CodeIgniter\Database\BaseConnection->query() #2 /wwwroot/xunruiCMS/dayrui/Fcms/Core/View.php(1047): Phpcmf\View->_query() #3 /wwwroot/xunruiCMS/cache/template/template_pc_newmoban_home_xila.html.cache.php(350): Phpcmf\View->list_tag() #4 /wwwroot/xunruiCMS/dayrui/Fcms/Core/View.php(222): include('/wwwroot/xunrui...') #5 /wwwroot/xunruiCMS/dayrui/Fcms/Control/Home/Module.php(215): Phpcmf\View->display() #6 /wwwroot/xunruiCMS/dayrui/Fcms/Control/Home/Module.php(638): Phpcmf\Home\Module->_Category() #7 /wwwroot/xunruiCMS/dayrui/Fcms/Control/Home/Module.php(978): Phpcmf\Home\Module->_Create_Category_Html() #8 /wwwroot/xunruiCMS/dayrui/Core/Controllers/Html.php(15): Phpcmf\Home\Module->_Category_Html() #9 /wwwroot/xunruiCMS/dayrui/System/CodeIgniter.php(931): Phpcmf\Controllers\Html->category() #10 /wwwroot/xunruiCMS/dayrui/System/CodeIgniter.php(427): CodeIgniter\CodeIgniter->runController() #11 /wwwroot/xunruiCMS/dayrui/System/CodeIgniter.php(333): CodeIgniter\CodeIgniter->handleRequest() #12 /wwwroot/xunruiCMS/dayrui/Fcms/Init.php(398): CodeIgniter\CodeIgniter->run() #13 /wwwroot/xunruiCMS/index.php(50): require('/wwwroot/xunrui...') #14 {main}
Error connecting to the database: Access denied for user '****'@'%' to database 'dede'
是我根据这个设置得到 我以为cms2是随便起的 后来通过测试这个要填写数据库名称 已经解决了 谢谢