[edit] Last updated: Fri, 18 Sep 2009

SQLite3::exec

(PHP 5 >= 5.3.0)

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

public bool SQLite3::exec ( string $query )

Executes a result-less query against a given database.

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

Returns TRUE if the query succeeded, FALSE on failure.

Example #1 SQLite3::exec() example


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

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

add a note User Contributed Notes SQLite3::exec

moodsey211 at gmail dot com 16-Dec-2010 03:29


If you get the error message saying "SQLite3::exec. database locked." You just need to define a busyTimeout to work around this.