#30643 [Opn->Fbk]: about php pdo

ID: 30643 Updated by: derick@php.net Reported By: sayeeram82 at yahoo dot com -Status: Open +Status: Feedback Bug Type: Unknown/Other Function Operating System: windows xp PHP Version: 5.0.2 New Comment: Please try using this CVS snapshot: http://snaps.php.net/php5-latest.tar.gz For Windows: http://snaps.php.net/win32/php5-win32-latest.zip Previous Comments: ------------------------------------------------------------------------ [2004-11-01 05:26:57] sayeeram82 at yahoo dot com Description: ------------ hello, iam developing certain programs with php(version 5.0.2) which actually need interface with my database(oracle 8.1.5) which i does with PDO.Iam using wamp5 php5 apache1.3.31 version 1.3 as my webserver.Here i need to insert and get some value from database through program. My current problem is to insert atleast 2 or more rows at a time with bingvariables but iam getting some bug so please give some idea for it or solve my error please. Reproduce code: --------------- $stmt = $dbh->prepare("insert into test (name, value) values (:name, :value)"); $stmt->bindParam(':name', $name, PDO_PARAM_STR, 64); $stmt->bindParam(':value', $value, PDO_PARAM_STR, 64); $name = 'Foo'; $value = 'Bar'; $stmt->execute() or die("no insert"); // and another $name = 'Fu'; $value = 'Ba'; $stmt->execute() or die("no insert"); $stmt = null; Expected result: ---------------- i Expect both the foo and fu values to be inserted into my database table test. Actual result: -------------- but actually it is not inserting anything and i get a microsoft dialogue report sending error message relating a problem with apache. ------------------------------------------------------------------------ -- Edit this bug report at http://bugs.php.net/?id=30643&edit=1