我用查询数据其中有一个查询条件是变量请问下该如何调出变量值呢

迅睿框架更新 2019-11-23 11:44:05

kouyuxin

我用sql查询数据，其中有一个查询条件是变量，请问下该如何调出变量值呢，cms的sql语句必须在单引号中使用

{php $sql='SELECT * FROM dr_1_xiutu where "$titles" ORDER BY updatetime DESC'}

各位大神，求帮助

方案

kouyuxin #1 · 2019-11-23 09:42:38

复制错了

$sql='SELECT * FROM dr_1_xiutu where title like "%$titles%" ORDER BY updatetime DESC'

疾风 #2 · 2019-11-23 10:17:38

{php $sql=urlencode('SELECT * FROM dr_1_xiutu where title like "%$titles%" ORDER BY updatetime DESC');}
{sql sql='$sql'}

kouyuxin #3 · 2019-11-23 10:40:35

疾风

SQL: SELECT * FROM dr_1_xiutu where title like "%$titles%" ORDER BY updatetime DESC

变量被转成字符串了

黄老邪 #4 · 2019-11-23 11:38:07

满意答案

{php $sql=urlencode('SELECT * FROM dr_1_xiutu where title like "%'.$titles.'%" ORDER BY updatetime DESC');}
{sql sql='$sql'}