PEAR类使用手记

1.
Q: 如何使用事务rollback
A: 如下例所示:
$sql = "insert into e_shortcut set admin_id = 1 , function_id = 1 , sequence = '0'";
""//或者$sql = "update e_shortcut set admin_id = 1 , function_id = 1 , sequence = '0' where shortcut_id='1'";""
$db->autoCommit(false);	""//如果这里使用非false/0类型值[连'-1'之类的都不可以],神仙也救不了你 :)""
$db->simpleQuery($sql);  ""//只有用simpleQuery()才可以支持哦""
$db->rollback();	""//还可以后悔""
Note: 如果是 MySQL 数据表类型必须为 InnoDB 才可以
		  ......2004-8-24 11:13上午
----

2.
Q: 如何连接数据库
A: 采用 DSN 方式连接,如下所示:
$dsn = 'mysql://root:@localhost/test';
$db = new DB;
$db = DB::connect($dsn);

if (DB::isError($db))
{
	die(@DB::errorMessage($db));
}
		  ......2004-8-24 11:15上午
----

3.
几种常见的使用方法:
1.) 取出全部记录
$sql = "select * from e_shortcut";
$res = $db->getAll($sql,$params = null,$fetchmode = DB_FETCHMODE_DEFAULT);
{
	....
}

2.) 只取出第一行
$sql = "select * from e_shortcut";
$res = $db->getRow($sql,$params = null,$fetchmode = DB_FETCHMODE_DEFAULT);
{
	....
}

3.) 提交一个insert/query/delete查询
$sql = "delete from e_shortcut where shortcut_id = '1'";
""//或者$sql = "update e_shortcut set admin_id = 1 , function_id = 1 , sequence = '0' where shortcut='1'";""
""//或者$sql = "insert e_shortcut set admin_id = 1 , function_id = 1 , sequence = '0'";""
$db->query($sql);
如果想要支持事务,可以采用上述方法

4.) 循环取得结果
$result = array();
$sql = "select * from e_shortcut1";
$res = $db->query($sql);

while($row = $res->fetchRow())
{
	....
}
		  ......2004-8-24 15:20上午