I've got a dedicated server running Windows 2003, IIS, MySQL and PHP.
I'm working on a web site which needs to pick data up on a semi-regular
basis from a CSV file which will exist in a directory accessible to this
server. The data will be put there by another server.
I need to pick up this data and insert it into a MySQL table; I have three
options in theory - do it on a strict schedule, do it on request by an admin
user (the easy option), or have it happen automatically if a file drops into
that directory.
Can PHP do this, or do I need to look at something else to do this for me? I
can install/setup anything I like on this server, within reason.
TIA.
Pete.