迅睿CMS框架是一款PHP8高性能·簡(jiǎn)單易用的CMS開(kāi)源開(kāi)發(fā)框架,基于MIT開(kāi)源許可協(xié)議發(fā)布,免費(fèi)且不限制商業(yè)使用,是免費(fèi)開(kāi)源的產(chǎn)品,以萬(wàn)端互聯(lián)為設(shè)計(jì)理念,支持的微信公眾號(hào)、小程序、APP客戶(hù)端、移動(dòng)端網(wǎng)站、PC網(wǎng)站等多終端式管理系統(tǒng)。
聯(lián)系官方銷(xiāo)售客服
1835022288
028-61286886
我用sql查詢(xún)數(shù)據(jù),其中有一個(gè)查詢(xún)條件是變量,請(qǐng)問(wèn)下該如何調(diào)出變量值 呢,cms的sql語(yǔ)句必須在單引號(hào)中使用
{php $sql='SELECT * FROM dr_1_xiutu where "$titles" ORDER BY updatetime DESC'}
各位大神,求幫助
復(fù)制錯(cuò)了
$sql='SELECT * FROM dr_1_xiutu where title like "%$titles%" ORDER BY updatetime DESC'
{php $sql=urlencode('SELECT * FROM dr_1_xiutu where title like "%$titles%" ORDER BY updatetime DESC');} {sql sql='$sql'}
回復(fù)@疾風(fēng)
SQL: SELECT * FROM dr_1_xiutu where title like "%$titles%" ORDER BY updatetime DESC
變量被轉(zhuǎn)成字符串了
{php $sql=urlencode('SELECT * FROM dr_1_xiutu where title like "%'.$titles.'%" ORDER BY updatetime DESC');} {sql sql='$sql'}
復(fù)制錯(cuò)了
回復(fù)@疾風(fēng)
變量被轉(zhuǎn)成字符串了