Contact Us Forum Rules Search Archive
WebProWorld Part of WebProNews.com
Page One Link To Us Edit Profile Private Messages Archives FAQ RSS Feeds  
 

Go Back   WebProWorld > Webmaster, IT and Security Discussion > Database Discussion Forum
Subscribe to the Newsletter FREE!


Register FAQ Members List Calendar Arcade Chatbox Mark Forums Read

Database Discussion Forum This is the place to find help resolving those nagging questions you have about implementing and using all kinds of databases. Need help writing a query? Need an opinion on Oracle? Post here!

Reply
 
LinkBack Thread Tools Display Modes
  #1 (permalink)  
Old 01-09-2006, 01:49 PM
WebProWorld Pro
 

Join Date: Jul 2004
Location: Irvine, CA
Posts: 121
spenland RepRank 0
Default Use PHP Product Finder on a CD

Hi guys, I've gotten an interesting request from my supervisor. We have a dynamic product finder on our website that uses a MySQL database to display a list of products depending on what category you select. Is is possible to use this on a CD?

The reason for this is for distributors to be able to access information while they are away from their computers. I'm guessing that its not possible since the online application needs to connect to an database but this is not my area of expertise.

Any suggestions?
Reply With Quote
  #2 (permalink)  
Old 01-09-2006, 05:41 PM
WebProWorld New Member
 

Join Date: Sep 2004
Posts: 14
marbant RepRank 0
Default webserver from usb stick

http://www.uniformserver.com/index.php?us=plugins
is a WAMP webserver distro that also runs from usb sticks - though you'll have the problem to offline-sync recent database records to your clients
Reply With Quote
  #3 (permalink)  
Old 01-09-2006, 09:36 PM
DrTandem1's Avatar
WebProWorld 1,000+ Club
 

Join Date: Oct 2003
Location: Encinitas, CA
Posts: 1,908
DrTandem1 RepRank 2
Default Re: Use PHP Product Finder on a CD

Quote:
Originally Posted by spenland
Hi guys, I've gotten an interesting request from my supervisor. We have a dynamic product finder on our website that uses a MySQL database to display a list of products depending on what category you select. Is is possible to use this on a CD?

The reason for this is for distributors to be able to access information while they are away from their computers. I'm guessing that its not possible since the online application needs to connect to an database but this is not my area of expertise.

Any suggestions?
Well, you could make it similar to a web site by using HTML and simply supply a comprehensive index that has hyperlinks to the various products.
__________________
DrTandem's San Diego Web Page Design, drtandem.com
Reply With Quote
  #4 (permalink)  
Old 01-10-2006, 03:59 AM
southplatte's Avatar
WebProWorld Veteran
 

Join Date: Jul 2003
Location: Colorado
Posts: 381
southplatte RepRank 1
Default Re: Use PHP Product Finder on a CD

Quote:
Originally Posted by spenland
Hi guys, I've gotten an interesting request from my supervisor. We have a dynamic product finder on our website that uses a MySQL database to display a list of products depending on what category you select. Is is possible to use this on a CD?

The reason for this is for distributors to be able to access information while they are away from their computers. I'm guessing that its not possible since the online application needs to connect to an database but this is not my area of expertise.

Any suggestions?
Well, I guess if they are away from their computers, maybe a cd is not the best medium anyways??

I shall make an assumption: You meant when they are not connected to the Internet?

If so, there is no way to work this, unless you make mysql dumps from your db available so they can download it, and copy it to a folder on their hard drive.....then using marbant's suggestion would work, as you would have a local copy at that point (provided you updated the web app to pull from the local database - which means you then have a replicated web site, and a replicated database)....however the customer needs to keep it updated, or you then need to provide an update service for them to notify when the product list changes in any way shape, or form.

You could code the cd to connect to your web site to get the data, but I feel that would defeat the entire purpose.
Reply With Quote
  #5 (permalink)  
Old 01-10-2006, 06:42 AM
Faglork's Avatar
WebProWorld Veteran
 

Join Date: Feb 2005
Location: Forchheim, Germany
Posts: 947
Faglork RepRank 0
Default

Don't know if this would work:
- dump the mysql into csv
- import csv into MS ACCESS
- build an MS ACCESS application around it (you need the developer version for that AFAIK)

This way, you could even provide an update service based upon your mysql database.

faglork
Reply With Quote
  #6 (permalink)  
Old 01-10-2006, 11:22 AM
WebProWorld New Member
 

Join Date: Jul 2003
Location: Omaha, NE
Posts: 22
wetchman RepRank 0
Default Re: Use PHP Product Finder on a CD

We've created a few CD projects but because of the nature of server-based technologies like PHP and ASP, we chose Flash. You can package everything you need on one CD, and even test for an internet connection through Flash. Then, if you have an internet connection, you can communicate to outside databases and web sites. If you don't have the connection, then just disable certain features or give the user a message.
__________________
BW - Orajen Group, Inc.
Web Design and Development
http://www.orajen.com/
Reply With Quote
  #7 (permalink)  
Old 01-11-2006, 07:52 PM
WebProWorld Pro
 

Join Date: Jul 2004
Location: Irvine, CA
Posts: 121
spenland RepRank 0
Default

Thanks for the replies guys. I figured that it wasn't really possible to do this without altering the code or connecting it to an alternative data source. Since updating the products and making them available for download would be a nightmare I think that I may just have to scrap this idea and move on.

cheers!
Reply With Quote
Reply

  WebProWorld > Webmaster, IT and Security Discussion > Database Discussion Forum
Tags: , , ,



Thread Tools
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

vB code is On
Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Search Engine Optimization by vBSEO 3.2.0