Connect to localhost sqlite db with php

Question

I have UwAmp installed and running. I have set up a mysqlite db on the localhost and I'm trying to connect to it using the following PHP code:

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

}
catch(PDOException $e)
{
    echo $e->getMessage();
    echo "<br><br>Database -- NOT -- loaded successfully .. ";
    die( "<br><br>Query Closed !!! $error");
}
echo "Database loaded successfully ....";
?>

The db is called graspe and when I run this script it says that it has connected successfully. If I change the name of the database to something else it still returns a successfully connected message. What am I doing wrong? Thanks in advance.

I've a feeling your try/catch isn't kicking in. What happens when you remove echo "Database loaded successfully ....";? and where is this defined $error ? error reporting should have thrown you something about it. — Funk Forty Niner
– Funk Forty Niner, Commented Jul 26, 2016 at 0:06
When I remove the echo line I get "Handle has been created......" If I change the name of the db to something else, I still get the same success message. — KPM
– KPM, Commented Jul 26, 2016 at 0:09
what about checking for errors php.net/manual/en/pdo.error-handling.php and php.net/manual/en/function.error-reporting.php - anything from that? — Funk Forty Niner
– Funk Forty Niner, Commented Jul 26, 2016 at 0:10
Nothing.... enabled all error levels and the code is still reporting success. I'm wondering is it creating a new db each time it runs? — KPM
– KPM, Commented Jul 26, 2016 at 0:17

Dekel · Accepted Answer · 2016-07-26 00:14:09Z

2

By default when you construct a new connection to sqlite database - that database will be created if it doesn't exists.

If you want to test your code to make sure it throws an exception when the database cannot be created you can try to write to filename that you don't have permissions to (new PDO("sqlite:/");)

answered Jul 26, 2016 at 0:14

Dekel

62.9k12 gold badges109 silver badges130 bronze badges

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

7 Comments

icecub Over a year ago

Or you simply check if the database file exists / is writeable :)

KPM Over a year ago

I tried the code above and I receive the error message SQLSTATE[HY000] [14] unable to open database file Database -- NOT -- loaded successfully .. Query Closed !!! PDOException: SQLSTATE[HY000] [14] unable to open database file in C:\Users\max\Desktop\Graspe\graspe\db_connect.php:13 Stack trace: #0 C:\Users\max\Desktop\Graspe\graspe\db_connect.php(13): PDO->__construct('sqlite:/') #1 {main}

Dekel Over a year ago

@KPM, this is expected - it's exactly what your code does.

KPM Over a year ago

So from that message, I'm assuming it is just creating a new db each time it runs and isn't actually connecting to the db that I have set up in PHPmyadmin on the localhost. Any ideas?

KPM Over a year ago

Yes..looking back at the control panel, I have mixed the two of them up. Thanks for the info. I'll try using MySQL commands to connect.

|

Collectives™ on Stack Overflow

Connect to localhost sqlite db with php

1 Answer 1

7 Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

7 Comments

Your Answer

Sign up or log in

Post as a guest

Related