For reasons discussed on the mailing list recently (see the threads on PHP 5.1 upgrade notes), ext/sqlite depends on the PDO extension, because it provides a sqlite2 PDO driver.

You need to ensure that the PDO extension is loaded before the sqlite extension.

I had the same problem. I had extension=php_pdo.dll (plus the drivers for MySQL, Postgres, and SQLite) after the extensions list in php.ini-dist. Moving those lines up above, so that they're before extension=php_sqlite.dll, fixed the problem. Definitely something that needs to be added to the installation docs for SQLite. It also might be a good idea to add the PDO extensions to php.ini-dist. Since the PDO extensions would be before the SQLite extension in alphabetical order anyway, most people would never notice the dependency.

No feedback was provided for this bug for over a week, so it is
being suspended automatically. If you are able to provide the
information that was originally requested, please do so and change
the status of the bug back to "Open".

I am facing the same problem but in my case it says,
php_sqlite.dll could not be loaded... specified PROCEDURE could not be found.

I have also tried to load php_sqlite.dll after loading all the pdo extensions, i also tried loaded the php_pdo_sqlite.dll and without it too.

Any help is appreciated.

Gaurav Misra

how to solve this problem?

Fatal error: Call to undefined function sqlite_open() in c:\webs\test\testSqlite.php5 on line 13

what i did, In php.ini you must uncomment the line: extension=php_sqlite.dll and above it, add the line: extension=php_pdo.dll Then, restart apache and reload the page

But till now same masses Fatal error: Call to undefined function sqlite_open() in c:\webs\test\testSqlite.php5 on line 13 can you help me plc.

I am seeing the following error when I add the following lines to my php.ini file:
extension=php_pdo.dll
extension=php_pdo_mysql.dll
extension=php_pdo_sqlite.dll
extension=php_sqlite.dll

I then restarted Apache and invoked PHP from the command line:

$ php
PHP Warning:  PHP Startup: Unable to load dynamic library 'C:\Program Files\PHP\ext\php_sqlite.dll' - The specified module could not be found.
 in Unknown on line 0


My PHP extensions directory contains all these DLLs, apparently php_sqlite.dll is the only one that does not load. Why?

Actually i have the same problem. I've have win xp sp2,php 5.2.2 and apache 2.2.4. In my php.ini i've uncommented:
extension php_pdo.dll
extension php_pdo_mysql.dll
extension php_pdo_sqlite.dll
extension php_pdo_sqlite_external.dll
extension=php_sqlite.dll
I checked ext dir, it contains all of that. After restarting apache, and give a request for example http://localhost/index.php i get a Warning:
PHP Startup: Unable to load dynamic library 'C:/php/ext/php_sqlite.dll'- The specified module could not be found.

Well, after copying php_pdo.dll and php_sqlite.dll to c:/php i have another warning coming: Cannot load module 'SQLite' because required module 'pdo' is not loaded

Well, when i upgraded from 5.1.6 i've saved my php.ini, now i have replaced it with php.ini.recommended from 5.2.2 dist, uncommented modules and everything goes ok.

<?php

//create table
if(file_exists("test.db")) {
	$weNeedToCreateTheDatabase = false;
} else {
	$weNeedToCreateTheDatabase = true;
	
}

//create or open database
$db = sqlite_open("test.db") or die("failed to open/create the database");

//create table
if($weNeedToCreateTheDatabase) {
	sqlite_query($db, "CREATE TABLE Members(FirstName,LastName)");
}

//add info
sqlite_query($db,"INSERT INTO Members VALUES ('Jim', 'Rockerton')");

//get info
$dt = sqlite_query($db, "SELECT * FROM Members");
while ($row = sqlite_fetch_array($dt)) {
echo "row: $row[FirstName] $row[LastName]<br/>";
}

//close database
sqlite_close($db);

?>

Hello sir,

i was unable to connect sqlite with php.


Error: Fatal error: Call to undefined function sqlite_open() in C:\webs\test\testsqlite.php5 on line 12

thank you,


Saravana

Sorry, but your problem does not imply a bug in PHP itself.  For a
list of more appropriate places to ask for help using PHP, please
visit http://www.php.net/support.php as this bug system is not the
appropriate forum for asking support questions.  Due to the volume
of reports we can not explain in detail here why your report is not
a bug.  The support channels will be able to provide an explanation
for you.

Thank you for your interest in PHP.

Please ask support about enabling extensions in the php-install or php-windows mailing list.