无法使用php访问SQLite3数据库

Question

I've spent many-a hour trying to get a local webserver working (I'm new)

I created a sqlite3 database ('database.sql') in the www folder, and tried calling it with numerous different php commands (php 5.5, I checked) such as '$test = new SQLite('database.sql')' or the same with SQLite3, both with no luck. Also tried $test->open('database.sql'). Always with the fatal error "Class 'SQLite' not found". I've spent too many hours on what I'm sure is a very simple problem, I'm sorry to have to ask this!

Answer 1

To open a DB using PHP5 and SQLite we need to use a PDO and not the sqlite_open() function.

This is how to open or create a database: (not sure if it's bug free)

try {
    /*** connect to SQLite database ***/
    $dbh = new PDO("sqlite:VPN0.sqlite");
    echo "Handle has been created ...... <br>";
}

catch(PDOException $e) {
    echo $e->getMessage();
    echo "<br>Database is loaded UNSUCCESSFULLY .. ";
    die("<br>Query is closed $error");
}

echo "Database loaded SUCCESSFULLY ....";

Hope this helps!