php mysql using wild cards with pear

jdc44

Greetings all
I'm having problems with a query that uses a wild card character with parameter binding in pear. I'm using php and mysql.

$sql = "Select * from myTable where last_name LIKE '%'.?.'%'";
$result = $myGlobalConnect->query($sql, array($name));

I've tried different variations on the use of the '%' wild card, but I can't get it working. I also think I've done this before, but I can't remember.

Thanks to all for any assistance...

paulnaj

What are you actually trying to match?

Paul 🙂

jdc44

I have web form for searching. User enters a last name to search for. The form variable name is name. So, in my code that becomes $name.

If a user searches on smith, I want all names with the letters smith in them to be returned. I.e.,
smith,
smithy,
gold-smith, etc...

In my sql I want to "select * from contacts where last_name like '%smith%'" Of course, I'd use $name in place of "smith"

This should get me any name with ...smith... in it. Right?

jdc44

opps! sorry I missed this
I of course want to use the param binding in pear as opposed to using $name directly in my sql.

$sql = "select * from contacts where last_name like %?%"
$myParams = array($name);

$result = $myGlobalConnection->query($sql, $myParams);

$result = $myGlobalConnection->query($sql, array($name));

jdc44

Gottit...

The percent symbol ( % ) is added to the parameters array:

$sql = "select * from contacts where last_name like ?"
$myParams = array('%'.$name.'%');