str_replace只包含整个单词

Question

I am trying to take a string, remove a list of words and any numbers, and then use the result in a MySQL query.

It will echo out the word I am trying to isolate, but when I place that word equal to the string, it returns false and won't query.

$remove_odonyms=preg_replace("/\b(st|street|rd|road|ln|lane|ter|terrace|ave|avenue|blvd|boulevard|ct|court)\b/", "", $search);

function remove_numbers($string) {
$num = array(1,2,3,4,5,6,7,8,9,0);
return str_replace($num, '', $string);
}
$street_only=remove_numbers($remove_odonyms);

So for the string $search="60 main street" echo $remove_odonyms is "60 main" and echo $street_only is "main".

But they won’t query, and they won’t do

if($street_only="main"){ echo "true";}

Edit: The query I am doing is

$query="
SELECT * FROM column WHERE number='$int' AND odonym='$odonym' AND street_name='$street_only'
";

It returns nothing. But when I change it to street_name="main", it returns the result I am looking for.

Answer 1

You have one extra space so you need to trim to remove space. so before query use trim() to remove space and match exact word in query.

$street_only = trim($street_only);