Running PHP and MySQL offline

Questions about the MySQL, PostgreSQL, and most other databases, as well as using it with PHP can be asked here.

Moderator: General Moderators

Post Reply
User avatar
aceconcepts
DevNet Resident
Posts: 1424
Joined: Mon Feb 06, 2006 11:26 am
Location: London

Running PHP and MySQL offline

Post by aceconcepts »

Hi,

I have a web site set up that uses MySQL databases and PHP and is only usable online [obviously].

What i would like to be able to do is to use the site exactly as it is used online but offline.

i.e. the site is used to record user details and payments. What if a user cannot connect to the Internet? I would like to be able to offer a backup system offline that will allow the use of a database that stores data in tables like the tables in MS Access not in a pompt environment.

I hope this is clear and understandable.

Thanks,

Nick
User avatar
feyd
Neighborhood Spidermoddy
Posts: 31559
Joined: Mon Mar 29, 2004 3:24 pm
Location: Bothell, Washington, USA

Post by feyd »

The only way to perform such offline actions is through a local server or datastore that can, once the machine is able to connect again can update the server.
User avatar
aceconcepts
DevNet Resident
Posts: 1424
Joined: Mon Feb 06, 2006 11:26 am
Location: London

Post by aceconcepts »

Hi,

Thanks for the reply.

I thought that might be the case. The only problem with that is that each user is at a different location, thus the online system.

Is there any way to use a virtual server? like when you use Apache to test PHP scripts against offline MySQL before I uploaded to a live server.

Nick
User avatar
feyd
Neighborhood Spidermoddy
Posts: 31559
Joined: Mon Mar 29, 2004 3:24 pm
Location: Bothell, Washington, USA

Post by feyd »

aceconcepts wrote:Is there any way to use a virtual server? like when you use Apache to test PHP scripts against offline MySQL before I uploaded to a live server.
That is what I was referring to.
afbase
Forum Contributor
Posts: 113
Joined: Tue Aug 15, 2006 1:29 pm
Location: SoCAL!!!!

Post by afbase »

If you are meaning that users who do not have internet, but have a telephone and what to use your service? Ummm there is a open source app called Asterisk, you would have to configure that to talk with your database. http://www.asterisk.org/

I'm not sure if that helps or answers your question.
User avatar
aceconcepts
DevNet Resident
Posts: 1424
Joined: Mon Feb 06, 2006 11:26 am
Location: London

Post by aceconcepts »

Thanks a lot to both of you for your posts.

One more thing, if I use a virtual server (like feyd suggested) is there anyway I can use tables (like MS Access tables) to store data as opposed to MySQL prompt. Only because it would make the data more accessible for exporting etc...

Thanks again,

Nick
User avatar
feyd
Neighborhood Spidermoddy
Posts: 31559
Joined: Mon Mar 29, 2004 3:24 pm
Location: Bothell, Washington, USA

Post by feyd »

You can use MySQL if you wish, but that all depends on how you build the virtual environment.
User avatar
aceconcepts
DevNet Resident
Posts: 1424
Joined: Mon Feb 06, 2006 11:26 am
Location: London

Post by aceconcepts »

My main aim is to use a browser as the front-end so that users do not get confused by design change. I could use Access to run the entire offline database but the look and feel is sooooo different and ugly.

Is there anyway of using Access base tables to store data and use PHP to execute scripts via a web browser (completely offline)?

Thanks,

Nick
User avatar
feyd
Neighborhood Spidermoddy
Posts: 31559
Joined: Mon Mar 29, 2004 3:24 pm
Location: Bothell, Washington, USA

Post by feyd »

Yes.

Be aware that they will need to have PHP (and some compatible web server) installed locally to do that.
User avatar
aceconcepts
DevNet Resident
Posts: 1424
Joined: Mon Feb 06, 2006 11:26 am
Location: London

Post by aceconcepts »

Excellent.

I already have Apache setup as a virtual server which i use to test web stuff.

How would i go about telling Apache and PHP to communicate with Access?

Thanks.
User avatar
feyd
Neighborhood Spidermoddy
Posts: 31559
Joined: Mon Mar 29, 2004 3:24 pm
Location: Bothell, Washington, USA

Post by feyd »

Post Reply