how to connect a sqlite database using PHP?

Question

i have tried lot to connect database using PHP PDO. i have got lot of samples, i am not sure what was problem.

below is my code

<?php
    try
    {
        // $db = new PDO('sqlite:sampleDB.db3');
        // $db = new SQLiteDatabase('sampleDB.sqlite', 0666, $error);  
        $db = new PDO('sqlite:sampleDB.sqlite');
    }
    catch(PDOException $e)
    {
        echo $e->getMessage();
    }
?>

i have tried lot of way to open a connection. please tell me the correct way...

is that me or is there some stars after the $db = new PDO('sqlite:sampleDB.sqlite'); line ? if not me its gonna have parsing fail ... — yent
– yent, Commented Apr 1, 2011 at 13:18
Is sqlite specified in list of available drivers? Try print_r2(PDO::getAvailableDrivers()) — binaryLV
– binaryLV, Commented Apr 1, 2011 at 13:34

petermolnar · Accepted Answer · 2011-04-01 13:20:49Z

5

I gave up with PDO driver, and used sqlite3 module instead for same reasons.

With sqlite3 module:

class DB extends SQLite3
{
        function __construct( $file )
        {
            $this->open( $file );
        }
}

$db = new DB( 'sampleDB.sqlite' );

I know it's not a solution for your problem, but if nothing else works, this could be useful.

answered Apr 1, 2011 at 13:20

petermolnar

1,6241 gold badge15 silver badges23 bronze badges

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

1 Comment

ST3 Over a year ago

How do you query database using this type of connection?

mauris · Accepted Answer · 2011-04-01 13:33:44Z

1

First, you'll want to make sure you've got PHP configured to connect to SQLite - use phpinfo() to check and be sure that you have SQLite support enabled.

Next, you'll want to use the proper syntax when attempting to connect and query against a SQLite database. As per PHP Manual for sqllite e.g.

<?php

    if ($db = sqlite_open('sampleDB', 0666, $sqliteerror) ) { 
        $result = sqlite_query($db, 'select bar from foo');
        var_dump(sqlite_fetch_array($result) ); 
    } else {
        die($sqliteerror);
    }

?>

edited Apr 1, 2011 at 13:33

mauris

43.6k16 gold badges102 silver badges132 bronze badges

answered Apr 1, 2011 at 13:19

Black Box Operations

2571 silver badge5 bronze badges

4 Comments

ayathas Over a year ago

i have tried to connect/create the database in the memory. it works. $db = new PDO("sqlite::memory");

ayathas Over a year ago

same code i have executed. i am getting error message on 'unable to open the database'

Black Box Operations Over a year ago

Have you checked phpinfo() to make sure SQLLite support is enabled?

ayathas Over a year ago

how to make sure the sQLite support enable?

Michał Niedźwiedzki · Accepted Answer · 2011-04-01 13:38:45Z

1

The directory the sql file is located should be server writable. Try creating separate directory just for SQLite and give it appropriate access. In Unix you can do it so by running chmod 777 dirname. Also, amend your DSN to 'sqlite:dirname/sampleDB.sqlite'.

answered Apr 1, 2011 at 13:38

Michał Niedźwiedzki

12.9k7 gold badges47 silver badges47 bronze badges

2 Comments

ayathas Over a year ago

still i am getting the error msg. SQLSTATE[HY000] [14] unable to open database file

ayathas Over a year ago

this is how i changed my code. $dbh = new PDO('sqlite:myDir/sampleDB.sqlite');

Collectives™ on Stack Overflow

how to connect a sqlite database using PHP?

3 Answers 3

1 Comment

4 Comments

2 Comments

Your Answer

Linked

Hot Network Questions

Collectives™ on Stack Overflow

3 Answers 3

1 Comment

4 Comments

2 Comments

Your Answer

Sign up or log in

Post as a guest

Linked

Related