Strange error
| From: | urosh@agenda.si | Date: | Mon, 17 Feb 2003 10:26:34 +0000 |
| Subject: | Strange error | ||
| Groups: | php.pear.general | ||
| Request: | Send a blank email to pear-general+get-3797@lists.php.net to get a copy of this message | ||
HI!
I've installed MDB today and tried to connect to database and retrieve
some data with following script:
<?php
require_once("MDB.php");
$mdb = &MDB::connect(array(
"phptype" => "mysql",
"username" => "user",
"password" => "pass")
);
if (MDB::isError($mdb)) {
die ($mdb->getMessage());;
}
$mdb->setDatabase("mysql");
$query = "SELECT User, Password FROM user";
$result = $mdb->query($query);
if(!MDB::isError($result)) {
while ($data = $mdb->fetchRow($result)) {
echo $data[0]." => ".$data[1]."<br>";
}
} else {
echo $result->getMessage();
}
?>
and nothing happend. No error message, no data, nothing.
After some debugging (I removed @ from line
@$db =& new $class_name($dsninfo, $options);
in MDB.php)
I got following error:
Fatal error: Call to undefined function: loadextension() in
/usr/share/pear/MDB/mysql.php on line 94
pear list returns:
Installed packages:
===================
+----------------+---------+--------+
| Package | Version | State |
| Archive_Tar | 1.0 | stable |
| Console_Getopt | 1.0 | stable |
| DB | 1.4b1 | beta |
| MDB | 1.1.1 | stable |
| Mail | 1.0.2 | stable |
| Net_SMTP | 1.1.1 | stable |
| Net_Socket | 1.0.1 | stable |
| PEAR | 1.0.1 | stable |
| XML_Parser | 1.0 | stable |
| XML_RPC | 1.0.4 | stable |
+----------------+---------+--------+
and phpInfo() shows that "/usr/share/pear" is in include path.
What is wrong?
Regards
Urosh