![]() If you're in a similar situation I've written a few wrapper functions that will allow your app to work whilst you convert the code to sqlite3.įirstly convert your DB to an sqlite3 db. I have a large web app that was built with sqlite2 as the database backend and thus it exploded when I updated PHP. SQLite3Result::reset - Resets the result set back to the first rowĪs of PHP 5.4 support for Sqlite2 has been removed.SQLite3Result::numColumns - Returns the number of columns in the result set.SQLite3Result::finalize - Closes the result set.SQLite3Result::fetchArray - Fetches a result row as an associative or numerically indexed array or both.SQLite3Result::_construct - Constructs an SQLite3Result.SQLite3Result::columnType - Returns the type of the nth column.SQLite3Result::columnName - Returns the name of the nth column.SQLite3Result - The SQLite3Result class.SQLite3Stmt::reset - Resets the prepared statement.SQLite3Stmt::readOnly - Returns whether a statement is definitely read only. ![]() SQLite3Stmt::paramCount - Returns the number of parameters within the prepared statement.SQLite3Stmt::getSQL - Get the SQL of the statement.SQLite3Stmt::execute - Executes a prepared statement and returns a result set object.SQLite3Stmt::_construct - Constructs an SQLite3Stmt object.SQLite3Stmt::close - Closes the prepared statement.SQLite3Stmt::clear - Clears all current bound parameters.SQLite3Stmt::bindValue - Binds the value of a parameter to a statement variable.SQLite3Stmt::bindParam - Binds a parameter to a statement variable.SQLite3::version - Returns the SQLite3 library version as a string constant and as a number.SQLite3::setAuthorizer - Configures a callback to be used as an authorizer to limit what a statement can do.SQLite3::querySingle - Executes a query and returns a single result.SQLite3::prepare - Prepares an SQL statement for execution.SQLite3::openBlob - Opens a stream resource to read a BLOB.SQLite3::open - Opens an SQLite database.SQLite3::loadExtension - Attempts to load an SQLite extension library.SQLite3::lastInsertRowID - Returns the row ID of the most recent INSERT into the database.SQLite3::lastErrorMsg - Returns English text describing the most recent failed SQLite request.SQLite3::lastErrorCode - Returns the numeric result code of the most recent failed SQLite request.SQLite3::exec - Executes a result-less query against a given database.SQLite3::escapeString - Returns a string that has been properly escaped.SQLite3::enableExceptions - Enable throwing exceptions.SQLite3::createFunction - Registers a PHP function for use as an SQL scalar function.SQLite3::createCollation - Registers a PHP function for use as an SQL collating function.SQLite3::createAggregate - Registers a PHP function for use as an SQL aggregate function.SQLite3::_construct - Instantiates an SQLite3 object and opens an SQLite 3 database.SQLite3::close - Closes the database connection.SQLite3::changes - Returns the number of database rows that were changed (or inserted orĭeleted) by the most recent SQL statement.SQLite3::busyTimeout - Sets the busy connection handler.SQLite3::backup - Backup one database to another database.Getting Started Introduction A simple tutorial Language Reference Basic syntax Types Variables Constants Expressions Operators Control Structures Functions Classes and Objects Namespaces Enumerations Errors Exceptions Fibers Generators Attributes References Explained Predefined Variables Predefined Exceptions Predefined Interfaces and Classes Predefined Attributes Context options and parameters Supported Protocols and Wrappers Security Introduction General considerations Installed as CGI binary Installed as an Apache module Session Security Filesystem Security Database Security Error Reporting User Submitted Data Hiding PHP Keeping Current Features HTTP authentication with PHP Cookies Sessions Dealing with XForms Handling file uploads Using remote files Connection handling Persistent Database Connections Command line usage Garbage Collection DTrace Dynamic Tracing Function Reference Affecting PHP's Behaviour Audio Formats Manipulation Authentication Services Command Line Specific Extensions Compression and Archive Extensions Cryptography Extensions Database Extensions Date and Time Related Extensions File System Related Extensions Human Language and Character Encoding Support Image Processing and Generation Mail Related Extensions Mathematical Extensions Non-Text MIME Output Process Control Extensions Other Basic Extensions Other Services Search Engine Extensions Server Specific Extensions Session Extensions Text Processing Variable and Type Related Extensions Web Services Windows Only Extensions XML Manipulation GUI Extensions Keyboard Shortcuts ? This help j Next menu item k Previous menu item g p Previous man page g n Next man page G Scroll to bottom g g Scroll to top g h Goto homepage g s Goto search
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |