Recurse thru dir into DB

From: Date: Thu, 01 Jan 1970 00:00:00 +0000
Subject: Recurse thru dir into DB
Groups: php.db 
Request: Send a blank email to php-db+get-13712@lists.php.net to get a copy of this message
Hi there folks, this problem is sincerely 'doing my head in'! I want to know if there is a simpler method of achieving my aims set out below: Script aim: * To alert users subscribed to category's when new files are added to that category. * A category has the same name as each directory in my projects' filesystem. Proposed method (this is what I need a hand with) * Subscribers emails are stored in table 'A' under their associated category. (Each column name reflects a category name) * Subscribers are auto-emailed whenever a new file is added to their category * A script is executed by cron that iterates through all categories at time 'X, once every morning. * The script gets current file numbers per directory and places this data into table 'B'. * Another script, also executed by cron every evening at time 'Y' (after the script above), compares the value of files per directory from table 'B' to the *now* current number of files in each directory. * It inserts these values into a another table 'C' and compares the totals in 'B' and 'C'. * If the totals in 'C' are greater than those in 'B' then detect which category's have had files added and select emails from table 'A' where their subscribed categories = updated categories. * mail() these addresses with the message "Directory X has been updated" Is this too contrived or is there an easier method? I already have various directory recursion scripts I got from phpbuilder, but the exact method of performing the above kinda eludes me. Any (constructive) comments more than welcome. Kind regards: Russ #-------------------------------------------------------# "Believe nothing - consider everything" Russ Michell Anglia Polytechnic University Webteam Room 1C 'The Eastings' East Road, Cambridge e: r.j.michell@apu.ac.uk w: www.apu.ac.uk/webteam www.theruss.com #-------------------------------------------------------#

« previous php.db (#13712) next »