ID: 41876 Updated by: [EMAIL PROTECTED] Reported By: jay at mysql dot com -Status: No Feedback +Status: Closed Bug Type: PDO related Operating System: Linux 2.6.20 PHP Version: 5.2.3 Assigned To: iliaa New Comment:
Appears to be fixed by Johannes. Previous Comments: ------------------------------------------------------------------------ [2007-07-11 01:00:01] php-bugs at lists dot php dot net No feedback was provided for this bug for over a week, so it is being suspended automatically. If you are able to provide the information that was originally requested, please do so and change the status of the bug back to "Open". ------------------------------------------------------------------------ [2007-07-03 23:47:29] [EMAIL PROTECTED] Please try using this CVS snapshot: http://snaps.php.net/php5.2-latest.tar.gz For Windows (zip): http://snaps.php.net/win32/php5.2-win32-latest.zip For Windows (installer): http://snaps.php.net/win32/php5.2-win32-installer-latest.msi Seems to work fine in latest CVS ------------------------------------------------------------------------ [2007-07-02 20:02:37] jay at mysql dot com Description: ------------ When using the MATCHES(cols...) AGAINST (phrase) construct in MySQL using PDO prepared statements and bound parameters, the binding does not recognize the "?" within the AGAINST (). Reproduce code: --------------- $pdo= new PDO("mysql:host=localhost;dbname=some_db","some_user","some_pass"); $sql= "SELECT * FROM some_table WHERE MATCH(some_col) AGAINST (?)"; $statement= $pdo->prepare($sql); $statement->bindValue(1, "some search phrase"); $statement->execute(); // Will error here with "invalid parameter number, no parameters bound" If you replace the ? in the SQL statement with the string search phrase value, it will work fine. Expected result: ---------------- Expect to bind the value into the unnamed parameter and execute properly. Actual result: -------------- Warning: PDOStatement::execute() [function.PDOStatement-execute]: SQLSTATE[HY093]: Invalid parameter number: no parameters were bound in XXX ------------------------------------------------------------------------ -- Edit this bug report at http://bugs.php.net/?id=41876&edit=1
