聯系官方銷售客服
1835022288
028-61286886
我sql語句條件語句是這個
{sql sql='select * from @#1_school where id={$t.diaoqu1}'} <div class="ycasedet_info" id="dianhua"> <p>答:{$t.dianqu1}位于{$t.dizhi}位置,下面是小編個人整理的位置地圖,希望可以幫助到您</p><p><img src="{dr_get_file($t.weizhitupian)}" alt="{$t.title}位置圖" /></p> </div> {/sql}
報錯是這個
ERROR - 2021-02-03 10:30:05 --> You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near '=<?php echo ; ?>' at line 1 #SQL:select * from dr_1_school where id=<?php echo ; ?> #URL:http://wz.entem.cn/index.php?s=schoolnews&c=html&m=show&catids=2&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[]=2 #0 /wwwroot/xunruiCMS/dayrui/System/Database/MySQLi/Connection.php(314): mysqli->query() #1 /wwwroot/xunruiCMS/dayrui/System/Database/BaseConnection.php(697): CodeIgniter\Database\MySQLi\Connection->execute() #2 /wwwroot/xunruiCMS/dayrui/System/Database/BaseConnection.php(625): CodeIgniter\Database\BaseConnection->simpleQuery() #3 /wwwroot/xunruiCMS/dayrui/Fcms/Core/View.php(2143): CodeIgniter\Database\BaseConnection->query() #4 /wwwroot/xunruiCMS/dayrui/Fcms/Core/View.php(1047): Phpcmf\View->_query() #5 /wwwroot/xunruiCMS/cache/template/template_pc_newmoban_home_schoolnews_show-weizhi.html.cache.php(38): Phpcmf\View->list_tag() #6 /wwwroot/xunruiCMS/dayrui/Fcms/Core/View.php(222): include('/wwwroot/xunrui...') #7 /wwwroot/xunruiCMS/dayrui/Fcms/Control/Home/Module.php(437): Phpcmf\View->display() #8 /wwwroot/xunruiCMS/dayrui/Fcms/Control/Home/Module.php(684): Phpcmf\Home\Module->_Show() #9 /wwwroot/xunruiCMS/dayrui/Fcms/Control/Home/Module.php(912): Phpcmf\Home\Module->_Create_Show_Html() #10 /wwwroot/xunruiCMS/dayrui/App/Schoolnews/Controllers/Html.php(22): Phpcmf\Home\Module->_Show_Html() #11 /wwwroot/xunruiCMS/dayrui/System/CodeIgniter.php(931): Phpcmf\Controllers\Html->show() #12 /wwwroot/xunruiCMS/dayrui/System/CodeIgniter.php(427): CodeIgniter\CodeIgniter->runController() #13 /wwwroot/xunruiCMS/dayrui/System/CodeIgniter.php(333): CodeIgniter\CodeIgniter->handleRequest() #14 /wwwroot/xunruiCMS/dayrui/Fcms/Init.php(398): CodeIgniter\CodeIgniter->run() #15 /wwwroot/xunruiCMS/index.php(50): require('/wwwroot/xunrui...') #16 {main}
我測試
{sql sql='select * from @#1_school where id=1'} 就沒有問題 內容什么的 都能出來 然后我測試 {sql sql='select * from @#1_school where id={~$t.diaoqu1~}'} 沒有報錯 但是沒有內容 不知道值哪里出錯了
語法錯了
參考文檔:《SQL語句循環》
回復@迅睿框架技術-景攸 我根據你改的
還是報錯
ERROR - 2021-02-03 10:50:08 --> You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near '' at line 1
#SQL:select * from dr_1_school where id=
#URL:http://wz.entem.cn/index.php?s=schoolnews&c=html&m=show&catids=2&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=2
#0 /wwwroot/xunruiCMS/dayrui/System/Database/MySQLi/Connection.php(314): mysqli->query()
#1 /wwwroot/xunruiCMS/dayrui/System/Database/BaseConnection.php(697): CodeIgniter\Database\MySQLi\Connection->execute()
#2 /wwwroot/xunruiCMS/dayrui/System/Database/BaseConnection.php(625): CodeIgniter\Database\BaseConnection->simpleQuery()
#3 /wwwroot/xunruiCMS/dayrui/Fcms/Core/View.php(2143): CodeIgniter\Database\BaseConnection->query()
#4 /wwwroot/xunruiCMS/dayrui/Fcms/Core/View.php(1047): Phpcmf\View->_query()
#5 /wwwroot/xunruiCMS/cache/template/template_pc_newmoban_home_schoolnews_show-weizhi.html.cache.php(40): Phpcmf\View->list_tag()
#6 /wwwroot/xunruiCMS/dayrui/Fcms/Core/View.php(222): include('/wwwroot/xunrui...')
#7 /wwwroot/xunruiCMS/dayrui/Fcms/Control/Home/Module.php(437): Phpcmf\View->display()
#8 /wwwroot/xunruiCMS/dayrui/Fcms/Control/Home/Module.php(684): Phpcmf\Home\Module->_Show()
#9 /wwwroot/xunruiCMS/dayrui/Fcms/Control/Home/Module.php(912): Phpcmf\Home\Module->_Create_Show_Html()
#10 /wwwroot/xunruiCMS/dayrui/App/Schoolnews/Controllers/Html.php(22): Phpcmf\Home\Module->_Show_Html()
#11 /wwwroot/xunruiCMS/dayrui/System/CodeIgniter.php(931): Phpcmf\Controllers\Html->show()
#12 /wwwroot/xunruiCMS/dayrui/System/CodeIgniter.php(427): CodeIgniter\CodeIgniter->runController()
#13 /wwwroot/xunruiCMS/dayrui/System/CodeIgniter.php(333): CodeIgniter\CodeIgniter->handleRequest()
#14 /wwwroot/xunruiCMS/dayrui/Fcms/Init.php(398): CodeIgniter\CodeIgniter->run()
#15 /wwwroot/xunruiCMS/index.php(50): require('/wwwroot/xunrui...')
#16 {main}
這個變量是從哪里來的?你在錯誤提示的是空值,變量不存在
邏輯問題,變量1都不存在,變量2才開始定義的,變量1完全就是空白值
回復@迅??蚣芗夹g-景攸
依然報錯
CRITICAL - 2021-02-03 11:04:52 --> syntax error, unexpected 'iddiaoqu' (T_STRING), expecting ')'
#SQL:SELECT * FROM `dr_1_schoolnews` WHERE `catid` = 2 AND `status` = 9 AND `id` > 36 ORDER BY `id` asc LIMIT 1
#URL:http://wz.entem.cn/index.php?s=schoolnews&c=html&m=show&catids=2&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=2
#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}
五樓所說的非常對,你邏輯是錯誤的
這個變量是從哪里來的?你在錯誤提示的是空值,變量不存在
-------
這個問題你沒有正面回答我
回復@曉猛seo
回復@易學習
iddiaoqu 這個字段里面是數字,diaoqu1 、diaoqu2 這兩個字段的內容是 漢字 和字母 我現在報錯這個
這個是我設置的字段
回復@迅??蚣芗夹g-景攸

這個問題你沒有正面回答我啊
---我換一個問法
---------
其中
是讀取的哪里數據,
或者是內容頁showl.lhtml當前的
字段嗎??
回復@迅睿框架技術-景攸 $t.iddiaoqu 字段是 @#_schoolnews 表里面的字段
而
哎,算了,我無能為力了,一點兒都不配合,任然沒有正面回答我的問題,根本不知道這個參數從哪里獲取的,不然他永遠是空白的,你只能寫死值
他邏輯有問題,樓主可以私聊QQ我,數據調用我還是比較在行的
回復@迅??蚣芗夹g-景攸 對不起呀 朋友 原諒我是一個小白 您剛才說的 $t.iddiaoqu 字段是從 @#1_schoolnews 數據表里面獲取的 不知道是您想要大結果不
回復@易學習 我私聊您了