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
