René's URL Explorer Experiment


Title: PHP: SQLite3 - Manual

X Title: PHP: SQLite3 - Manual

Open Graph Description: The SQLite3 class

X Description: The SQLite3 class

X: @official_php

direct link

Domain: php.net

DescriptionThe SQLite3 class
twitter:cardsummary_large_image
twitter:creator@official_php
twitter:image:srchttps://www.php.net/images/meta-image.png
Nonehttps://www.php.net/images/meta-image.png
og:imagehttps://www.php.net/images/meta-image.png

Links:

update page nowhttps://php.net/x-myracloud-5958a2bbbed300a9b9ac631223924e0b/1768205959.757
https://php.net/
Downloads https://php.net/downloads.php
Documentation https://php.net/docs.php
Get Involved https://php.net/get-involved.php
Help https://php.net/support.php
https://php.net/releases/8.5/index.php
https://php.net/lookup-form.php
https://php.net/menu.php
Getting Startedhttps://php.net/manual/en/getting-started.php
Introductionhttps://php.net/manual/en/introduction.php
A simple tutorialhttps://php.net/manual/en/tutorial.php
Language Referencehttps://php.net/manual/en/langref.php
Basic syntaxhttps://php.net/manual/en/language.basic-syntax.php
Typeshttps://php.net/manual/en/language.types.php
Variableshttps://php.net/manual/en/language.variables.php
Constantshttps://php.net/manual/en/language.constants.php
Expressionshttps://php.net/manual/en/language.expressions.php
Operatorshttps://php.net/manual/en/language.operators.php
Control Structureshttps://php.net/manual/en/language.control-structures.php
Functionshttps://php.net/manual/en/language.functions.php
Classes and Objectshttps://php.net/manual/en/language.oop5.php
Namespaceshttps://php.net/manual/en/language.namespaces.php
Enumerationshttps://php.net/manual/en/language.enumerations.php
Errorshttps://php.net/manual/en/language.errors.php
Exceptionshttps://php.net/manual/en/language.exceptions.php
Fibershttps://php.net/manual/en/language.fibers.php
Generatorshttps://php.net/manual/en/language.generators.php
Attributeshttps://php.net/manual/en/language.attributes.php
References Explainedhttps://php.net/manual/en/language.references.php
Predefined Variableshttps://php.net/manual/en/reserved.variables.php
Predefined Exceptionshttps://php.net/manual/en/reserved.exceptions.php
Predefined Interfaces and Classeshttps://php.net/manual/en/reserved.interfaces.php
Predefined Attributeshttps://php.net/manual/en/reserved.attributes.php
Context options and parametershttps://php.net/manual/en/context.php
Supported Protocols and Wrappershttps://php.net/manual/en/wrappers.php
Securityhttps://php.net/manual/en/security.php
Introductionhttps://php.net/manual/en/security.intro.php
General considerationshttps://php.net/manual/en/security.general.php
Installed as CGI binaryhttps://php.net/manual/en/security.cgi-bin.php
Installed as an Apache modulehttps://php.net/manual/en/security.apache.php
Session Securityhttps://php.net/manual/en/security.sessions.php
Filesystem Securityhttps://php.net/manual/en/security.filesystem.php
Database Securityhttps://php.net/manual/en/security.database.php
Error Reportinghttps://php.net/manual/en/security.errors.php
User Submitted Datahttps://php.net/manual/en/security.variables.php
Hiding PHPhttps://php.net/manual/en/security.hiding.php
Keeping Currenthttps://php.net/manual/en/security.current.php
Featureshttps://php.net/manual/en/features.php
HTTP authentication with PHPhttps://php.net/manual/en/features.http-auth.php
Cookieshttps://php.net/manual/en/features.cookies.php
Sessionshttps://php.net/manual/en/features.sessions.php
Handling file uploadshttps://php.net/manual/en/features.file-upload.php
Using remote fileshttps://php.net/manual/en/features.remote-files.php
Connection handlinghttps://php.net/manual/en/features.connection-handling.php
Persistent Database Connectionshttps://php.net/manual/en/features.persistent-connections.php
Command line usagehttps://php.net/manual/en/features.commandline.php
Garbage Collectionhttps://php.net/manual/en/features.gc.php
DTrace Dynamic Tracinghttps://php.net/manual/en/features.dtrace.php
Function Referencehttps://php.net/manual/en/funcref.php
Affecting PHP's Behaviourhttps://php.net/manual/en/refs.basic.php.php
Audio Formats Manipulationhttps://php.net/manual/en/refs.utilspec.audio.php
Authentication Serviceshttps://php.net/manual/en/refs.remote.auth.php
Command Line Specific Extensionshttps://php.net/manual/en/refs.utilspec.cmdline.php
Compression and Archive Extensionshttps://php.net/manual/en/refs.compression.php
Cryptography Extensionshttps://php.net/manual/en/refs.crypto.php
Database Extensionshttps://php.net/manual/en/refs.database.php
Date and Time Related Extensionshttps://php.net/manual/en/refs.calendar.php
File System Related Extensionshttps://php.net/manual/en/refs.fileprocess.file.php
Human Language and Character Encoding Supporthttps://php.net/manual/en/refs.international.php
Image Processing and Generationhttps://php.net/manual/en/refs.utilspec.image.php
Mail Related Extensionshttps://php.net/manual/en/refs.remote.mail.php
Mathematical Extensionshttps://php.net/manual/en/refs.math.php
Non-Text MIME Outputhttps://php.net/manual/en/refs.utilspec.nontext.php
Process Control Extensionshttps://php.net/manual/en/refs.fileprocess.process.php
Other Basic Extensionshttps://php.net/manual/en/refs.basic.other.php
Other Serviceshttps://php.net/manual/en/refs.remote.other.php
Search Engine Extensionshttps://php.net/manual/en/refs.search.php
Server Specific Extensionshttps://php.net/manual/en/refs.utilspec.server.php
Session Extensionshttps://php.net/manual/en/refs.basic.session.php
Text Processinghttps://php.net/manual/en/refs.basic.text.php
Variable and Type Related Extensionshttps://php.net/manual/en/refs.basic.vartype.php
Web Serviceshttps://php.net/manual/en/refs.webservice.php
Windows Only Extensionshttps://php.net/manual/en/refs.utilspec.windows.php
XML Manipulationhttps://php.net/manual/en/refs.xml.php
GUI Extensionshttps://php.net/manual/en/refs.ui.php
SQLite3::backup » https://php.net/sqlite3.backup.php
« Predefined Constants https://php.net/sqlite3.constants.php
PHP Manualhttps://php.net/index.php
Function Referencehttps://php.net/funcref.php
Database Extensionshttps://php.net/refs.database.php
Vendor Specific Database Extensionshttps://php.net/refs.database.vendors.php
SQLite3https://php.net/book.sqlite3.php
inthttps://php.net/language.types.integer.php
OKhttps://php.net/class.sqlite3.php#sqlite3.constants.ok
inthttps://php.net/language.types.integer.php
DENYhttps://php.net/class.sqlite3.php#sqlite3.constants.deny
inthttps://php.net/language.types.integer.php
IGNOREhttps://php.net/class.sqlite3.php#sqlite3.constants.ignore
inthttps://php.net/language.types.integer.php
CREATE_INDEXhttps://php.net/class.sqlite3.php#sqlite3.constants.create-index
inthttps://php.net/language.types.integer.php
CREATE_TABLEhttps://php.net/class.sqlite3.php#sqlite3.constants.create-table
inthttps://php.net/language.types.integer.php
CREATE_TEMP_INDEXhttps://php.net/class.sqlite3.php#sqlite3.constants.create-temp-index
inthttps://php.net/language.types.integer.php
CREATE_TEMP_TABLEhttps://php.net/class.sqlite3.php#sqlite3.constants.create-temp-table
inthttps://php.net/language.types.integer.php
CREATE_TEMP_TRIGGERhttps://php.net/class.sqlite3.php#sqlite3.constants.create-temp-trigger
inthttps://php.net/language.types.integer.php
CREATE_TEMP_VIEWhttps://php.net/class.sqlite3.php#sqlite3.constants.create-temp-view
inthttps://php.net/language.types.integer.php
CREATE_TRIGGERhttps://php.net/class.sqlite3.php#sqlite3.constants.create-trigger
inthttps://php.net/language.types.integer.php
CREATE_VIEWhttps://php.net/class.sqlite3.php#sqlite3.constants.create-view
inthttps://php.net/language.types.integer.php
DELETEhttps://php.net/class.sqlite3.php#sqlite3.constants.delete
inthttps://php.net/language.types.integer.php
DROP_INDEXhttps://php.net/class.sqlite3.php#sqlite3.constants.drop-index
inthttps://php.net/language.types.integer.php
DROP_TABLEhttps://php.net/class.sqlite3.php#sqlite3.constants.drop-table
inthttps://php.net/language.types.integer.php
DROP_TEMP_INDEXhttps://php.net/class.sqlite3.php#sqlite3.constants.drop-temp-index
inthttps://php.net/language.types.integer.php
DROP_TEMP_TABLEhttps://php.net/class.sqlite3.php#sqlite3.constants.drop-temp-table
inthttps://php.net/language.types.integer.php
DROP_TEMP_TRIGGERhttps://php.net/class.sqlite3.php#sqlite3.constants.drop-temp-trigger
inthttps://php.net/language.types.integer.php
DROP_TEMP_VIEWhttps://php.net/class.sqlite3.php#sqlite3.constants.drop-temp-view
inthttps://php.net/language.types.integer.php
DROP_TRIGGERhttps://php.net/class.sqlite3.php#sqlite3.constants.drop-trigger
inthttps://php.net/language.types.integer.php
DROP_VIEWhttps://php.net/class.sqlite3.php#sqlite3.constants.drop-view
inthttps://php.net/language.types.integer.php
INSERThttps://php.net/class.sqlite3.php#sqlite3.constants.insert
inthttps://php.net/language.types.integer.php
PRAGMAhttps://php.net/class.sqlite3.php#sqlite3.constants.pragma
inthttps://php.net/language.types.integer.php
READhttps://php.net/class.sqlite3.php#sqlite3.constants.read
inthttps://php.net/language.types.integer.php
SELECThttps://php.net/class.sqlite3.php#sqlite3.constants.select
inthttps://php.net/language.types.integer.php
TRANSACTIONhttps://php.net/class.sqlite3.php#sqlite3.constants.transaction
inthttps://php.net/language.types.integer.php
UPDATEhttps://php.net/class.sqlite3.php#sqlite3.constants.update
inthttps://php.net/language.types.integer.php
ATTACHhttps://php.net/class.sqlite3.php#sqlite3.constants.attach
inthttps://php.net/language.types.integer.php
DETACHhttps://php.net/class.sqlite3.php#sqlite3.constants.detach
inthttps://php.net/language.types.integer.php
ALTER_TABLEhttps://php.net/class.sqlite3.php#sqlite3.constants.alter-table
inthttps://php.net/language.types.integer.php
REINDEXhttps://php.net/class.sqlite3.php#sqlite3.constants.reindex
inthttps://php.net/language.types.integer.php
ANALYZEhttps://php.net/class.sqlite3.php#sqlite3.constants.analyze
inthttps://php.net/language.types.integer.php
CREATE_VTABLEhttps://php.net/class.sqlite3.php#sqlite3.constants.create-vtable
inthttps://php.net/language.types.integer.php
DROP_VTABLEhttps://php.net/class.sqlite3.php#sqlite3.constants.drop-vtable
inthttps://php.net/language.types.integer.php
FUNCTIONhttps://php.net/class.sqlite3.php#sqlite3.constants.function
inthttps://php.net/language.types.integer.php
SAVEPOINThttps://php.net/class.sqlite3.php#sqlite3.constants.savepoint
inthttps://php.net/language.types.integer.php
COPYhttps://php.net/class.sqlite3.php#sqlite3.constants.copy
inthttps://php.net/language.types.integer.php
RECURSIVEhttps://php.net/class.sqlite3.php#sqlite3.constants.recursive
__constructhttps://php.net/sqlite3.construct.php
stringhttps://php.net/language.types.string.php
inthttps://php.net/language.types.integer.php
stringhttps://php.net/language.types.string.php
backuphttps://php.net/sqlite3.backup.php
SQLite3https://php.net/class.sqlite3.php
stringhttps://php.net/language.types.string.php
stringhttps://php.net/language.types.string.php
boolhttps://php.net/language.types.boolean.php
busyTimeouthttps://php.net/sqlite3.busytimeout.php
inthttps://php.net/language.types.integer.php
boolhttps://php.net/language.types.boolean.php
changeshttps://php.net/sqlite3.changes.php
inthttps://php.net/language.types.integer.php
closehttps://php.net/sqlite3.close.php
boolhttps://php.net/language.types.boolean.php
createAggregatehttps://php.net/sqlite3.createaggregate.php
stringhttps://php.net/language.types.string.php
callablehttps://php.net/language.types.callable.php
callablehttps://php.net/language.types.callable.php
inthttps://php.net/language.types.integer.php
boolhttps://php.net/language.types.boolean.php
createCollationhttps://php.net/sqlite3.createcollation.php
stringhttps://php.net/language.types.string.php
callablehttps://php.net/language.types.callable.php
boolhttps://php.net/language.types.boolean.php
createFunctionhttps://php.net/sqlite3.createfunction.php
stringhttps://php.net/language.types.string.php
callablehttps://php.net/language.types.callable.php
inthttps://php.net/language.types.integer.php
inthttps://php.net/language.types.integer.php
boolhttps://php.net/language.types.boolean.php
enableExceptionshttps://php.net/sqlite3.enableexceptions.php
boolhttps://php.net/language.types.boolean.php
falsehttps://php.net/reserved.constants.php#constant.false
boolhttps://php.net/language.types.boolean.php
escapeStringhttps://php.net/sqlite3.escapestring.php
stringhttps://php.net/language.types.string.php
stringhttps://php.net/language.types.string.php
exechttps://php.net/sqlite3.exec.php
stringhttps://php.net/language.types.string.php
boolhttps://php.net/language.types.boolean.php
lastErrorCodehttps://php.net/sqlite3.lasterrorcode.php
inthttps://php.net/language.types.integer.php
lastErrorMsghttps://php.net/sqlite3.lasterrormsg.php
stringhttps://php.net/language.types.string.php
lastInsertRowIDhttps://php.net/sqlite3.lastinsertrowid.php
inthttps://php.net/language.types.integer.php
loadExtensionhttps://php.net/sqlite3.loadextension.php
stringhttps://php.net/language.types.string.php
boolhttps://php.net/language.types.boolean.php
openhttps://php.net/sqlite3.open.php
stringhttps://php.net/language.types.string.php
inthttps://php.net/language.types.integer.php
stringhttps://php.net/language.types.string.php
voidhttps://php.net/language.types.void.php
openBlobhttps://php.net/sqlite3.openblob.php
stringhttps://php.net/language.types.string.php
stringhttps://php.net/language.types.string.php
inthttps://php.net/language.types.integer.php
stringhttps://php.net/language.types.string.php
inthttps://php.net/language.types.integer.php
SQLITE3_OPEN_READONLYhttps://php.net/sqlite3.constants.php#constant.sqlite3-open-readonly
resourcehttps://php.net/language.types.resource.php
falsehttps://php.net/language.types.singleton.php
preparehttps://php.net/sqlite3.prepare.php
stringhttps://php.net/language.types.string.php
SQLite3Stmthttps://php.net/class.sqlite3stmt.php
falsehttps://php.net/language.types.singleton.php
queryhttps://php.net/sqlite3.query.php
stringhttps://php.net/language.types.string.php
SQLite3Resulthttps://php.net/class.sqlite3result.php
falsehttps://php.net/language.types.singleton.php
querySinglehttps://php.net/sqlite3.querysingle.php
stringhttps://php.net/language.types.string.php
boolhttps://php.net/language.types.boolean.php
falsehttps://php.net/reserved.constants.php#constant.false
mixedhttps://php.net/language.types.mixed.php
setAuthorizerhttps://php.net/sqlite3.setauthorizer.php
?https://php.net/language.types.null.php
callablehttps://php.net/language.types.callable.php
boolhttps://php.net/language.types.boolean.php
versionhttps://php.net/sqlite3.version.php
arrayhttps://php.net/language.types.array.php
SQLite3::OKhttps://php.net/class.sqlite3.php#sqlite3.constants.ok
SQLite3::DENYhttps://php.net/class.sqlite3.php#sqlite3.constants.deny
SQLite3::IGNOREhttps://php.net/class.sqlite3.php#sqlite3.constants.ignore
SQLite3::CREATE_INDEXhttps://php.net/class.sqlite3.php#sqlite3.constants.create-index
SQLite3::CREATE_TABLEhttps://php.net/class.sqlite3.php#sqlite3.constants.create-table
SQLite3::CREATE_TEMP_INDEXhttps://php.net/class.sqlite3.php#sqlite3.constants.create-temp-index
SQLite3::CREATE_TEMP_TABLEhttps://php.net/class.sqlite3.php#sqlite3.constants.create-temp-table
SQLite3::CREATE_TEMP_TRIGGERhttps://php.net/class.sqlite3.php#sqlite3.constants.create-temp-trigger
SQLite3::CREATE_TEMP_VIEWhttps://php.net/class.sqlite3.php#sqlite3.constants.create-temp-view
SQLite3::CREATE_TRIGGERhttps://php.net/class.sqlite3.php#sqlite3.constants.create-trigger
SQLite3::CREATE_VIEWhttps://php.net/class.sqlite3.php#sqlite3.constants.create-view
SQLite3::DELETEhttps://php.net/class.sqlite3.php#sqlite3.constants.delete
SQLite3::DROP_INDEXhttps://php.net/class.sqlite3.php#sqlite3.constants.drop-index
SQLite3::DROP_TABLEhttps://php.net/class.sqlite3.php#sqlite3.constants.drop-table
SQLite3::DROP_TEMP_INDEXhttps://php.net/class.sqlite3.php#sqlite3.constants.drop-temp-index
SQLite3::DROP_TEMP_TABLEhttps://php.net/class.sqlite3.php#sqlite3.constants.drop-temp-table
SQLite3::DROP_TEMP_TRIGGERhttps://php.net/class.sqlite3.php#sqlite3.constants.drop-temp-trigger
SQLite3::DROP_TEMP_VIEWhttps://php.net/class.sqlite3.php#sqlite3.constants.drop-temp-view
SQLite3::DROP_TRIGGERhttps://php.net/class.sqlite3.php#sqlite3.constants.drop-trigger
SQLite3::DROP_VIEWhttps://php.net/class.sqlite3.php#sqlite3.constants.drop-view
SQLite3::INSERThttps://php.net/class.sqlite3.php#sqlite3.constants.insert
SQLite3::PRAGMAhttps://php.net/class.sqlite3.php#sqlite3.constants.pragma
SQLite3::READhttps://php.net/class.sqlite3.php#sqlite3.constants.read
SQLite3::SELECThttps://php.net/class.sqlite3.php#sqlite3.constants.select
SQLite3::TRANSACTIONhttps://php.net/class.sqlite3.php#sqlite3.constants.transaction
SQLite3::UPDATEhttps://php.net/class.sqlite3.php#sqlite3.constants.update
SQLite3::ATTACHhttps://php.net/class.sqlite3.php#sqlite3.constants.attach
SQLite3::DETACHhttps://php.net/class.sqlite3.php#sqlite3.constants.detach
SQLite3::ALTER_TABLEhttps://php.net/class.sqlite3.php#sqlite3.constants.alter-table
SQLite3::REINDEXhttps://php.net/class.sqlite3.php#sqlite3.constants.reindex
SQLite3::ANALYZEhttps://php.net/class.sqlite3.php#sqlite3.constants.analyze
SQLite3::CREATE_VTABLEhttps://php.net/class.sqlite3.php#sqlite3.constants.create-vtable
SQLite3::DROP_VTABLEhttps://php.net/class.sqlite3.php#sqlite3.constants.drop-vtable
SQLite3::FUNCTIONhttps://php.net/class.sqlite3.php#sqlite3.constants.function
SQLite3::SAVEPOINThttps://php.net/class.sqlite3.php#sqlite3.constants.savepoint
SQLite3::COPYhttps://php.net/class.sqlite3.php#sqlite3.constants.copy
SQLite3::RECURSIVEhttps://php.net/class.sqlite3.php#sqlite3.constants.recursive
SQLite3::backuphttps://php.net/sqlite3.backup.php
SQLite3::busyTimeouthttps://php.net/sqlite3.busytimeout.php
SQLite3::changeshttps://php.net/sqlite3.changes.php
SQLite3::closehttps://php.net/sqlite3.close.php
SQLite3::__constructhttps://php.net/sqlite3.construct.php
SQLite3::createAggregatehttps://php.net/sqlite3.createaggregate.php
SQLite3::createCollationhttps://php.net/sqlite3.createcollation.php
SQLite3::createFunctionhttps://php.net/sqlite3.createfunction.php
SQLite3::enableExceptionshttps://php.net/sqlite3.enableexceptions.php
SQLite3::escapeStringhttps://php.net/sqlite3.escapestring.php
SQLite3::exechttps://php.net/sqlite3.exec.php
SQLite3::lastErrorCodehttps://php.net/sqlite3.lasterrorcode.php
SQLite3::lastErrorMsghttps://php.net/sqlite3.lasterrormsg.php
SQLite3::lastInsertRowIDhttps://php.net/sqlite3.lastinsertrowid.php
SQLite3::loadExtensionhttps://php.net/sqlite3.loadextension.php
SQLite3::openhttps://php.net/sqlite3.open.php
SQLite3::openBlobhttps://php.net/sqlite3.openblob.php
SQLite3::preparehttps://php.net/sqlite3.prepare.php
SQLite3::queryhttps://php.net/sqlite3.query.php
SQLite3::querySinglehttps://php.net/sqlite3.querysingle.php
SQLite3::setAuthorizerhttps://php.net/sqlite3.setauthorizer.php
SQLite3::versionhttps://php.net/sqlite3.version.php
Learn How To Improve This Pagehttps://github.com/php/doc-base/blob/master/README.md
Submit a Pull Requesthttps://github.com/php/doc-en/blob/master/reference/sqlite3/sqlite3.xml
Report a Bughttps://github.com/php/doc-en/issues/new?body=From%20manual%20page:%20https:%2F%2Fphp.net%2Fclass.sqlite3%0A%0A---
+add a notehttps://php.net/manual/add-note.php?sect=class.sqlite3&repo=en&redirect=https://www.php.net/manual/en/class.sqlite3.php
SQLite3https://php.net/book.sqlite3.php
Introductionhttps://php.net/intro.sqlite3.php
Installing/Configuringhttps://php.net/sqlite3.setup.php
Predefined Constantshttps://php.net/sqlite3.constants.php
SQLite3https://php.net/class.sqlite3.php
SQLite3Exceptionhttps://php.net/class.sqlite3exception.php
SQLite3Stmthttps://php.net/class.sqlite3stmt.php
SQLite3Resulthttps://php.net/class.sqlite3result.php
Copyright © 2001-2026 The PHP Documentation Grouphttps://php.net/manual/en/copyright.php
My PHP.nethttps://php.net/my.php
Contacthttps://php.net/contact.php
Other PHP.net siteshttps://php.net/sites.php
Privacy policyhttps://php.net/privacy.php
javascript:;

Viewport: width=device-width, initial-scale=1.0


URLs of crawlers that visited me.