PDO statement not retrieving any data

Question

I'm using something like this to get values from my database, but it's not returning anything. No errors, but also no data when I know there should be. I'm sure I have some syntax error, but can't figure out where:

$search_crit = $_POST['search_items'];
$sql1 = "SELECT `Provider Name`, `State Abbrv`, `zip_code` FROM `myTable` 
where `Provider Name` like '%:criteria%' group by `Provider Name`";
$stmt = $dbh->prepare($sql1);
$stmt->bindParam(':criteria', $search_crit, PDO::PARAM_STR, 100);
$stmt->execute();
$result1 = $stmt->fetchAll();

In this case, $search_crit is a string entered by the user on the front end. I've ran this query by "hardcoding" a value in for :criteria, so I know it works in principle, but can't figure out what my issue is when I try to pass the value with PDO.

that will depend on what the POST array returns and whether if it's set/not empty. check for errors all around — Funk Forty Niner, May 26 '15 at 17:51
It's not an array...just a single value like "Smith" and it definitely is set, as I can do a `var_dump` and see it. — jonmrich, May 26 '15 at 17:52
like query with pdo needs little customization as compared to simple matches. See the question i linked to yours — Hanky Panky, May 26 '15 at 17:56
See @Hanky웃Panky's link and http://stackoverflow.com/q/11068230/ that Q&A. — Funk Forty Niner, May 26 '15 at 17:56
Switched to this per the question, but still getting nothing back: `$stmt->execute(':criteria', '%'.$search_crit.'%', PDO::PARAM_STR, 100);` — jonmrich, May 26 '15 at 18:03
You could just do `$sql1 = "SELECT \`Provider Name\`, \`State Abbrv\`, \`zip_code\` FROM \`myTable\` where \`Provider Name\` like ? group by \`Provider Name\`";` and `$stmt->execute(array('%'.$search_crit.'%'));`. See example #6, http://php.net/manual/en/pdo.prepared-statements.php. — chris85, May 26 '15 at 18:08
Jonmirch execute takes an array not a string. chris85 uses that correctly in the comment above — Hanky Panky, May 27 '15 at 00:01

PDO statement not retrieving any data

0 Answers0