PDO binding for a MYSQL LIKE

[niche]

This code works, but can someone tell me how I can use an array instead of bindParam in this situation. 

try {	
			$sql = '
				SELECT 
					*
				FROM 
					nconnectz
				WHERE
					itemandsize LIKE :itemandsize
				AND 
					price > 0	
				ORDER BY
					price ASC				
			';
			$stmt2 = $db2->prepare($sql);
		} catch (PDOException $e) {
			echo $e->getMessage() . '<br>';
		}	
				
		$var = "%Flour%";
		
		try {	
			$stmt2->bindParam(':itemandsize',$var);
			$stmt2->execute();
		} catch (PDOException $e) {
			echo $e->getMessage() . '<br>';
		}	

Something like?

$stmt2->execute(array(
:itemandsize => '%Flour%' ));

 

Edited October 6, 2018 by niche

[niche]

Interesting.

When I strip-out all the white space it works:

$stmt2->execute(array(':itemandsize' => '%' . $var . '%'));

I've heard of white space being a problem, but haven't knowingly experienced it.

Any thoughts?  Urban legend?

[Ingolme]

There's no problem with whitespace in the code itself. What I do find is that in your first post, you forgot to quote :itemandsize string.

[niche]

Voila!  Thanks for your help.