Ajax变量mysql搜索不与空间工作

ajax variable mysql search does not work with space

本文关键字：空间工作搜索变量 mysql Ajax | 更新日期: 2023-09-27

当我使用包含空间的ajax变量时，我得到了MYSQL选择的问题。例如

$city = $_POST["from_ajax"];
$query = "SELECT * FROM `rest` WHERE city='".$city."'";

问题是当变量包含"空格"时，例如

ajax发送的变量是:"New York";

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%';