{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}我這個(gè)語(yǔ)句為什么報(bào)錯(cuò)了,我用id in 方法 我應(yīng)該怎么改
這個(gè)寫法沒(méi)有任何錯(cuò)誤,看看你錯(cuò)誤截圖
開源是一種精神,但不是義務(wù),幫忙是情分,不幫也不要抱怨,建議大家多研究代碼、多閱讀代碼、多翻閱社區(qū)歷史問(wèn)題!
回復(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}無(wú)法連接到數(shù)據(jù)庫(kù)dede,檢查賬號(hào)和密碼。
開源是一種精神,但不是義務(wù),幫忙是情分,不幫也不要抱怨,建議大家多研究代碼、多閱讀代碼、多翻閱社區(qū)歷史問(wèn)題!
回復(fù)@迅??蚣芗夹g(shù)-吳金輝 我檢查了 賬號(hào)和密碼 沒(méi)有問(wèn)題 我測(cè)試用Navicat 工具連接數(shù)據(jù)庫(kù) 也正常 但是就不知道為什么會(huì)報(bào)錯(cuò)
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ù)庫(kù)dede,密碼哪里錯(cuò)了吧
回復(fù)@易學(xué)習(xí)

是我根據(jù)這個(gè)設(shè)置得到 我以為cms2是隨便起的 后來(lái)通過(guò)測(cè)試這個(gè)要填寫數(shù)據(jù)庫(kù)名稱 已經(jīng)解決了 謝謝