Page 1 of 1
Running PHP and MySQL offline
Posted: Sun Jan 14, 2007 2:32 pm
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
Posted: Sun Jan 14, 2007 3:25 pm
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.
Posted: Sun Jan 14, 2007 4:02 pm
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
Posted: Sun Jan 14, 2007 4:08 pm
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.
Posted: Sun Jan 14, 2007 4:34 pm
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.
Posted: Sun Jan 14, 2007 7:28 pm
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
Posted: Sun Jan 14, 2007 7:31 pm
by feyd
You can use MySQL if you wish, but that all depends on how you build the virtual environment.
Posted: Mon Jan 15, 2007 6:39 am
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
Posted: Mon Jan 15, 2007 9:27 am
by feyd
Yes.
Be aware that they will need to have PHP (and some compatible web server) installed locally to do that.
Posted: Mon Jan 15, 2007 10:07 am
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.
Posted: Mon Jan 15, 2007 10:34 am
by feyd