当我使用包含空间的ajax变量时,我得到了MYSQL选择的问题。例如
$city = $_POST["from_ajax"];
$query = "SELECT * FROM `rest` WHERE city='".$city."'";
问题是当变量包含"空格"时,例如
ajax发送的变量是:"New York";
mysql查询失败
是什么导致了这个问题?
谢谢
use mysql TRIM()
$city = $_POST["from_ajax"];
$query = "SELECT * FROM `rest` WHERE TRIM(city)=TRIM('$city')";
使用
$city = $_POST["from_ajax"];
$query = "SELECT * FROM `rest` WHERE city LIKE '%$city%';