Introduction to SQLite


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

    $result = sqlite_query("INSERT INTO tbl VALUES(1,2,3)", $db);
    /* OR */
    $result = sqlite_query($db, "INSERT INTO tbl VALUES(1,2,3)");
?>

For compatibility, procedural approach supports both MySQL & PostgreSQL/MSSQL/Etc... syntaxes.


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

    $db->query("INSERT INTO tbl VALUES(1,2,3)");
?>