How to access an SQLite database file stored on cd using php?

Question

I have a small mySQL database and a few simple php based webpages that query the database, generate html tables and present them in the browser. The database is no longer being updated. So, searching and viewing subsets of the data is all that is required.

Some users are interested in distributing the searchable database on a cd or usb memory stick. SQLite seems to offer the answer, but I don't understand what is needed to make this work. What will be required to make a web browser based "app" work from a memory stick in the absence of a server like xampp?

Eugen Rieck · Accepted Answer · 2011-12-22 17:46:45Z

1

XAMPP Lite from http://portableapps.com/apps/development/xampp

answered Dec 22, 2011 at 17:46

Eugen Rieck

65.6k10 gold badges75 silver badges97 bronze badges

Sign up to request clarification or add additional context in comments.

1 Comment

Andrew Staroscik Over a year ago

Thanks for the prompt reply. With this, I don't even need to convert to SQLite. It will work with my existing mySQL setup!

kizzx2 · Accepted Answer · 2011-12-22 17:48:30Z

0

What you want is called a "standalone server". This is very common in almost every other modern language except PHP, for some reason. Googling "standalone php server" reveals several options:

answered Dec 22, 2011 at 17:48

kizzx2

19.3k16 gold badges80 silver badges86 bronze badges

2 Comments

kizzx2 Over a year ago

Cool, the XAMPP Lite answer got +1 and this gets -1 for no particular reasons.

Andrew Staroscik Over a year ago

I don't have enough reputation points to vote on anything. Sorry. They all look good. I'd like to see Server2Go for Mac get out of beta.

Collectives™ on Stack Overflow

How to access an SQLite database file stored on cd using php?

2 Answers 2

1 Comment

2 Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

1 Comment

2 Comments

Your Answer

Sign up or log in

Post as a guest

Related