 |  |  |  |  |  |  |  |
PHP/MySQL Update table from offline version to online version
Please support our PHP advertiser: PostgreSQL or MySQL? Compare and contrast the two most popular open source databases
 |
I have one application in two version: the online version and the offline version(USB).
How can I update the online version after some change in the offline database?
How can I update the online version after some change in the offline database?
•
•
Join Date: Jun 2008
Posts: 849
Reputation: 
Solved Threads: 67
Practically a Posting Shark
Does the offline version have access to the internet?
“Be who you are and say what you feel because those who mind don't matter and those who matter don't mind.” - Dr. Seuss
-- The documentation is inevitable, you may get away with it for a little while but eventually you too will have to do the deed.
-- The documentation is inevitable, you may get away with it for a little while but eventually you too will have to do the deed.
•
•
Join Date: Dec 2007
Posts: 621
Reputation:
Solved Threads: 9
Practically a Master Poster
Best thing to do is to 'export' the required data from the database and then 'import' into the adjacent database.
You can use tools like phpMyAdmin, etc.
Hope that answers your question
You can use tools like phpMyAdmin, etc.
Hope that answers your question
Last edited by OmniX; Jul 9th, 2008 at 1:38 am.
•
•
•
•
Originally Posted by R0bb0b 
Does the offline version have access to the internet?
basically I need my application to be install on USB for those who do not have internet connection. They can work off-line by recording data in the off-line MySQL db through the off-line application.
As soon as they have internet connection they should have the possibilities to upload (Update the on-line MySQL db).
for that purpose I want to implement a small interface to help them interact between the off-line and the on-line database tables.
is there some body who can help me?
Thanks for your help
•
•
Join Date: Jun 2008
Posts: 849
Reputation:
Solved Threads: 67
Practically a Posting Shark
•
•
•
•
Originally Posted by blackbird29
Thanks to reply to my post.
basically I need my application to be install on USB for those who do not have internet connection. They can work off-line by recording data in the off-line MySQL db through the off-line application.
As soon as they have internet connection they should have the possibilities to upload (Update the on-line MySQL db).
for that purpose I want to implement a small interface to help them interact between the off-line and the on-line database tables.
is there some body who can help me?
Thanks for your help
http://forums.digitalpoint.com/showt...us#post8399126
every time the user opens the file. Upon "404 error" continue to work offline. Upon "successful response" open up online connection, proceed to compare and update online database, redirect the user to the online application.
“Be who you are and say what you feel because those who mind don't matter and those who matter don't mind.” - Dr. Seuss
-- The documentation is inevitable, you may get away with it for a little while but eventually you too will have to do the deed.
-- The documentation is inevitable, you may get away with it for a little while but eventually you too will have to do the deed.
•
•
Join Date: Dec 2007
Posts: 621
Reputation:
Solved Threads: 9
Practically a Master Poster
You need to make a simple php/mysql interface that lets you updates values for a database.
Use it for both:
Offline:
Setup apache, phpMyAdmin, etc on their computers, plus the usb in.
Transfer files to htdocs.
Make changes where possible, done.
Transfer Back to USB.
Online is Online (if your host has phpMyAdmin - most do).
Use it for both:
Offline:
Setup apache, phpMyAdmin, etc on their computers, plus the usb in.
Transfer files to htdocs.
Make changes where possible, done.
Transfer Back to USB.
Online is Online (if your host has phpMyAdmin - most do).
Last edited by OmniX; Jul 11th, 2008 at 11:40 pm.
•
•
•
•
You need to make a simple php/mysql interface that lets you updates values for a database.
But his question is how to ? Last edited by nav33n; Jul 12th, 2008 at 2:27 am.
Ignorance is definitely not bliss!
*PM asking for help will be ignored*
*PM asking for help will be ignored*
•
•
•
•
I would use something like this:
http://forums.digitalpoint.com/showt...us#post8399126
every time the user opens the file. Upon "404 error" continue to work offline. Upon "successful response" open up online connection, proceed to compare and update online database, redirect the user to the online application.
Last edited by nav33n; Jul 12th, 2008 at 2:38 am.
Ignorance is definitely not bliss!
*PM asking for help will be ignored*
*PM asking for help will be ignored*
•
•
Join Date: Jun 2008
Posts: 849
Reputation:
Solved Threads: 67
Practically a Posting Shark
Well Curl would work for the same purpose
http://us.php.net/manual/en/book.curl.php
http://us.php.net/manual/en/book.curl.php
“Be who you are and say what you feel because those who mind don't matter and those who matter don't mind.” - Dr. Seuss
-- The documentation is inevitable, you may get away with it for a little while but eventually you too will have to do the deed.
-- The documentation is inevitable, you may get away with it for a little while but eventually you too will have to do the deed.
|
Similar Threads
- Help me with my myspace clone (PHP)
- I NEED HELP PLEASE:Warning: mysql_num_rows(): (PHP)
- I NEED HELP PLEASE:Warning: mysql_num_rows(): (MySQL)
Other Threads in the PHP Forum
- Previous Thread: UPDATING TEXT AREA using PHP !!
- Next Thread: Change status code
| Thread Tools | Search this Thread |
Latest PHP Posts
- Today's Posts
- Unanswered Threads
Related Forum Features
Tag cloud for PHP
.htaccess access ajax apache api array beginner binary broken cakephp checkbox class cms code cron curl database date directory display download dynamic echo email encode error fcc file files folder form forms function functions google howtowriteathesis href htaccess html image images include insert integration ip java javascript joomla ldap limit link login loop mail menu mlm mod_rewrite multiple multipletables mysql oop open parse paypal pdf php problem provider query radio random recursion regex remote script search server sessions sms soap source space sql strip_tags structure syntax system table template tutorial update upload url validation validator variable video web xml youtube
