Hi Pag,
In my experience, I usually have two database systems.
I have the Live DB which is currently the one used
by the website which is the one on the hosting server,
and I also have a local DB on our local server just here.
What I do is I create the back-end applications for the
administration of records, like add, edit, and delete.
The idea is that for a certain time of day or perhaps
weekly, it depends on your need... these two databases
should be synchronized... meaning their records be
reconciled... Most often in my case it's a one-way
direction.
Records from your local database will be sent to the
live server either for addition or just updating some
fields... As a hint: you can just add a field if
you'll either ADD or just EDIT a record in the live
database... or you can issue a SELECT query and then
if it exists.. you can either interpret it as a
condition for ADD, else, EDIT.. It depends on your
system.
On doing the syncs, you can create just a PHP script
to send data (i.e. CSV) to the server.. you can
use fopen("http://www";) or perhaps just use the
POST and GET Methods. The recieving script on your
live server will parse and do the necessary actions
for your data.
Furthermore, you could add your PHP script to your
CRON (*nix systems) if you want to create a schedule
for your sync times. (say 12:00 Midnight when no
one is around in your office) :) Or you can do
another workaround in your OS. Otherwise, just
run the script manually. ;) Watch out for expiration
limits too... as you may have large data to send. :)
Hope this helps,
Miches
-----Original Message-----
From: Pag [mailto:[EMAIL PROTECTED]
Sent: Monday, March 10, 2003 2:51 PM
To: [EMAIL PROTECTED]
Subject: [PHP] PHP Online Store
Hi,
I have to write a PHP/MySQL online store with product catalogs, prices,
descriptions, and ordering (no payment) etc, but i have a big doubt when it
comes to updating.
How is it usually done? I mean, i never did a project like this, with a
big amount of products to update. Whats the easiest way of updating the
prices like say, every week? The suppliers send a list of the new prices to
the store, and the store has to update the prices online manually, one by one?
Also i thought of saving the excel file in csv format and uploading to the
site, where some sort of parser would collect the new info from it. The
problem with that approach would be if the supplier changes a cel on some
product name, then everything would be ruined.
How is it usually done?
Big thanks, i am completely blind in this.
Pag
--
PHP General Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php
--
PHP General Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php
