concat条件不能在php pdo中运行但在mySQL中运行

Question

Running the following query works perfectly in my user search, within mySQL on phpmyadmin.

SELECT user_id, fname, lname, email FROM users WHERE fname LIKE '%Scott James%' OR lname LIKE '%Scott James%' OR CONCAT(fname,' ',lname) LIKE '%Scott James%'

However, if I try and run this through php on production environment, it seems to fall over. Anyone got any ideas?

$word = $_REQUEST['search'];

$search_query='SELECT user_id, fname, lname, email FROM users WHERE fname LIKE :search OR lname LIKE :search OR CONCAT(fname,' ',lname) LIKE :search';

$stmt= $conn->prepare($search_query);
$stmt->execute(array(
  ':search'   => '%'.$word.'%',
  ':user_id'   => $user_id 
    ));

Answer 1

1. make sure PDO is in emulation mode to allow multiple parameters with same name
2. Get rid of this ':user_id' => $user_id stuff.
3. Make sure PDO is in exception mode and you can see PHP errors