[PHP程式] 常見的 ADOdb 涵式

這是從 ADOdb Lite 摘錄下來的，最精簡的部分，方便參考！

  Database Functions

$db->debug = false - Disable Debug Feature $db->debug = true - Enable Debug Feature

If the debug flag is set to true then every query with corresponding error result will be echoed. The debug feature does not support echoing of resultset functions.

$db->Affected_Rows() $db->Close() $db->Concat($string, $string) $db->ErrorMsg() $db->ErrorNo() $db->Execute($sql, [$inputarray]) $db->GetAll($sql) $db->GetArray($sql) $db->IfNull($field, $ifNull)$db->Insert_ID() $db->Insert_ID() $db->IsConnected() $db->qstr($string, [$magic_quotes]) $db->Qmagic($string) $db->SelectDB($dbname) $db->SelectLimit( $sql, [nrows], [offset], [$inputarray] ) - Currently MySql/MySqli/MySqlt/SqLite/PostGres7/MsSql/MsSqlpo/Sybase supported $db->Version()

  Result Set Functions 

$ADODB_FETCH_MODE = 'ADODB_FETCH_DEFAULT' | 'ADODB_FETCH_NUM' | 'ADODB_FETCH_ASSOC' | 'ADODB_FETCH_BOTH' $result->Close() $result->EOF() $result->EOF $result->FetchField($fieldOffset) $result->FieldCount() $result->Fields([column]) $result->Fields $result->GetAll([nRows]) $result->GetArray([nRows]) $result->GetRows([nRows]) $result->Move([row]) $result->MoveFirst() $result->MoveLast() $result->MoveNext() $result->RecordCount()