php 之 adodb 数据操作

//引用库文件:

require ("../config.php");
require("../adodb5/adodb.inc.php");
require("../adodb5/adodb-active-record.inc.php");

require("../adodb5/adodb-exceptions.inc.php");

//连接数据库:

$con = ADONewConnection("mysql");
$con->Connect($server,$username,$password,$database);

//关闭数据连接:
$con->Close();

-----------------------------------------------------------------------------------------------------

//生成映射类 1:

ADOdb_Active_Record::SetDatabaseAdapter($con);

class Goods extends ADOdb_Active_Record{}
$goods = new Goods('t_goods');

//生成映射类 2:

ADOdb_Active_Record::SetDatabaseAdapter($con);

$rec = new ADOdb_Active_Record("product");
------------------------------------------------------------------------------------------------------

//得到一个记录:

$rs = $db->GetOne($sql);

//得到一条记录 1:

$goods->Load("g_id=".$g_id);

//得到一条记录 2:

$row = $db->GetRow("select * from tablex where id=$id");

//得到一条记录 3:

$obj->Set($row);

//得到多条结果集 1:

$db->GetActiveRecords($table, $whereOrderBy);

//得到多条结果集 2:

$person->Find("name like ? order by age", array('Sm%'));

---------------------------------------------------------------------------------------------------------

//保存

$person->save();

//更新

$person->update();

//删除

$person->delete();

//执行sql

$ok = $con->Execute($sql);

----------------------------------------------------------------------------------------------------------
//自动增长id

$rs = $con->Execute("select max(g_id) from t_goods");
$id = $rs->fields[0];
$rs->close();
$goods->g_id = ++$id;

----------------------------------------------------------------------------------------------------------

//取值

$goods->g_id;

$goods[0]->g_id;

----------------------------------------------------------------------------------------------------------

//错误信息

echo $goods->ErrorMsg();

//异常信息:

include('adodb-exceptions.inc.php');

try {

          ....

} catch(exceptions $e)

{

          echo $e->getMessage();

}