聯(lián)系官方銷售客服
1835022288
028-61286886
投訴
已解決 我這個語句為什么報錯了我用方法我應(yīng)該怎么改
6 0
{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 方法 我應(yīng)該怎么改
這個寫法沒有任何錯誤，看看你錯誤截圖
回復(fù)@迅?？蚣芗夹g(shù)-吳金輝
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}無法連接到數(shù)據(jù)庫dede，檢查賬號和密碼。
回復(fù)@迅?？蚣芗夹g(shù)-吳金輝 我檢查了 賬號和密碼 沒有問題 我測試用Navicat 工具連接數(shù)據(jù)庫 也正常 但是就不知道為什么會報錯
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}連不上數(shù)據(jù)庫dede，密碼哪里錯了吧
回復(fù)@易學(xué)習(xí)
是我根據(jù)這個設(shè)置得到 我以為cms2是隨便起的 后來通過測試這個要填寫數(shù)據(jù)庫名稱 已經(jīng)解決了 謝謝