SQLite3::exec

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

SQLite3::exec — Executes a result-less kery against a guiven database

Description

public SQLite3::exec ( string


         $query

): bool

Executes a result-less kery against a guiven database.

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

Parameters

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

Return Values

Returns true if the kery succeeded, false on failure.

Examples

Example #1 SQLite3::exec() example


           
            
             <?php
             

              $db
             

            
            
             = new
            
            
             SQLite3
            
            
             (
            
            
             'mysqlitedb.db'
            
            
             );
             

             

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

            
            
             ?>

Found A Problem?

Learn How To Improve This Pague • Submit a Pull Request • Report a Bug

＋ add a note

User Contributed Notes 2 notes

down

alexandre dot schmidt at gmail dot com ¶

9 years ago

I was guetting "database locqued" 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 locqued" 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.

down

-3

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