ppypp伦理天堂,91手机在线视频,免费在线观看黄色毛片,夜夜穞天天穞狠狠穞AV美女按摩

聯系官方銷售客服

1835022288

028-61286886

投訴 已解決 我語句條件語句是這個答位于位置下面是小編個人整理的位置地圖希 14 0
迅睿CMS版本:4.3.13 懸賞:10元

我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~}'}   沒有報錯  但是沒有內容  不知道值哪里出錯了
解決方案
  • 語法錯了

    {php $query=urlencode('select * from @#1_school where id='.$t.diaoqu1);}
    {sql sql='$query'} 
    <div class="ycasedet_info" id="dianhua">

    參考文檔:《SQL語句循環》

  • 回復@迅睿框架技術-景攸 我根據你改的

    {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}

    不怕神一樣的對手就怕豬一樣的隊友
  • $t.diaoqu1

    這個變量是從哪里來的?你在錯誤提示的是空值,變量不存在

  • 回復@迅??蚣芗夹g-景攸

    {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}

    不怕神一樣的對手就怕豬一樣的隊友
  • 回復@易學習

    {php $query=urlencode('select * from @#1_school where id='.$t.iddiaoqu);}

    iddiaoqu 這個字段里面是數字,diaoqu1 、diaoqu2 這兩個字段的內容是 漢字 和字母 我現在報錯這個

    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}



    這個是我設置的字段

    不怕神一樣的對手就怕豬一樣的隊友
  • 回復@迅??蚣芗夹g-景攸

    不怕神一樣的對手就怕豬一樣的隊友
  • 這個問題你沒有正面回答我啊

    ---我換一個問法

    ---------

    {php $query=urlencode('select * from @#1_school where id='.$t.iddiaoqu);}

    其中

    $t.iddiaoqu

    是讀取的哪里數據,

    或者是內容頁showl.lhtml當前的

    iddiaoqu

    字段嗎??

  • 回復@迅睿框架技術-景攸 $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 這個表里面
    不怕神一樣的對手就怕豬一樣的隊友
  • 哎,算了,我無能為力了,一點兒都不配合,任然沒有正面回答我的問題,根本不知道這個參數從哪里獲取的,不然他永遠是空白的,你只能寫死值

  • 回復@迅??蚣芗夹g-景攸 對不起呀 朋友 原諒我是一個小白 您剛才說的 $t.iddiaoqu 字段是從 @#1_schoolnews 數據表里面獲取的 不知道是您想要大結果不

    不怕神一樣的對手就怕豬一樣的隊友
  • 回復@易學習 我私聊您了

    滿意答案
    (溫馨提醒:滿意答案給自己不贈送懸賞金額)
    不怕神一樣的對手就怕豬一樣的隊友
  • 增加懸賞(設置懸賞)金:10元,希望大家給予幫助!
    不怕神一樣的對手就怕豬一樣的隊友
  • @曉猛seo:已經解決了 是語法的問題
    不怕神一樣的對手就怕豬一樣的隊友