PHP Language - sqlite

Author

sqlite

Siegfreed

2006-12-23, 4:36 am

Problem description:

I have php version 5.1.6, but I am having troubles in running sqlite.

For example, when i run the following code:

<?php
// create new database (procedural interface)
$db = sqlite_open("db.sqlite");

// uncomment next line if you still need to create table foo
// sqlite_query($db , "CREATE TABLE foo (id INTEGER PRIMARY KEY, name
CHAR(255))");

// insert sample data
sqlite_query($db, "INSERT INTO foo (name) VALUES ('Ilia')");
sqlite_query($db, "INSERT INTO foo (name) VALUES ('Ilia2')");
sqlite_query($db, "INSERT INTO foo (name) VALUES ('Ilia3')");

// execute query
$result = sqlite_query($db, "SELECT * FROM foo");
// iterate through the retrieved rows
while ($row = sqlite_fetch_array($result)) {
print_r($row);
/* each result looks something like this
Array
(
[0] => 1
[id] => 1
[1] => Ilia
[name] => Ilia
)
*/
}

// close database connection
sqlite_close($db);

?>

I get the following message:

Fatal error: Call to undefined function sqlite_open() in
C:\http-dir\new_db_02.htm on line 15

What the problem(s) is, or are?

Ric

2006-12-23, 4:36 am

Siegfreed schrieb:
> Problem description:
>
> I have php version 5.1.6, but I am having troubles in running sqlite.
>
> For example, when i run the following code:
>
> <?php
> // create new database (procedural interface)
> $db = sqlite_open("db.sqlite");
>
> // uncomment next line if you still need to create table foo
> // sqlite_query($db , "CREATE TABLE foo (id INTEGER PRIMARY KEY, name
> CHAR(255))");
>
> // insert sample data
> sqlite_query($db, "INSERT INTO foo (name) VALUES ('Ilia')");
> sqlite_query($db, "INSERT INTO foo (name) VALUES ('Ilia2')");
> sqlite_query($db, "INSERT INTO foo (name) VALUES ('Ilia3')");
>
> // execute query
> $result = sqlite_query($db, "SELECT * FROM foo");
> // iterate through the retrieved rows
> while ($row = sqlite_fetch_array($result)) {
> print_r($row);
> /* each result looks something like this
> Array
> (
> [0] => 1
> [id] => 1
> [1] => Ilia
> [name] => Ilia
> )
> */
> }
>
> // close database connection
> sqlite_close($db);
>
> ?>
>
> I get the following message:
>
> Fatal error: Call to undefined function sqlite_open() in
> C:\http-dir\new_db_02.htm on line 15

Check your installation php doesn't know about sqlite_open
Is your php version compiled with sqlite support?
Or is the sqlite extension installed and correctly set in your php.ini?
>
> What the problem(s) is, or are?

Siegfreed

2006-12-23, 4:36 am

Ric wrote:

My php version is 5.1.6, consequently is allegedly compiled with sqlite.

The extensions:

extension=php_pdo.dll
extension=php_pdo_sqlite.dll
extension=php_sqlite.dll

are located in the directory:

c:\program files\php\ext

php.ini is located in:

c:\windows

In ther php.ini file the following lines are present and not commented out :

extension_dir = C:\program files\php\ext

extension=php_pdo.dll
extension=php_pdo_sqlite.dll
extension=php_sqlite.dll

Laurent Seiler

2006-12-25, 6:58 pm

there are many functions in sqlite with two different methods you can write
them. i recomend you to check if there's another method to write that.

--

my homepage: www.m2k.dl.am

Ric

2006-12-25, 6:58 pm

Siegfreed schrieb:
> Ric wrote:
>
> My php version is 5.1.6, consequently is allegedly compiled with sqlite.

What does command:

php -m

tell you?

>
> The extensions:
>
> extension=php_pdo.dll
> extension=php_pdo_sqlite.dll
> extension=php_sqlite.dll
>
> are located in the directory:

Are those extensions for php 5.1.6 or at least 5.x?
>
> c:\program files\php\ext
>
> php.ini is located in:
>
> c:\windows
>
> In ther php.ini file the following lines are present and not commented
> out :
>
> extension_dir = C:\program files\php\ext
>
> extension=php_pdo.dll
> extension=php_pdo_sqlite.dll
> extension=php_sqlite.dll
>
>
>
>

Sponsored Links