Re: JSON1 extension for SQLite

[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]

 



I have found the archive (x86 and PHP 7.0) and the DLL in it. But when I try to load the extension, I get the error message "not authorized". Seems I'm not allowed to load extensions. And there doesn't seem to be a way to enable it.

https://www.sqlite.org/c3ref/enable_load_extension.html

https://stackoverflow.com/questions/8756146/how-to-load-sqlite-extension-in-pdo

Maybe I need to replace PDO with the dedicated SQLite 3 client functions in PHP.

Yves



________________________________________
Von: Jan Ehrhardt <phpdev@xxxxxxxxxxx>
Gesendet: So, 2019-02-17 14:09 +0100
Yves Goergen in php.general (Fri, 15 Feb 2019 23:41:29 +0100):
I've already asked in their support forum and they say that XAMPP only
includes PHP's official Windows builds. I've looked around and found two
SQLite-related files: php_pdo_sqlite.dll and php_sqlite3.dll, both are
around 840 kB. There is no DLL named like json1.

Intriguing issue. Could you try the json1.dll inside
https://phpdev.toolsforresearch.com/php-7.3.2-nts-Win32-VC15-x64.zip

See https://www.apachelounge.com/viewtopic.php?t=6359 for info about
these builds.

Note: sqlite3.extension_dir in your php.ini should contain the full path
to the directory with the json1.dll.

I tested loading of the extension with the following php.ini:


sqlite3.extension_dir = "N:\php-sdk\php73dev\x64\Release\php-7.3.2"
extension_dir = "ext"
extension=sqlite3

The json1.dll should also work with your XAMPP, AFAIK.




[Index of Archives]     [PHP Home]     [Apache Users]     [PHP on Windows]     [Kernel Newbies]     [PHP Install]     [PHP Classes]     [Pear]     [Postgresql]     [Postgresql PHP]     [PHP on Windows]     [PHP Database Programming]     [PHP SOAP]

  Powered by Linux