#33724 [Opn->Fbk]: "PDO" object doesn't run in functions.
| From: | helly@php.net | Date: | Sat, 16 Jul 2005 12:35:19 +0000 |
| Subject: | #33724 [Opn->Fbk]: "PDO" object doesn't run in functions. | ||
| References: | 1 | Groups: | php.bugs |
| Request: | Send a blank email to php-bugs+get-81929@lists.php.net to get a copy of this message | ||
ID: 33724
Updated by: helly@php.net
Reported By: eser at turkishqf dot org
-Status: Open
+Status: Feedback
Bug Type: *Database Functions
Operating System: freebsd 4.3
PHP Version: 5.1.0b2
New Comment:
to repeat the Q: ARE YOU USING MYSQL?
Previous Comments:
------------------------------------------------------------------------
[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.
------------------------------------------------------------------------
[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