enabling SQLite for use with PHP (1 Viewer)

[plug]

hello folx.

I've been working on a small site locally (using MAMP) recently; because the site is
small and there will likely be very, very few concurrent users I've been using sqlite
to provide some database action. sqlite is enabled by default on MAMP so I've been
working away with it thinking that there would be no problems. however... I uploaded
the site to a server over the weekend and sqlite is not enabled there. Nor is it enabed
on WampServer on this machine. the server is a windows machine running php version 5.2.x.

I believe sqlite is bundled by default with php v 5.x but it's not enabled by default... I haven't
had much time since to do a hell of a lot of research, but a very quick look see suggested that
it's probably not very difficult but also not particularly straightforward. I should make the time
to look more closely... in any case I thought I'd ask about it here. maybe someone here has
done this more than once before and can explain it in brief concise terms to a simpleton such
as myself. I'm assuming some tinkering with php.ini will be on the cards.

thanks in advance. d

 

[Bladez]

You just need to copy the file php_sqlite.dll to the ext directory of your php installation and add the following line to the php.ini file.
extension=php_sqlite.dll
Apparantly from php 5 onwards the sqlite extension relies on the pdo extension so you need to have this installed too.

http://ie2.php.net/manual/en/sqlite.installation.php

hello folx.

I've been working on a small site locally (using MAMP) recently; because the site is
small and there will likely be very, very few concurrent users I've been using sqlite
to provide some database action. sqlite is enabled by default on MAMP so I've been
working away with it thinking that there would be no problems. however... I uploaded
the site to a server over the weekend and sqlite is not enabled there. Nor is it enabed
on WampServer on this machine. the server is a windows machine running php version 5.2.x.

I believe sqlite is bundled by default with php v 5.x but it's not enabled by default... I haven't
had much time since to do a hell of a lot of research, but a very quick look see suggested that
it's probably not very difficult but also not particularly straightforward. I should make the time
to look more closely... in any case I thought I'd ask about it here. maybe someone here has
done this more than once before and can explain it in brief concise terms to a simpleton such
as myself. I'm assuming some tinkering with php.ini will be on the cards.

thanks in advance. d

 

[plug]

thanks bladez. just looking at the hosting package here though; it's a very basic looking shared hosting package so I don't think I have any direct access to anything I need to have access to. hmm... no big deal in any case I suppose.

 

[plug]

fuck saaake. mysqli is disabled as well. stupid shit web hosting bastards.