聯(lián)系官方銷(xiāo)售客服
1835022288
028-61286886
我sql語(yǔ)句條件語(yǔ)句是這個(gè)
{sql sql='select * from @#1_school where id={$t.diaoqu1}'} <div class="ycasedet_info" id="dianhua"> <p>答:{$t.dianqu1}位于{$t.dizhi}位置,下面是小編個(gè)人整理的位置地圖,希望可以幫助到您</p><p><img src="{dr_get_file($t.weizhitupian)}" alt="{$t.title}位置圖" /></p> </div> {/sql}
報(bào)錯(cuò)是這個(gè)
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}
我測(cè)試
{sql sql='select * from @#1_school where id=1'} 就沒(méi)有問(wèn)題 內(nèi)容什么的 都能出來(lái) 然后我測(cè)試 {sql sql='select * from @#1_school where id={~$t.diaoqu1~}'} 沒(méi)有報(bào)錯(cuò) 但是沒(méi)有內(nèi)容 不知道值哪里出錯(cuò)了
語(yǔ)法錯(cuò)了
參考文檔:《SQL語(yǔ)句循環(huán)》
回復(fù)@迅??蚣芗夹g(shù)-景攸 我根據(jù)你改的
還是報(bào)錯(cuò)
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}
這個(gè)變量是從哪里來(lái)的?你在錯(cuò)誤提示的是空值,變量不存在
邏輯問(wèn)題,變量1都不存在,變量2才開(kāi)始定義的,變量1完全就是空白值
回復(fù)@迅睿框架技術(shù)-景攸
依然報(bào)錯(cuò)
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}
五樓所說(shuō)的非常對(duì),你邏輯是錯(cuò)誤的
這個(gè)變量是從哪里來(lái)的?你在錯(cuò)誤提示的是空值,變量不存在
-------
這個(gè)問(wèn)題你沒(méi)有正面回答我
回復(fù)@曉猛seo
回復(fù)@易學(xué)習(xí)
iddiaoqu 這個(gè)字段里面是數(shù)字,diaoqu1 、diaoqu2 這兩個(gè)字段的內(nèi)容是 漢字 和字母 我現(xiàn)在報(bào)錯(cuò)這個(gè)
這個(gè)是我設(shè)置的字段
回復(fù)@迅睿框架技術(shù)-景攸

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