{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}
{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}转换后的截图还是两段啊 是什么原因呢
{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}