PHP中PEAR DB的使用

花了好长时间,在虚拟机上测试总也通不过,执行到DB::connect时就不再向下执行,并且没有任何提示,后来在缺省目录htdoc中执行就通过了.

PEAR中将以MDB2代替DB,可我测试对于MySQL有点问题,可能还是我配置的问题.

PEAR安装后要修改php.ini中的路径,include_path包含PEAR安装路径.

<?php
// 引入合适的PEAR类
include_once("DB.php");

$dsn = array(
'phptype'  => 'mysql',
'hostspec' => '127.0.0.1',
'database' => 'tcrm',
'username' => 'root',
'password' => 'password'
);

//$dsn ="mysql://root:adsg@127.0.0.1/tcrm";

$conn =DB::connect($dsn);
If(Pear::isError($conn))
{
    die($conn->getMessage());
};

$sql = "SELECT * FROM dept";

$result = $conn->query($sql);

while ($row=$result->fetchRow(DB_FETCHMODE_ASSOC)) {
  $data = (object)$row;
  echo "部门编码=> $data->DeptCode";
  echo "部门名称=> $data->DeptName<br>";
}

?>