XAMPP 7.3.1 PORTABLE how to enable sqlite3

Problems with the Windows version of XAMPP, questions, comments, and anything related.

XAMPP 7.3.1 PORTABLE how to enable sqlite3

Postby Corsari » 23. February 2019 15:40

Hello to all the community

I have unzipped the xampp in subject

Started it

From XAMPP control panel I launch the shell, then as written into the how to

Code: Select all
cd htdocs


and run this

Code: Select all
sqlite3 test.db


I get this error

"sqlite3 is not recognized as internal or external command"

I went to check from phpinfo and I note this

sqlite3.extension_dir no value no value

though in php.ini I have enabled
Code: Select all
extension=pdo_sqlite
extension=sqlite3


and yes I have nothing for this
Code: Select all
[sqlite3]
;sqlite3.extension_dir =


is this the problem?

what it shoud be setup for that sqlite3.extension_dir ?

And a little complain: why you say that xampp is sqlite enabled , also confirmed by the ../docs/use-sqlite.html how-to page? And instead we have to modify all of above?

Thank you for any help

Robert
Corsari
 
Posts: 15
Joined: 13. January 2015 07:24
Operating System: Windows Vista

Re: XAMPP 7.3.1 PORTABLE how to enable sqlite3

Postby Nobbie » 23. February 2019 20:43

Corsari wrote:is this the problem?


No. The problem is your really horrible lack of knowledge. If you enter "sqlite" as a command in a terminal, this does not have anything to do with PHP.

You really should go for some tutorials about Apache and PHP (actually there are tons of them out in the WWW), as you definately have no idea how things are working together. Sorry for these very straight words, but its really a pain.
Nobbie
 
Posts: 13170
Joined: 09. March 2008 13:04

Re: XAMPP 7.3.1 PORTABLE how to enable sqlite3

Postby gsmith » 23. February 2019 21:30

sqlite3 test.db

To use that command at the command prompt you need the sqlite3.exe file which php does not include. The sqlite3 extension only has the sqlite3 library (think a dll file) compiled into it.

You can get the separate binaries (.exe & .dll) at https://www.apachehaus.net/sqlite3/
gsmith
 
Posts: 278
Joined: 29. November 2013 18:04
Location: San Diego
XAMPP version: 0.0.0
Operating System: Win 10/2012R VS 14,15,16

Re: XAMPP 7.3.1 PORTABLE how to enable sqlite3

Postby Corsari » 24. February 2019 07:43

thank you for the confirmation, reading on the sqlite site I got the confirmation an .exe was missing and a quick file search in the whole xampp directory confirmed the absence of that exe

somebody should fix the documentation distributed with xampp

read

FAQ: Use SQLite with PHP (the FAQ title though is not the best)
http://localhost/dashboard/docs/use-sqlite.html

it is the page you can click on the HOW-TO about sqlite,
and I suppose the issue will be the same either in the installed xampp (as in subject I'm using the portable ) , at first sight I had the doubt it was something related with portable

the fixed reply could be
Since XAMPP is delivered with SQLite support for php enabled by default, you can read about using SQLite with PHP on the PHP website:
https://secure.php.net/manual/en/book.sqlite.php

about using SQLite3, you need to manually edit the php.ini file to enable the proper SQLite3 extension and next head to SQLite3 with PHP on the PHP website:
https://secure.php.net/manual/en/book.sqlite3.php and
Corsari
 
Posts: 15
Joined: 13. January 2015 07:24
Operating System: Windows Vista

[SOLVED] XAMPP 7.3.1 PORTABLE how to enable sqlite3

Postby Corsari » 18. August 2019 14:29

Hello I come back on this topic for the sake of publishing a solution for those that have the problem I faced long time ago (see first post date)

head your browser to
https://www.sqlite.org/download.html

scroll page and goto section
Precompiled Binaries for Windows

download these two .zip archives
- 64-bit DLL (x64) for SQLite version x.xx.xx
- A bundle of command-line tools for managing SQLite database files

create your own sqlite3 directoy, e.g.

I have created a subdir named
Code: Select all
sqlite3

inside my main
Code: Select all
\xampp

directory

unzip both the .zip archives in that directory

well, now you can google for
edit path variable windows 10

and add a new path, in my case it is
Code: Select all
d:\xampp\sqlite3


and there you go, now you can run the sqlite3 commands from windows command prompt

exactly as described in the DEFECTED xampp portable FAQ http://localhost/dashboard/docs/use-sqlite.html
Corsari
 
Posts: 15
Joined: 13. January 2015 07:24
Operating System: Windows Vista


Return to XAMPP for Windows

Who is online

Users browsing this forum: No registered users and 148 guests