Access sqlite db which is placed locally on the server

Question

I am developing a php application that needs to query an sqlite database which is not placed in the www folder. I am using the following code to connect.

$db = sqlite_open($path, 0666, $sqliteerror);

but there is some kind of error. My app is placed in httpdocs section. so how can i specify the path to my db?

$path='/srv/smartfox/Server/db/myDB.sqlite';

Can you elaborate "Some kind of error". It is difficult to read minds these days :) — McKracken
– McKracken, Commented Dec 19, 2011 at 16:07
lol it says "server error" when i upload the file but if i dont try to connect the db..then everything goes smoothly. can i know what the exact error is by printing $sqliteerror? — samach
– samach, Commented Dec 19, 2011 at 16:14
@Salmanmahmood I don't know... can you? (i.e. have you tried?) — user336242
– user336242, Commented Dec 19, 2011 at 16:34

RickN · Accepted Answer · 2011-12-19 16:29:29Z

1

Check the following:

The PHP process has to have read access to the database file.
The PHP process has to have write access to the file and the enclosing folder if you're trying to write to the database (Sqlite might need this even if you're not writing, but I'm not sure about that).
You might not have the Sqlite extension enabled. Check it with phpinfo().

Try this:

Enable error logging to see what error you get.
Try accessing a database inside your httpdocs folder. Does that work?
Use PDO to connect to the database.

answered Dec 19, 2011 at 16:29

RickN

13.6k4 gold badges28 silver badges30 bronze badges

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

Comments

Tudor Constantin · Accepted Answer · 2011-12-19 16:06:41Z

0

By putting the path between apostrophes:

$path='/srv/smartfox/Server/db/myDB.sqlite';

answered Dec 19, 2011 at 16:06

Tudor Constantin

26.9k7 gold badges54 silver badges73 bronze badges

Comments

Rajat · Accepted Answer · 2011-12-20 08:11:07Z

0

Just check root directory for your script by: $_SERVER["DOCUMENT_ROOT"] and then decide the path for the sqlite file. I think there might be a problem regarding the path. If your control is in 'www' directory than use:

$path = 'srv/smartfox/Server/db/myDB.sqlite';

Hope it might work!!!

answered Dec 20, 2011 at 8:11

Rajat

1,3884 gold badges18 silver badges33 bronze badges

Collectives™ on Stack Overflow

Access sqlite db which is placed locally on the server

3 Answers 3

Comments

Comments

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

3 Answers 3

Comments

Comments

Comments

Your Answer

Sign up or log in

Post as a guest

Related