开发者

PDO:sqlite doesnt INSERT data, yet no error

try
{
    $res = $db->exec($sql);
    if ($res === FALSE)
    {
        print_r($db->errorInfo());
        die();
    }
}
catch(PDOException $e)
{
    die($e-开发者_如何学编程>getCode().':'.$e->getMessage());
}
catch(Exception $e)
{
    die($e->getCode().':'.$e->getMessage());
}    

No error info, and neither does it get caught as an exception. Yet $res is FALSE and no data gets inserted.

Array
(
    [0] => 
)

But when I echo $sql and enter that query in SQLiteManager, it works inserting the data.


I used sqlite only with Python, but I had to commit insert/update statements there... Maybe that's the case here too? http://docs.php.net/manual/en/pdo.commit.php


Ensure the directory where you store file is writable.

0

上一篇:

下一篇:

精彩评论

暂无评论...
验证码 换一张
取 消

最新问答

问答排行榜