How to Getting Error Message from SQLite Execute PHP

Question

I have a simple form that inserts data into my sqlite database. It works just fine on my localhost, however, I am not getting the insert to work on my remote server. How do I get error messages if my execute() never happens or === false?

Here is my code:

if (isset($_POST["submit"])) {
    $email = $_POST["Email"];
    $name = $_POST["txt_Name"];
    $agency = $_POST["sel_Agency"];
    $subagency = $_POST["txt_SubAgency"];
    $location = $_POST["txt_Location"];

    $params = array(
        ':email' => $email,
        ':name' => $name,
        ':agency' => $agency,
        ':subagency' => $subagency,
        ':location' => $location
    );

    $stmt = $db->prepare($sql);

    if ($stmt->execute($params) === FALSE) {
        //HOW TO SHOW ERROR CODE HERE
    }
}

I tried a try-catch, but didn't get anything. However, if I echo "ERROR" for example, I get the echo ERROR on screen.... I know it isn't working also, since the db has no new rows.

Any help would be appreciated. Thanks!

Use set_error_handler : stackoverflow.com/questions/1241728/can-i-try-catch-a-warning/… — Goufalite
– Goufalite, Commented Jan 6, 2016 at 15:26

uacaman · Accepted Answer · 2014-01-30 16:18:32Z

1

If you are using PDO, to get the last error use $db->errorCode() to get erro code and $db->errorInfo() get error info

answered Jan 30, 2014 at 16:18

uacaman

4181 gold badge5 silver badges15 bronze badges

Sign up to request clarification or add additional context in comments.

1 Comment

Goufalite Over a year ago

This sure is a solution, but for those who just want a light interface using the built-in SQlite3 provided with PHP. Too bad the documentation isn't efficient for such a specific needs...

Collectives™ on Stack Overflow

How to Getting Error Message from SQLite Execute PHP

1 Answer 1

1 Comment

Your Answer

Linked

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

1 Comment

Your Answer

Sign up or log in

Post as a guest

Linked

Related