SQLite3::exec

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

SQLite3::exec — ExĂ©cute une requĂȘte sur une base de donnĂ©es

Description

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

ExĂ©cute une requĂȘte sur une base de donnĂ©es.

Note: SQLite3 doit parfois crĂ©er des » fichiers temporaires lors de l'exĂ©cution des requĂȘtes, donc les dossiers respectifs doivent ĂȘtre accessibles en Ă©criture.

Liste de paramĂštres

query

La requĂȘte SQL Ă  exĂ©cuter (typiquement, une requĂȘte de type INSERT, UPDATE ou DELETE).

Valeurs de retour

Retourne true si la requĂȘte a Ă©tĂ© exĂ©cutĂ©e avec succĂšs, false si une erreur survient.

Exemples

Exemple #1 Exemple avec SQLite3::exec()

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

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

Found A Problem?

Learn How To Improve This Page ‱ Submit a Pull Request ‱ Report a Bug
add a note

User Contributed Notes 2 notes

up
21
alexandre dot schmidt at gmail dot com ¶
10 years ago
I was getting "database locked" all the time until I found out some features of sqlite3 must be set by using SQL special instructions (i.e. using PRAGMA keyword). For instance, what apparently solved my problem with "database locked" was to set journal_mode to 'wal' (it is defaulting to 'delete', as stated here: https://www.sqlite.org/wal.html (see Activating  And Configuring WAL Mode)).

So basically what I had to do was creating a connection to the database and setting journal_mode with the SQL statement. Example:

<?php
$db = new SQLite3('/my/sqlite/file.sqlite3');
$db->busyTimeout(5000);
// WAL mode has better control over concurrency.
// Source: https://www.sqlite.org/wal.html
$db->exec('PRAGMA journal_mode = wal;');
?>

Hope that helps.
up
-5
synnus ¶
3 years ago
<?php
       $db->exec('PRAGMA journal_mode = wal;');
       $db->exec('PRAGMA synchronous = NORMAL;');
       $db->exec('PRAGMA schema.taille_cache = 16000;');
?>
add a note