- 论坛徽章:
- 0
|
代码
require_once '../configs/config.php';
require_once 'pear/MDB2.php';
function handle_pear_error ($error_obj) {
print '<pre><b>PEAR-Error</b><br />';
echo $error_obj->getMessage().': '.$error_obj->getUserinfo();
print '</pre>';
}
PEAR::setErrorHandling(PEAR_ERROR_CALLBACK, 'handle_pear_error');
$dsn['username'] = $user;
$dsn['password'] = $pass;
$dsn['hostspec'] = $host;
$dsn['phptype'] = $mdb2_type;
$mdb2 =& MDB2::factory($dsn);
if (PEAR::isError($mdb2)) {
die (__LINE__.$mdb2->getMessage());
}
$username = 'admin';
$mdb2->setDatabase($mdb2_name);
$query = 'SELECT * FROM su_Members WHERE m_Name='.$mdb2->quote('admin', 'text');
$result = $mdb2->query($query);
if (PEAR::isError($result)) {
echo ($result->getMessage());
exit();
}
$array = $result->fetchRow();
$result->free();
$mdb2->disconnect();
Var_Dump($array);
[ 本帖最后由 jy_nim 于 2006-4-25 15:32 编辑 ] |
|