Re: [PHP] php/sqlite3

2009-07-08 Thread Paul M Foster
On Wed, Jul 08, 2009 at 02:55:04PM -0700, bruce wrote:

> hi...
> 
> i've got an issue where i'm trying to incorporate sqlite3 into my php.
> 
> i'm running fedora 9, php5.2.9.
> 
> the php app was  installed using the tun install process...
> 
> i know the docs say that php5+ is supposed to have sqlite incorporate
> natively...
> 
> however, on this box, it doesn't! when i do a phpinfo(), i get the pdo
> stuff, but not the sqlite.
> 
> i went ahead and followed a thread on the php.net that walked through adding
> sqlite3, using the phpize, and managed to create the sqlite3.so...
> 
> the phpinfo now has a sqlite section, with a sqlite3.extension_dir that
> points to the dir that contains the sqlite3.so..
> 
> however, when i run a test app using "sqlite_open", i'm getting an error
> saying that the "sqlite_open" is undefined...
> 
> so... my question..
> 
> how the heck can i resolve this issue!

Try sqlite3_open() just for fun. As I recall, I ran into this at one
point. The documentation for this particular module is rather poor by
php.net standards. It doesn't help that the author of sqlite changed all
the routine names at version 3.

Paul

-- 
Paul M. Foster

-- 
PHP General Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php



Re: [PHP] php/sqlite3

2009-07-08 Thread Robyn Overstreet
Did you try connecting using a PDO object instead of sqlite_open? I'm
not positive, but it looks like the sqlite_  only work with sqlite2
...

R

On Wed, Jul 8, 2009 at 2:55 PM, bruce wrote:
> hi...
>
> i've got an issue where i'm trying to incorporate sqlite3 into my php.
>
> i'm running fedora 9, php5.2.9.
>
> the php app was  installed using the tun install process...
>
> i know the docs say that php5+ is supposed to have sqlite incorporate
> natively...
>
> however, on this box, it doesn't! when i do a phpinfo(), i get the pdo
> stuff, but not the sqlite.
>
> i went ahead and followed a thread on the php.net that walked through adding
> sqlite3, using the phpize, and managed to create the sqlite3.so...
>
> the phpinfo now has a sqlite section, with a sqlite3.extension_dir that
> points to the dir that contains the sqlite3.so..
>
> however, when i run a test app using "sqlite_open", i'm getting an error
> saying that the "sqlite_open" is undefined...
>
> so... my question..
>
> how the heck can i resolve this issue!
>
> thanks..
>
> -bruce
>
>
> --
> PHP General Mailing List (http://www.php.net/)
> To unsubscribe, visit: http://www.php.net/unsub.php
>
>

--
PHP General Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php



[PHP] php/sqlite3

2009-07-08 Thread bruce
hi...

i've got an issue where i'm trying to incorporate sqlite3 into my php.

i'm running fedora 9, php5.2.9.

the php app was  installed using the tun install process...

i know the docs say that php5+ is supposed to have sqlite incorporate
natively...

however, on this box, it doesn't! when i do a phpinfo(), i get the pdo
stuff, but not the sqlite.

i went ahead and followed a thread on the php.net that walked through adding
sqlite3, using the phpize, and managed to create the sqlite3.so...

the phpinfo now has a sqlite section, with a sqlite3.extension_dir that
points to the dir that contains the sqlite3.so..

however, when i run a test app using "sqlite_open", i'm getting an error
saying that the "sqlite_open" is undefined...

so... my question..

how the heck can i resolve this issue!

thanks..

-bruce


-- 
PHP General Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php