note 61505 added to function.pdostatement-bindparam

A caution for those using bindParam() on a placeholder in a LIKE '%...%' clause, the following code will likely not work: $q = "SELECT id, name FROM test WHERE name like '%:foo%'"; $s = "carrot"; $sth = $dbh->prepare($q); $sth->bindParam(':foo', $s); $sth->execute(); What is needed is something like the following: $s = "%$s%"; $sth->bindParam(':foo', $s); This should work. Tested against mysql 4.1, PHP 5.1.3. ---- Server IP: 216.194.113.175 Probable Submitter: 64.81.194.132 ---- Manual Page -- http://www.php.net/manual/en/function.pdostatement-bindparam.php Edit -- http://master.php.net/manage/user-notes.php?action=edit+61505 Delete: added to the manual -- http://master.php.net/manage/user-notes.php?action=delete+61505&report=yes&reason=added+to+the+manual Delete: bad code -- http://master.php.net/manage/user-notes.php?action=delete+61505&report=yes&reason=bad+code Delete: spam -- http://master.php.net/manage/user-notes.php?action=delete+61505&report=yes&reason=spam Delete: useless -- http://master.php.net/manage/user-notes.php?action=delete+61505&report=yes&reason=useless Delete: non-english -- http://master.php.net/manage/user-notes.php?action=delete+61505&report=yes&reason=non-english Delete: already in docs -- http://master.php.net/manage/user-notes.php?action=delete+61505&report=yes&reason=already+in+docs Delete: other reasons -- http://master.php.net/manage/user-notes.php?action=delete+61505&report=yes Reject -- http://master.php.net/manage/user-notes.php?action=reject+61505&report=yes Search -- http://master.php.net/manage/user-notes.php