Apache Friends Support Forum

I know XAMPP have SQLite but I d0n't see how to execute phpSQLiteAdmin. Who can help me?

Hi CarlosV,

Because phpSQLiteAdmin is not part of the XAMPP project, we can't provide help for this script here.
Please try to get help for this script on its own project page.

best wishes,
Altrea

But XAMPP, in Components, says
"XAMPP components
XAMPP combines many different sofware packages into one package. Here's an overview of all packages.

Many thanks to the developers of these programs.

Apache HTTPD, MySQL, PHP, Perl, FileZilla FTP Server, phpMyAdmin, OpenSSL, Freetype, Webalizer, mod_perl, eAccelerator, mcrypt, SQLite, Mercury Mail Transport System, fake sendmail for windows, FPDF Class

In the directory \xampp\licenses you will find all licenses files of these programs. "

Then, how do I manage SQLite from XAMPPP?

Thanks Altrea.

CarlosV wrote:But XAMPP, in Components, says
"XAMPP components
XAMPP combines many different sofware packages into one package. Here's an overview of all packages.

Many thanks to the developers of these programs.

Apache HTTPD, MySQL, PHP, Perl, FileZilla FTP Server, phpMyAdmin, OpenSSL, Freetype, Webalizer, mod_perl, eAccelerator, mcrypt, SQLite, Mercury Mail Transport System, fake sendmail for windows, FPDF Class

Yes. Do you see any "phpSQLiteAdmin" in the list?

CarlosV wrote:Then, how do I manage SQLite from XAMPPP?

AS can be written on the SQLite Homepage:

Comes with a standalone command-line interface (CLI) client that can be used to administer SQLite databases.

best wishes,
Altrea

Was phpSQLiteAdmin 0.2 in XAMPP 1.6.2 / 1.6.3?

it cost max. 10 minutes of your time to download the versions and check it out on your own.
I know many XAMPP versions between 1.4.13 and 1.8.0beta, but don't know exactly all components of them.
I don't use SQLite.

I can help you to an extent but configuring/using it or debugging any PHP errors you get while using it, you are on your own.

If you wanted to set it up similar to phpMyAdmin, you could do the following:
1. Extract it to your XAMPP root (it would end up being /xampp/phpsqliteadmin03a1)
2. Open up your '/xampp/apache/conf/extra/httpd-xampp.conf'
3. Go under the '<IfModule alias_module>' block
4. Add

Code: Select all

Alias /phpsqliteadmin "/xampp/phpsqliteadmin03a1/"
    <Directory "/xampp/phpsqliteadmin03a1">
        AllowOverride AuthConfig
    </Directory>

5. Find this block of code at the bottom of that file

Code: Select all

<LocationMatch "^/(?i:(?:xampp|licenses|phpmyadmin|webalizer|server-status|server-info))">
    Order deny,allow
    Deny from all
    Allow from ::1 127.0.0.0/8
    ErrorDocument 403 /error/HTTP_XAMPP_FORBIDDEN.html.var
</LocationMatch>

and modify it so be

Code: Select all

<LocationMatch "^/(?i:(?:xampp|licenses|phpmyadmin|webalizer|server-status|server-info|phpsqliteadmin))">
    Order deny,allow
    Deny from all
    Allow from ::1 127.0.0.0/8
    ErrorDocument 403 /error/HTTP_XAMPP_FORBIDDEN.html.var
</LocationMatch>

6. Save and restart Apache
7. You should be able to access it via http://localhost/phpsqliteadmin

Thank you very much hackattack142, you're very kind.

Altrea wrote:it cost max. 10 minutes of your time to download the versions and check it out on your own.
I know many XAMPP versions between 1.4.13 and 1.8.0beta, but don't know exactly all components of them.
I don't use SQLite.

You can see a example of SQLite in option Phone Book of XAMPP Menu.
Thanks.

Hi CarlosV,

Thank you very much for your tips.
I already know what SQLite is and how to use it.
I don't use SQLite because my databases are quite bigger so that MySQL or Oracle is in most cases the better solution.

best wishes,
Altrea

Woah Altrea, I don't know what your problem is, but get help. If you're not interested in a topic, then don't contribute, but there's no need to be rude.