//引用库文件:
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();
}