pgsql.php problems: possible weirdness
[email protected] (Burak DAYIOGLU) Fri, 02 Mar 2001 15:27:22 +0200
| Newsgroups | php.pear |
|---|---|
| Message-ID | <[email protected]> |
hello all,
I am having a page in which I initialize a pgsql connection with
something like the below:
$dsn=array(phptype => DNS_DATABASE, hostspec=> "localhost", database=>
"dns");
$database=DB::connect($dsn);
after setting up a connection, I (surely) can query database and make
various operations on it. However, when it comes to passing a connection
handle to a class there comes the problems:
I am having a contact class with such a constructor:
class contact {
function contact(&$dbHandle) {}
}
In the php code of the PAGE, i write such a line to instantiate a new
contact:
$x=new contact($database);
However when I try to use one of the db aware methods of contact class
(just as the one below) I get warnings:
function dummy() {
$this->dbHandle->autoCommit(FALSE);
$queryStr="select * from contact order by contactid
desc";
$handle=$this->dbHandle->query($queryStr);
if (DB::isError($handle)) {
echo "there is an error";
}
$count=$this->dbHandle->numrows($handle);
$myrow=$this->dbHandle->fetchrow($handle);
}
Warning: Illegal offset type in DB/pgsql.php on line 256
Warning: Illegal offset type in DB/pgsql.php on line 256
(using latest pgsql.php from CVS)
when vardumped, $this->dbHandle and $handle look as instances of
appropriate
classes; but var_dump($count) shows
object(db_error)(10) { ["error_message_prefix"]=> string(0) ""
["error_prepend"]=> string(0) "" ["error_append"]=> string(0) ""
["mode"]=> int(1) ["level"]=> int(1024) ["code"]=> int(-1) ["message"]=>
string(23) "DB Error: unknown error" ["debuginfo"]=> string(0) ""
["userinfo"]=> string(74) "select * from contact order by contactid
desc" ["callback"]=> NULL }
anybody with any ideas? I've had been using PEAR for some time but this
error seemed weird to me...
with regards,
-bd