如何使用PHP连接到SQLite数据库？

参见英文答案 > Error: file is encrypted or is not a database                                    7个
我有一个SQLite数据库,我正在尝试使用PHP连接它.这就是我正在使用的：

<?php
    $dbconn = sqlite_open('combadd.sqlite');

    if ($dbconn) {
        $result = sqlite_query($dbconn,  "SELECT * FROM combo_calcs WHERE options='easy'");
        var_dump(sqlite_fetch_array($result, SQLITE_ASSOC));
    } else {
        print "Connection to database failed!n";
    }
?>

但是,我收到此错误：

Warning: sqlite_open() [function.sqlite-open]: file is encrypted or is not a database in C:xampphtdocsdeepthicombaddcombadd_db.php on line 4
Connection to database failed!

怎么了,怎么解决？

解决方法:

尝试使用PDO而不是sqlite_open：

$dir = 'sqlite:/[YOUR-PATH]/combadd.sqlite';
$dbh  = new PDO($dir) or die("cannot open the database");
$query =  "SELECT * FROM combo_calcs WHERE options='easy'";
foreach ($dbh->query($query) as $row)
{
    echo $row[0];
}
$dbh = null; //This is how you close a PDO connection

【说明】：本文章由站长整理发布，文章内容不代表本站观点，如文中有侵权行为，请与本站客服联系(QQ:254677821)！