#33724 [Opn->Bgs]: "PDO" object doesn't run in functions.

ID: 33724 Updated by: helly@php.net Reported By: eser at turkishqf dot org -Status: Open +Status: Bogus Bug Type: *Database Functions Operating System: freebsd 4.7 PHP Version: 5.1.0b2 New Comment: Thank you for taking the time to write to us, but this is not a bug. Please double-check the documentation available at http://www.php.net/manual/ and the instructions on how to report a bug at http://bugs.php.net/how-to-report.php ATM parallel queries are not available using mysql. Wait for someone to write a decent pdo_mysql driver, use a decent rdbms like postgres or use fetchall(). Previous Comments: ------------------------------------------------------------------------ [2005-07-16 14:37:19] eser at turkishqf dot org yes, mysql-max-4.1.12 on freebsd 4.7 ------------------------------------------------------------------------ [2005-07-16 14:35:18] helly@php.net to repeat the Q: ARE YOU USING MYSQL? ------------------------------------------------------------------------ [2005-07-16 14:26:23] eser at turkishqf dot org pardon me, there is no problem while PDO methods running in functions. but i can't execute recursive queries with same PDO object; php triggers "Invalid argument supplied for foreach" error. example: foreach ($qDB->query('SELECT NOW() AS z') as $row) { foreach ($qDB->query('SELECT NOW() AS x') as $subrow) { // Invalid argument supplied for foreach() echo $subrow['x']; } } my code: foreach ($qDB->query('SELECT entities.alias, entities.fieldidx FROM entities WHERE entities.fieldtype=\'s\' AND (entities.parenttype=\'s\' AND entities.parentidx=\'0\')', PDO_FETCH_ASSOC) as $tRow) { // addToStorage('s' . $tRow['fieldidx']); $x = $qDB->prepare('SELECT * FROM articles'); exit($x); echo $system->strings->format('<td><a href="http://{0}.turkishqf.org/"{1}>{2}</a></td>', $tRow['alias'], (($pRequestDomain == $tRow['alias']) ? ' class="act"' : ''), $pStorage['s' . $tRow['fieldidx']]['name']); } ------------------------------------------------------------------------ [2005-07-16 14:21:00] helly@php.net If this is mysql then please update php and show all errors and warnings. ------------------------------------------------------------------------ [2005-07-16 14:03:13] derick@php.net Not enough information was provided for us to be able to handle this bug. Please re-read the instructions at http://bugs.php.net/how-to-report.php If you can provide more information, feel free to add it to this bug and change the status back to "Open". Thank you for your interest in PHP. ------------------------------------------------------------------------ The remainder of the comments for this report are too long. To view the rest of the comments, please view the bug report online at http://bugs.php.net/33724 -- Edit this bug report at http://bugs.php.net/?id=33724&edit=1