php8.5
Home/ Manual/ sqlite3 / sqlite3/ SQLite3::exec

SQLite3::exec

PHP function Edit on GitHub ✎

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

Executes a result-less query against a given database

Description

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

SQLite3::exec() example

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

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

Source: reference/sqlite3/sqlite3/exec.xml · from the official PHP manual (php/doc-en)