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] [EMAIL PROTECTED]
If this is mysql then please update php and show all errors and
warnings.
------------------------------------------------------------------------
[2005-07-16 14:03:13] [EMAIL PROTECTED]
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
