{php $query=urlencode('select * from @#1_school join @#1_schoolnews on @#1_schoolnews.iddiaoqu=@#1_school.id where @#1_school.id='.$iddiaoqu limit 1);}
報錯了
CRITICAL - 2021-02-03 17:08:54 --> syntax error, unexpected 'limit' (T_STRING), expecting ')'
#SQL:SELECT * FROM `dr_1_schoolnews` WHERE `catid` = 3 AND `status` = 9 AND `id` > 50 ORDER BY `id` asc LIMIT 1
#URL:http://wz.entem.cn/index.php?s=schoolnews&c=html&m=show&catids=3&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=show_index&app=schoolnews&pagesize=10&id_form=&id_to=&date_form=&date_to=&catids%5B%5D=3
#0 /wwwroot/xunruiCMS/dayrui/Fcms/Control/Home/Module.php(437): Phpcmf\View->display()
#1 /wwwroot/xunruiCMS/dayrui/Fcms/Control/Home/Module.php(684): Phpcmf\Home\Module->_Show()
#2 /wwwroot/xunruiCMS/dayrui/Fcms/Control/Home/Module.php(912): Phpcmf\Home\Module->_Create_Show_Html()
#3 /wwwroot/xunruiCMS/dayrui/App/Schoolnews/Controllers/Html.php(22): Phpcmf\Home\Module->_Show_Html()
#4 /wwwroot/xunruiCMS/dayrui/System/CodeIgniter.php(931): Phpcmf\Controllers\Html->show()
#5 /wwwroot/xunruiCMS/dayrui/System/CodeIgniter.php(427): CodeIgniter\CodeIgniter->runController()
#6 /wwwroot/xunruiCMS/dayrui/System/CodeIgniter.php(333): CodeIgniter\CodeIgniter->handleRequest()
#7 /wwwroot/xunruiCMS/dayrui/Fcms/Init.php(398): CodeIgniter\CodeIgniter->run()
#8 /wwwroot/xunruiCMS/index.php(50): require('/wwwroot/xunrui...')
#9 {main}
參考文檔:《html實體字符轉(zhuǎn)換函數(shù)》
開源是一種精神,但不是義務(wù),幫忙是情分,不幫也不要抱怨,建議大家多研究代碼、多閱讀代碼、多翻閱社區(qū)歷史問題!
回復(fù)@迅??蚣芗夹g(shù)-張洪 我轉(zhuǎn)換完了 為什么是兩段內(nèi)容呢 這是我的代碼
{php $query=urlencode('select * from @#1_school join @#1_schoolnews on @#1_schoolnews.iddiaoqu=@#1_school.id where @#1_school.id='.$iddiaoqu);} {sql sql='$query'} <div class="ycasedet_info" id="dianhua"> {dr_code2html($t.rxtj, true)} </div> {/sql}轉(zhuǎn)換后的截圖
還是兩段啊 是什么原因呢
說明你這個sql查詢了兩條數(shù)據(jù)出來,加一個limit 1就只顯示一條了
回復(fù)@六月珄
{php $query=urlencode('select * from @#1_school join @#1_schoolnews on @#1_schoolnews.iddiaoqu=@#1_school.id where @#1_school.id='.$iddiaoqu limit 1);}報錯了
CRITICAL - 2021-02-03 17:08:54 --> syntax error, unexpected 'limit' (T_STRING), expecting ')' #SQL:SELECT * FROM `dr_1_schoolnews` WHERE `catid` = 3 AND `status` = 9 AND `id` > 50 ORDER BY `id` asc LIMIT 1 #URL:http://wz.entem.cn/index.php?s=schoolnews&c=html&m=show&catids=3&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=show_index&app=schoolnews&pagesize=10&id_form=&id_to=&date_form=&date_to=&catids%5B%5D=3 #0 /wwwroot/xunruiCMS/dayrui/Fcms/Control/Home/Module.php(437): Phpcmf\View->display() #1 /wwwroot/xunruiCMS/dayrui/Fcms/Control/Home/Module.php(684): Phpcmf\Home\Module->_Show() #2 /wwwroot/xunruiCMS/dayrui/Fcms/Control/Home/Module.php(912): Phpcmf\Home\Module->_Create_Show_Html() #3 /wwwroot/xunruiCMS/dayrui/App/Schoolnews/Controllers/Html.php(22): Phpcmf\Home\Module->_Show_Html() #4 /wwwroot/xunruiCMS/dayrui/System/CodeIgniter.php(931): Phpcmf\Controllers\Html->show() #5 /wwwroot/xunruiCMS/dayrui/System/CodeIgniter.php(427): CodeIgniter\CodeIgniter->runController() #6 /wwwroot/xunruiCMS/dayrui/System/CodeIgniter.php(333): CodeIgniter\CodeIgniter->handleRequest() #7 /wwwroot/xunruiCMS/dayrui/Fcms/Init.php(398): CodeIgniter\CodeIgniter->run() #8 /wwwroot/xunruiCMS/index.php(50): require('/wwwroot/xunrui...') #9 {main}你這是多表查詢,沒寫好是有可能查出重復(fù)結(jié)果的。
最好先用其他軟件,單獨試一下這個sql語句,改好了再移過來
回復(fù)@臥龍隱者 我把輸出的那個字段 $t.rxtj 換成 文本字段 就顯示一條數(shù)據(jù) 換成 html 類型的就顯示兩個 不知道什么原因
私聊QQ 幫你弄
應(yīng)該是查詢出來兩條,如果在服務(wù)器上,清理一下緩存。本地也清理一下。