HI,
Thanks for all the suggestions. I guess I should have given a more detail
description. My employer have just provided me with some background
information of the setup:
Our data come in mostly automatically by FTP on to our Vax, then eventually
moved on to our R30 (RS6000/AIX) and then H80 (RS6000/AIX). The databases
are running on the 2 RS6000's. Although we have numerous scripts processing
the data along the route, my employer would prefer to have this system
checking independently the situation/condition of the upload. Besides, if
the original data processing script crashes before any error message can be
sent, we might still don't know if there is a problem.
There are files on various machines to look for that indicate the status of
the update. So this program may go to look for these signs in order to
collect the update status. For making the information available to our
staff, the most convenient way for them is via a web page. Although the
information is not as confidential as such, it would be nice to be able to
password protect the contents. There is also a need for selected staff to
manually update certain fields of a record (publication), e.g. Reason for
Delay. So the web page should be able to capture manual text input from
authorized staff and updated to the status information.
Anyways thanks a lot for all your suggestions. All your kind suggestions
would help me to have a head start on this project.
Kelvin
From: Larry Brown [EMAIL PROTECTED]
To: PHP List [EMAIL PROTECTED]
Subject: RE: [PHP] Re: Need a suggestion on developing a php-related system
Date: Wed, 8 Jan 2003 02:52:11 -0500
From the remark about the arrival and departure time scenario, it sounds
like you want to show whether the updates occurred and when they
began/ended. If this is accurate, you should find out whether the scripts
used to populate those databases record that information for the database
it
is updating. If so you need to create a script that opens each database
and
queries that data. If they do not record these things you could either
modify them to do so or you could have them also connect to a central db
that you create to store this collection of data to show beginning and
ending of the scripts. I think either way you should store this in your
own
db. Is this along the lines of what you had in mind?
Larry S. Brown
Dimension Networks, Inc.
(727) 723-8388
On 01/08/2003 03:40 AM, Kelvin Poon wrote:
HI, I am new to PHP and I am just wondering if anyone could give me some
help.
I am currently working for infomart.ca, it is basically a company that
sells articles (news/business). MY employer require me to develop a
system using Perl and PHP, and the assignment is as follow:
To develop a system that collects, stores, processes and disseminates
internally the updating status of our databases.
We currently have over 200 databases from various daily newspapers,
magazines, TV transcripts and other periodicals. Most of them are
updated every weekday between 4a.m. and 7a.m.. Others are updated on a
weekly or monthly basis. THe update schedule Tv. the actual status need
to be captured and made available to internal staff. This is similar to
the flight departure/arrival information in an airport.
--
PHP General Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php
_
MSN 8: advanced junk mail protection and 2 months FREE*.
http://join.msn.com/?page=features/junkmail
--
PHP General Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php