Ec (2); & nbsp; ACCESS database is used in projects, so an ACCESS processing class is written. the function name is the same as that of the ADODB class. & nbsp; & lt ;? Php ** ACCESS database operation class ** * LIQUAN * $ dsn & nbsp; & quot; DRIVER {Microsoft & nbsp; Access & nbsp; driver & script ec (2); script
The ACCESS database is used in the project, so an ACCESS processing class is written. The function name is the same as that of the ADODB class.
/*
* ACCESS Database Operations
* 2008-3-26
* LIQUAN
* $ Dsn = "DRIVER = {Microsoft Access Driver (*. mdb)}; DBQ =". PATH_ROOT. "databasedata. mdb ";
* $ Conn = new Access ();
* $ Conn-> Connnect ($ dsn );
* $ Conn-> GetArray ("select * from test ");
*/
Class Access
{
Var $ conn;
Var $ fieldsName;
Function Access ()
{
}
// Connection
Function Connect ($ dsn)
{
$ This-> conn = new COM ("ADODB. Connection") or die ("Cannot start ADO ");
$ This-> conn-> Open ($ dsn );
}
// Returns
Function GetOne ($ SQL)
{
$ Rs = $ this-> conn-> Execute ($ SQL );
While (! $ Rs-> EOF)
{
$ Value = $ rs-> Fields (0)-> value;
$ Rs-> MoveNext ();
}
$ Rs-> Close ();
$ Rs = null;
If (! Empty ($ value ))
{
Return $ value;
}
Else
{
Return "";
}
Unset ($ value );
}
// Returns a large array.
Function GetArray ($ SQL)
{
$ Rs = $ this-> conn-> Execute ($ SQL );
$ Num_columns = $ rs-> Fields-> Count ();
$ Rowcount = 0;
While (! $ Rs-> EOF)
{
For ($ I = 0; $ I <$ num_columns; $ I ++)
{
$ FieldName [$ rowcount] [$ rs-> Fields ($ I)-> name] = $ rs-> Fields ($ I)-> value;
}
$ Rowcount ++;
$ Rs-> MoveNext ();
}
$ Rs-> Close ();
$ Rs = null;
If (! Empty ($ fieldName ))
{
Return $ fieldName;
}
Else
{
Return "";
}
Unset ($ fieldName );
}
// Returns a small array.
Function GetRow ($ SQL)
{
$ Rs = $ this-> conn-> Execute ($ SQL );
$ Num_columns = $ rs-> Fields-> Count ();
While (! $ Rs-> EOF)
{
For ($ I = 0; $ I <$ num_columns; $ I ++)
{
$ FieldName [$ rs-> Fields ($ I)-> name] = $ rs-> Fields ($ I)-> value;
}
$ Rs-> MoveNext ();
}
$ Rs-> Close ();
$ Rs = null;
If (! Empty ($ fieldName ))
{
Return $ fieldName;
}
Else
{
Return "";
}
Unset ($ fieldName );
}
// Execute SQL
Function Execute ($ SQL)
{
If ($ this-> conn-> Execute ($ SQL ))
{
Return true;
}
Else
{
Return false;
}
}
Function Close ()
{
$ This-> conn-> Close ();
}
Function _ destruct ()
{
// $ This-> conn-> Close ();
}
}
?>
</