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

ID: 33724 User updated by: eser at turkishqf dot org Reported By: eser at turkishqf dot org -Status: Feedback +Status: Open Bug Type: *Database Functions Operating System: freebsd 4.3 PHP Version: 5.1.0b2 New Comment: 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']); } Previous Comments: ------------------------------------------------------------------------ [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. ------------------------------------------------------------------------ [2005-07-16 14:00:54] eser at turkishqf dot org Description: ------------ "PDO" object doesn't run in functions. Reproduce code: --------------- $qDB = new PDO ... function addToStorage($uId) { // doesn't work global $qDB; $tQuery = $qDB->prepare('SELECT * FROM articles WHERE idx=:idx'); print_r($tQuery); } // works $tQuery = $qDB->prepare('SELECT * FROM articles WHERE idx=:idx'); print_r($tQuery); ------------------------------------------------------------------------ -- Edit this bug report at http://bugs.php.net/?id=33724&edit=1