我正在尝试做这样的事情:
$url = 'test/';
$url = rtrim($url, "'");
$url = $db->quote($url);
$sql = "SELECT * FROM mytable WHERE url = '{$url}' OR url = '{$url}/'";
但是这个返回: 从我的表中选择 * 其中
url = ''test/'' 或 url = ''test/'/'我基本上想要相当于Zend的mysql_real_escape_string。
尝试使用类似like
$sql = "SELECT * FROM mytable WHERE url LIKE '%{$url}/%'";
甚至你可以尝试像
$url = 'test/';
$sql = "SELECT * FROM mytable WHERE url LIKE '%{$url}%'";