SQLite allows retrieval of a numeric error codes, making it simple to implement different handlers for
various errors. It also provides a mechanism for converting an error code into a human readable error string.
<?php /* Procedural Approach */
$db = sqlite_open("/path/to/database");
$result = sqlite_query("INSERT INTO tbl VALUES(1,2,3)", $db);
if (!$result) {
/* get a numeric code for the error */
$error_code = sqlite_last_error($db);
/* use the error code to get a readable error */
$error_str = sqlite_error_string($error_code);
}
?>
