sqlite3数据库类

• SQLite3::busyTimeout()
• Setsthebusyconnectionhandler

• SQLite3::changes()
• Returnsthenumberofdatabaserowsthatwerechanged(orinsertedordeleted)bythemostrecentSQLstatement

• SQLite3::close()
• Closesthedatabaseconnection

• SQLite3::__construct()
• InstantiatesanSQLite3objectandopensanSQLite3database

• SQLite3::createAggregate()
• RegistersaPHPfunctionforuseasanSQLaggregatefunction

• SQLite3::createCollation()
• RegistersaPHPfunctionforuseasanSQLcollatingfunction

• SQLite3::createFunction()
• RegistersaPHPfunctionforuseasanSQLscalarfunction

• SQLite3::enableExceptions()
• Enablethrowingexceptions

• SQLite3::escapeString()
• Returnsastringthathasbeenproperlyescaped

• SQLite3::exec()
• Executesaresult-lessqueryagainstagivendatabase

• SQLite3::lastErrorCode()
• ReturnsthenumericresultcodeofthemostrecentfailedSQLiterequest

• SQLite3::lastErrorMsg()
• ReturnsEnglishtextdescribingthemostrecentfailedSQLiterequest

• SQLite3::lastInsertRowID()
• ReturnstherowIDofthemostrecentINSERTintothedatabase

• SQLite3::loadExtension()
• AttemptstoloadanSQLiteextensionlibrary

• SQLite3::open()
• OpensanSQLitedatabase

• SQLite3::openBlob()
• OpensastreamresourcetoreadaBLOB

• SQLite3::prepare()
• PreparesanSQLstatementforexecution

• SQLite3::query()
• ExecutesanSQLquery

• SQLite3::querySingle()
• Executesaqueryandreturnsasingleresult

• SQLite3::version()
• ReturnstheSQLite3libraryversionasastringconstantandasanumber

• SQLite3Stmt::bindParam()
• Bindsaparametertoastatementvariable

• SQLite3Stmt::bindValue()
• Bindsthevalueofaparametertoastatementvariable

• SQLite3Stmt::clear()
• Clearsallcurrentboundparameters

• SQLite3Stmt::close()
• Closesthepreparedstatement

• SQLite3Stmt::execute()
• Executesapreparedstatementandreturnsaresultsetobject

• SQLite3Stmt::getSQL()
• GettheSQLofthestatement

• SQLite3Stmt::paramCount()
• Returnsthenumberofparameterswithinthepreparedstatement

• SQLite3Stmt::readOnly()
• Returnswhetherastatementisdefinitelyreadonly

• SQLite3Stmt::reset()
• Resetsthepreparedstatement

• SQLite3Result::columnName()
• Returnsthenameofthenthcolumn

• SQLite3Result::columnType()
• Returnsthetypeofthenthcolumn

• SQLite3Result::fetchArray()
• Fetchesaresultrowasanassociativeornumericallyindexedarrayorboth

• SQLite3Result::finalize()
• Closestheresultset

• SQLite3Result::numColumns()
• Returnsthenumberofcolumnsintheresultset

• SQLite3Result::reset()
• Resetstheresultsetbacktothefirstrow