迅睿開(kāi)源框架是一款PHP8高性能·簡(jiǎn)單易用的PHP開(kāi)源開(kāi)發(fā)框架, 基于MIT開(kāi)源許可協(xié)議發(fā)布,不限制商業(yè)使用,以多端互聯(lián)為設(shè)計(jì)理念, 支持的微信公眾號(hào)、小程序、APP客戶(hù)端、移動(dòng)端網(wǎng)站、PC網(wǎng)站等多終端式管理系統(tǒng)。
業(yè)務(wù)經(jīng)理
微信掃描以上二維碼
028-61286886
技術(shù)咨詢(xún)
我用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ò)了
{php $sql=urlencode('SELECT * FROM dr_1_xiutu where title like "%$titles%" ORDER BY updatetime DESC');} {sql sql='$sql'}回復(fù)@疾風(fēng)
變量被轉(zhuǎn)成字符串了
{php $sql=urlencode('SELECT * FROM dr_1_xiutu where title like "%'.$titles.'%" ORDER BY updatetime DESC');} {sql sql='$sql'}