Re: JSON1 extension for SQLite

From: Date: Tue, 19 Feb 2019 22:54:35 +0000
Subject: Re: JSON1 extension for SQLite
References: 1 2  Groups: php.general 
Request: Send a blank email to php-general+get-326709@lists.php.net to get a copy of this message
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@ehrhardt.nl> 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: [PHP] 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.

« previous php.general (#326709) next »