•
•
•
•
What is DaniWeb IT Discussion Community?
You're currently browsing the PHP section within the Web Development category of DaniWeb, a massive community of 401,487 software developers, web developers, Internet marketers, and tech gurus who are all enthusiastic about making contacts, networking, and learning from each other. In fact, there are 3,227 IT professionals currently interacting right now! Registration is free, only takes a minute and lets you enjoy all of the interactive features of the site.
Please support our PHP advertiser: Lunarpages PHP Web Hosting
Views: 534 | Replies: 8
 |
•
•
Join Date: Jul 2008
Posts: 2
Reputation: 
Rep Power: 0
Solved Threads: 0
Newbie Poster
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
Location: Phoenix, AZ
Posts: 599
Reputation:
Rep Power: 2
Solved Threads: 53
Posting Pro
You will probably want to do a cron to a PHP Curl script that will pull maybe an xml or some type of delimited file from the live server representing the database. The what ever data is not live, send it back via Curl.
“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
•
•
Join Date: Dec 2007
Posts: 352
Reputation:
Rep Power: 1
Solved Threads: 1
Posting Whiz
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 12:38 am.
•
•
Join Date: Jul 2008
Posts: 2
Reputation:
Rep Power: 0
Solved Threads: 0
Newbie Poster
•
•
•
•
Originally Posted by R0bb0b 
Does the offline version have access to the internet?
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
•
•
Join Date: Jun 2008
Location: Phoenix, AZ
Posts: 599
Reputation:
Rep Power: 2
Solved Threads: 53
Posting Pro
•
•
•
•
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
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.
“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
•
•
Join Date: Dec 2007
Posts: 352
Reputation:
Rep Power: 1
Solved Threads: 1
Posting Whiz
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 10:40 pm.
•
•
Join Date: Nov 2007
Location: Bangalore, India
Posts: 3,098
Reputation:
Rep Power: 8
Solved Threads: 239
•
•
•
•
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 1:27 am.
Programming today is a race between software engineers striving to build bigger and better idiot-proof programs, and the Universe trying to produce bigger and better idiots. So far, the Universe is winning.
*PM asking for help will be ignored*
*PM asking for help will be ignored*
•
•
Join Date: Nov 2007
Location: Bangalore, India
Posts: 3,098
Reputation:
Rep Power: 8
Solved Threads: 239
•
•
•
•
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 1:38 am.
Programming today is a race between software engineers striving to build bigger and better idiot-proof programs, and the Universe trying to produce bigger and better idiots. So far, the Universe is winning.
*PM asking for help will be ignored*
*PM asking for help will be ignored*
•
•
Join Date: Jun 2008
Location: Phoenix, AZ
Posts: 599
Reputation:
Rep Power: 2
Solved Threads: 53
Posting Pro
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
|
•
•
•
•
•
•
•
•
DaniWeb PHP Marketplace
•
•
•
•
Currently Active Users Viewing This Thread: 1 (0 members and 1 guests)
Linear Mode
•
•
•
•
bbc blog broadcast competition daniweb distance education economy education experiment funds gentoo india intel internet investments linux media microsoft mysql news online online education online shopping partition pc php portfolio practices programming publishing retail retail stocks rss searchmonkey security skype software spam stocks strayer tips tutorials video voip web windows update xbox 360 xbox live yahoo youtube
- 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
