我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'} 就沒有問題 內(nèi)容什么的 都能出來
然后我測試 {sql sql='select * from @#1_school where id={~$t.diaoqu1~}'} 沒有報錯 但是沒有內(nèi)容 不知道值哪里出錯了
語法錯了
{php $query=urlencode('select * from @#1_school where id='.$t.diaoqu1);} {sql sql='$query'} <div class="ycasedet_info" id="dianhua">參考文檔:《SQL語句循環(huán)》
開源是一種精神,但不是義務(wù),幫忙是情分,不幫也不要抱怨,建議大家多研究代碼、多閱讀代碼、多翻閱社區(qū)歷史問題!
回復(fù)@迅??蚣芗夹g(shù)-景攸 我根據(jù)你改的
{php $query=urlencode('select * from @#1_school where id='.$t.diaoqu1);} {sql sql='$query'} <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: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}
這個變量是從哪里來的?你在錯誤提示的是空值,變量不存在
開源是一種精神,但不是義務(wù),幫忙是情分,不幫也不要抱怨,建議大家多研究代碼、多閱讀代碼、多翻閱社區(qū)歷史問題!
邏輯問題,變量1都不存在,變量2才開始定義的,變量1完全就是空白值
回復(fù)@迅睿框架技術(shù)-景攸
{php $query=urlencode('select * from @#1_school where id='.$t.iddiaoqu);} {sql sql='$query'} <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}依然報錯
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}
五樓所說的非常對,你邏輯是錯誤的
這個變量是從哪里來的?你在錯誤提示的是空值,變量不存在
-------
這個問題你沒有正面回答我
回復(fù)@曉猛seo
開源是一種精神,但不是義務(wù),幫忙是情分,不幫也不要抱怨,建議大家多研究代碼、多閱讀代碼、多翻閱社區(qū)歷史問題!
回復(fù)@易學(xué)習(xí)
{php $query=urlencode('select * from @#1_school where id='.$t.iddiaoqu);}iddiaoqu 這個字段里面是數(shù)字,diaoqu1 、diaoqu2 這兩個字段的內(nèi)容是 漢字 和字母 我現(xiàn)在報錯這個
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}這個是我設(shè)置的字段
回復(fù)@迅??蚣芗夹g(shù)-景攸

這個問題你沒有正面回答我啊
---我換一個問法
---------
{php $query=urlencode('select * from @#1_school where id='.$t.iddiaoqu);}其中
是讀取的哪里數(shù)據(jù),
或者是內(nèi)容頁showl.lhtml當(dāng)前的
字段嗎??
開源是一種精神,但不是義務(wù),幫忙是情分,不幫也不要抱怨,建議大家多研究代碼、多閱讀代碼、多翻閱社區(qū)歷史問題!
回復(fù)@迅睿框架技術(shù)-景攸 $t.iddiaoqu 字段是 @#_schoolnews 表里面的字段
{php $query=urlencode('select * from @#1_school where id='.$t.iddiaoqu);} {sql sql='$query'} <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}而
{$t.dianqu1} 和 {$t.dizhi} 是在@#_school 這個表里面哎,算了,我無能為力了,一點(diǎn)兒都不配合,任然沒有正面回答我的問題,根本不知道這個參數(shù)從哪里獲取的,不然他永遠(yuǎn)是空白的,你只能寫死值
開源是一種精神,但不是義務(wù),幫忙是情分,不幫也不要抱怨,建議大家多研究代碼、多閱讀代碼、多翻閱社區(qū)歷史問題!
他邏輯有問題,樓主可以私聊QQ我,數(shù)據(jù)調(diào)用我還是比較在行的
回復(fù)@迅??蚣芗夹g(shù)-景攸 對不起呀 朋友 原諒我是一個小白 您剛才說的 $t.iddiaoqu 字段是從 @#1_schoolnews 數(shù)據(jù)表里面獲取的 不知道是您想要大結(jié)果不
回復(fù)@易學(xué)習(xí) 我私聊您了