php编写的ACCESS处理类_[PHP教程]
在做项目中要用到ACCESS数据库,所以就写了一个ACCESS处理类.函数名跟ADODB类一样.
![](/Image/20085231236114077801.gif)
![](/Image/20085231236114077801.gif)
/*
![](/Image/20085231236114077801.gif)
*ACCESS数据库操作类
![](/Image/20085231236114077801.gif)
*2008-3-26
![](/Image/20085231236114077801.gif)
*LIQUAN
![](/Image/20085231236114077801.gif)
*dsn = "DRIVER={Microsoft Access Driver (*.mdb)}; DBQ=".PATH_ROOT."databasedata.mdb";
![](/Image/20085231236114077801.gif)
*conn=new Access();
![](/Image/20085231236114077801.gif)
*conn->Connnect(dsn);
![](/Image/20085231236114077801.gif)
*conn->GetArray("select * from test");
![](/Image/20085231236114077801.gif)
*/
![](/Image/20085231236114077801.gif)
![](/Image/20085231236114077801.gif)
class Access
![](/Image/20085231236114077801.gif)
{
![](/Image/20085231236114077801.gif)
var conn;
![](/Image/20085231236114077801.gif)
var fieldsName;
![](/Image/20085231236114077801.gif)
function Access()
![](/Image/20085231236114077801.gif)
{
![](/Image/20085231236114077801.gif)
}
![](/Image/20085231236114077801.gif)
![](/Image/20085231236114077801.gif)
//connection
![](/Image/20085231236114077801.gif)
function Connect(dsn)
![](/Image/20085231236114077801.gif)
{
![](/Image/20085231236114077801.gif)
this->conn = new COM("ADODB.Connection") or die("Cannot start ADO");
![](/Image/20085231236114077801.gif)
this->conn->Open(dsn);
![](/Image/20085231236114077801.gif)
}
![](/Image/20085231236114077801.gif)
![](/Image/20085231236114077801.gif)
//返回一个
![](/Image/20085231236114077801.gif)
function GetOne(sql)
![](/Image/20085231236114077801.gif)
{
![](/Image/20085231236114077801.gif)
rs = this->conn->Execute(sql);
![](/Image/20085231236114077801.gif)
while (!rs->EOF)
![](/Image/20085231236114077801.gif)
{
![](/Image/20085231236114077801.gif)
value=rs->Fields(0)->value;
![](/Image/20085231236114077801.gif)
rs->MoveNext();
![](/Image/20085231236114077801.gif)
}
![](/Image/20085231236114077801.gif)
rs->Close();
![](/Image/20085231236114077801.gif)
rs=null;
![](/Image/20085231236114077801.gif)
![](/Image/20085231236114077801.gif)
if(!empty(value))
![](/Image/20085231236114077801.gif)
{
![](/Image/20085231236114077801.gif)
return value;
![](/Image/20085231236114077801.gif)
}
![](/Image/20085231236114077801.gif)
else
![](/Image/20085231236114077801.gif)
{
![](/Image/20085231236114077801.gif)
return "";
![](/Image/20085231236114077801.gif)
}
![](/Image/20085231236114077801.gif)
unset(value);
![](/Image/20085231236114077801.gif)
}
![](/Image/20085231236114077801.gif)
![](/Image/20085231236114077801.gif)
![](/Image/20085231236114077801.gif)
//返回大数组
![](/Image/20085231236114077801.gif)
function GetArray(sql)
![](/Image/20085231236114077801.gif)
{
![](/Image/20085231236114077801.gif)
rs = this->conn->Execute(sql);
![](/Image/20085231236114077801.gif)
num_columns = rs->Fields->Count();
![](/Image/20085231236114077801.gif)
rowcount = 0;
![](/Image/20085231236114077801.gif)
while (!rs->EOF)
![](/Image/20085231236114077801.gif)
{
![](/Image/20085231236114077801.gif)
for (i=0; i < num_columns; i++)
![](/Image/20085231236114077801.gif)
{
![](/Image/20085231236114077801.gif)
fieldName[rowcount][rs->Fields(i)->name]= rs->Fields(i)->value;
![](/Image/20085231236114077801.gif)
}
![](/Image/20085231236114077801.gif)
rowcount++;
![](/Image/20085231236114077801.gif)
rs->MoveNext();
![](/Image/20085231236114077801.gif)
}
![](/Image/20085231236114077801.gif)
rs->Close();
![](/Image/20085231236114077801.gif)
![](/Image/20085231236114077801.gif)
rs=null;
![](/Image/20085231236114077801.gif)
if(!empty(fieldName))
![](/Image/20085231236114077801.gif)
{
![](/Image/20085231236114077801.gif)
return fieldName;
![](/Image/20085231236114077801.gif)
}
![](/Image/20085231236114077801.gif)
else
![](/Image/20085231236114077801.gif)
{
![](/Image/20085231236114077801.gif)
return "";
![](/Image/20085231236114077801.gif)
}
![](/Image/20085231236114077801.gif)
unset(fieldName);
![](/Image/20085231236114077801.gif)
}
![](/Image/20085231236114077801.gif)
![](/Image/20085231236114077801.gif)
//返回小数组
![](/Image/20085231236114077801.gif)
function GetRow(sql)
![](/Image/20085231236114077801.gif)
{
![](/Image/20085231236114077801.gif)
rs = this->conn->Execute(sql);
![](/Image/20085231236114077801.gif)
num_columns = rs->Fields->Count();
![](/Image/20085231236114077801.gif)
while (!rs->EOF)
![](/Image/20085231236114077801.gif)
{
![](/Image/20085231236114077801.gif)
for (i=0; i < num_columns; i++)
![](/Image/20085231236114077801.gif)
{
![](/Image/20085231236114077801.gif)
fieldName[rs->Fields(i)->name]=rs->Fields(i)->value;
![](/Image/20085231236114077801.gif)
}
![](/Image/20085231236114077801.gif)
![](/Image/20085231236114077801.gif)
rs->MoveNext();
![](/Image/20085231236114077801.gif)
}
![](/Image/20085231236114077801.gif)
rs->Close();
![](/Image/20085231236114077801.gif)
![](/Image/20085231236114077801.gif)
rs=null;
![](/Image/20085231236114077801.gif)
if(!empty(fieldName))
![](/Image/20085231236114077801.gif)
{
![](/Image/20085231236114077801.gif)
return fieldName;
![](/Image/20085231236114077801.gif)
}
![](/Image/20085231236114077801.gif)
else
![](/Image/20085231236114077801.gif)
{
![](/Image/20085231236114077801.gif)
return "";
![](/Image/20085231236114077801.gif)
}
![](/Image/20085231236114077801.gif)
unset(fieldName);
![](/Image/20085231236114077801.gif)
![](/Image/20085231236114077801.gif)
}
![](/Image/20085231236114077801.gif)
![](/Image/20085231236114077801.gif)
//execute SQL
![](/Image/20085231236114077801.gif)
function Execute(sql)
![](/Image/20085231236114077801.gif)
{
![](/Image/20085231236114077801.gif)
if(this->conn->Execute(sql))
![](/Image/20085231236114077801.gif)
{
![](/Image/20085231236114077801.gif)
return true;
![](/Image/20085231236114077801.gif)
}
![](/Image/20085231236114077801.gif)
else
![](/Image/20085231236114077801.gif)
{
![](/Image/20085231236114077801.gif)
return false;
![](/Image/20085231236114077801.gif)
}
![](/Image/20085231236114077801.gif)
}
![](/Image/20085231236114077801.gif)
![](/Image/20085231236114077801.gif)
function Close()
![](/Image/20085231236114077801.gif)
{
![](/Image/20085231236114077801.gif)
this->conn->Close();
![](/Image/20085231236114077801.gif)
}
![](/Image/20085231236114077801.gif)
![](/Image/20085231236114077801.gif)
function __destruct()
![](/Image/20085231236114077801.gif)
{
![](/Image/20085231236114077801.gif)
// this->conn->Close();
![](/Image/20085231236114077801.gif)
}
![](/Image/20085231236114077801.gif)
![](/Image/20085231236114077801.gif)
![](/Image/20085231236114077801.gif)
![](/Image/20085231236114077801.gif)
}
![](/Image/20085231236114077801.gif)
![](/Image/20085231236114077801.gif)
?>
来源:
http://blog.csdn.net/liq330