PHP中PEAR DB的使用

2023-11-07 22:38•php•阅读 4304

花了好长时间,在虚拟机上测试总也通不过,执行到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>";

}