#45857 [NoF->Fbk]: Apache crashes with Prepared Statements

From: Date: Sat, 18 Oct 2008 20:12:19 +0000
Subject: #45857 [NoF->Fbk]: Apache crashes with Prepared Statements
References: 1  Groups: php.bugs 
Request: Send a blank email to php-bugs+get-129828@lists.php.net to get a copy of this message 
 ID:               45857
 Updated by:       felipe@php.net
 Reported By:      hawk_master at web dot de
-Status:           No Feedback
+Status:           Feedback
 Bug Type:         PDO related
 Operating System: Win XP Prof
 PHP Version:      5.2.6
 New Comment:

Please try using this CVS snapshot:

  http://snaps.php.net/php5.2-latest.tar.gz
 
For Windows:

  http://windows.php.net/snapshots/




Previous Comments:
------------------------------------------------------------------------

[2008-08-27 01:00:00] 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".

------------------------------------------------------------------------

[2008-08-19 18:12:49] johannes@php.net

Which database driver are you using and what kind of "crash" are you
getting?

------------------------------------------------------------------------

[2008-08-19 07:41:08] hawk_master at web dot de

Description:
------------
On my Win XP Prof System with Apache 2.2.9 and PHP 5.2.6 Apache will
crashes every time I run my PHP script which includes a Prepared
Statement and "bindParam"
If I replace the code without "bindParam" all is fine.

Reproduce code:
---------------
$dbUpdateUserLdap = $DBO->prepare("UPDATE table_user SET AddressField1
= :address1, AddressField2 = :address2', pwd = :pwd, AddressField3 =
:address3 WHERE usr = :user");
$dbUpdateUserLdap->bindParam(':user', $loginname);
$dbUpdateUserLdap->bindParam(':pwd', $_POST['PWD']);
$dbUpdateUserLdap->bindParam(':address1', $address1);
$dbUpdateUserLdap->bindParam(':address2', $address2);
$dbUpdateUserLdap->bindParam(':address3', $address3);
$dbUpdateUserLdap->execute();

This same code without "bindParam" will run:

$sql = "UPDATE table_user SET AddressField1='$address1' ,
AddressField2='$address2' , pwd='$_POST[PWD]',
AddressField3='$address3'
WHERE usr='$loginname'";
$result = $DBO->exec($sql);



------------------------------------------------------------------------


-- 
Edit this bug report at http://bugs.php.net/?id=45857&edit=1

Thread (3 messages)

« previous php.bugs (#129828) next »