$sql = "select * from table where name like '%?%'";
$db->query($sql, $name);
报错,加转义字符也不好使。
解决方法:
$sql = "select * from table where name like ?";
$name = "%".$name."%";
$db->query($sql, $name);
$sql = "select * from table where name like '%?%'";
$db->query($sql, $name);
报错,加转义字符也不好使。
解决方法:
$sql = "select * from table where name like ?";
$name = "%".$name."%";
$db->query($sql, $name);