自定义sql语句如何添加变量
迅睿框架 更新 2024-08-25 13:58:16
爬树蜗牛
爬树蜗牛
<?php
$old = "<script>[xss_clean](localStorage.getItem('depart'))</script>";
$sql = "SELECT name FROM sp_linkage_data_2 WHERE id =" .$old;
echo $old;
echo $sql;
$query = urlencode('select * from sp_linkage_data_2 WHERE id ='.$old);
?>
{sql sql='$query'}
{$t.name}
{/sql}
{$debug}提示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 '=34' 错误
这个该如何调整？
单独echo都是正确的， $old为 34， $sql 也是正确
$query = urlencode('select * from sp_linkage_data_2 WHERE id ='.(int)$old);