FileMaker, PHP, and other animals

[cedrik]

If this has been covered already could someone point me in the right direction, I can't seem to find anything that is relevant.

I have a FM DB running locally and a PHP/MySQL/Apache webserver (not local). The FM DB is, in effect, the control for the web. You can ad/edit and delete articles etc from the DB, then, every day at midnight, the webserver connects to the FM DB and updates any necessary articles. This stage works a treat (uses FX.php, a top class for FM and PHP interaction)

The next step is what is causing me grief. I need to be able to upload files (pics, pdfs, etc) from the local machine to remote.

What is the easiest/best/etc. way to first of all collect the files and make them ready in a local upload dir and then upload them.

The second part is less difficult as I will most likely add that end-of-day task to a cron job to FTP normally. It is mainly the FM side of it that is causing problems...

Any ideas greatly appreciated.

Ced

[Garry Claridge]

A couple of threads exist about file uploads and PHP/CDML.

All the best.

Garry

[cedrik]

Don't suppose you'd care to be a little more specific?

I'm still browsing though.

[Garry Claridge]

One was actually at the bottom of this page until this morning, now it is at the top of page two. Also, a search on PHP will find them.

Here is a link:

File Upload & PHP

Good Luck.

Garry

[cedrik]

Cheers for that... I've actually seen that post, just what I need I thought, that was easy... but no, it never is... that's the opposite of what I want to do... The local users have FM running over a LAN, they need to be able to add files (any type) and pics to entries on the DB, these files then need to be transfered to the local server where I can FTP them automatically (I'm not using FM to do this transfer, PHP can sort that, or a nice script)

basically I need to work out how FM can take a file, enter the name of it into a field and then transfer the file to a remote location over a network.

BTW... I don't particularly want to use a comercial plugin as I will then have the added pleasure of trying to explain to the (l)users around how to install the ******* thing.

TIA

[Garry Claridge]

You should be able to use Applescript for all of that.

All the best.

Garry