Overview
KB
Technical FAQ
PHP Manual
CSS2 Manual
HTML Manual
JS Guide
JS Reference
PhpDock Manual
Nu-Coder Manual
PhpExpress Manual
PHP Joomla
Development
Learn PHP
 
<SQLite3::escapeStringSQLite3::lastErrorCode>
^SQLite3Last updated: Mon, 26 Oct 2026

SQLite3::exec

(PHP 5 >= 5.3.0, PHP 7, PHP 8)

SQLite3::exec — Executes a result-less query against a given database

Description

public function SQLite3::exec(string $query): bool

Executes a result-less query against a given database.

Note:

SQLite3 may need to create » temporary files during the execution of queries, so the respective directories may have to be writable.

Parameters

query

The SQL query to execute (typically an INSERT, UPDATE, or DELETE query).

Return Values

Returns true if the query succeeded, false on failure.

Examples

Example #1 SQLite3::exec() example

<?php
$db = new SQLite3('mysqlitedb.db');

$db->exec('CREATE TABLE bar (bar TEXT)');
?>


<SQLite3::escapeStringSQLite3::lastErrorCode>
^SQLite3Last updated: Mon, 26 Oct 2026