Introduction to SQLite


<?php    /* Procedural Approach */
    $db = sqlite_open("/path/to/database");

    /* void sqlite_close(resource database_handle) */
    sqlite_close($db);
?>


<?php    /* Object Oriented Approach */
    $db = new sqlite_db("/path/to/database");

    unset($db);
?>

• In most cases optional as PHP will automatically close non-persistent connections.

• Unlike in other database extensions sqlite_close() can & will close persistent connections.

• For OO there is no dedicated 'close' method, so to close the connection you simply destroy the database object.