#41876 [NoF->Csd]: bindParam() and bindValue() do not work with MySQL MATCH () AGAINST ()

From: Date: Wed, 23 Jul 2008 10:27:47 +0000
Subject: #41876 [NoF->Csd]: bindParam() and bindValue() do not work with MySQL MATCH () AGAINST ()
References: 1  Groups: php.bugs 
Request: Send a blank email to php-bugs+get-127176@lists.php.net to get a copy of this message 
 ID:               41876
 Updated by:       tony2001@php.net
 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] iliaa@php.net

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

Thread (4 messages)

« previous php.bugs (#127176) next »