Hello folks,
I'm trying to pass an array of parameters to a statement I've prepared
with '?' placeholders. For example (all columns are varchar 50):
$sql = 'INSERT INTO SOME_TABLE (COL1, COL2, COL3) VALUES (?, ?, ?)'
$params = array('val1', 'val2', 'val3');
I've achieved the results I want with other interfaces using the following
code:
Unified ODBC:
$stmt = odbc_prepare($this->db, $sql);
$result = odbc_execute($stmt, $params);
The ibm_db2 extension:
$stmt = db2_prepare($this->db, $sql);
$result = db2_execute($stmt, $params);
But I can't get either of the following to do the same with PDO:
This fills all columns with 'val3':
$stmt = $this->db->prepare($sql);
$result = $stmt->execute($params);
This fails with a segfault at bindValue (I can't be sure of the number of
placeholders in $sql or how many values to manually bind from $params, so
I do it in a loop (I've also tried a foreach)):
$stmt = $this->db->prepare($sql);
$size = count($params);
for ($i = 0; $i < $size; $i++) {
echo $params[$i];
$stmt->bindValue($i + 1, $params[$i]);
}
$result = $stmt->execute();
This is PHP 5.1.2 on SLES 9. I don't see anything related in
http://bugs.php.net/
Configure was
./configure --with-IBM_DB2 --with-pdo-odbc=ibm-db2,/home/db2inst1/sqllib
--with-ibm-db2 --with-apxs2=/opt/IBMIHS/bin/apxs --enable-maintainer-zts
Any thoughts?
Thanks,
-Dan
Daniel Krook, Content Tools Developer
Global Production Services - Tools, ibm.com
http://bluepages.redirect.webahead.ibm.com/
http://blogpages.redirect.webahead.ibm.com/
http://bookmarks.redirect.webahead.ibm.com/
--
PHP Database Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php
