Hi - I have developed a site that pulls data into MySQL and using some queries and echo's, presents a soft copy of a purchase order. At present, the user has to ftp the files(s) from a UNIX server to PC running Apache, then load the file (just enters the order number) into the MySQL database on PC.
It all works very well and looks good. To try and further streamline it, is there a way to do the ftp'ing with PHP - the file name will be entered by the user. I have looked at 'kermit' for unix, but not quite what I need...
Anu help much appreciated. (I guess there are a couple of hundred orders a week - typical order number would be 'PO51315'. At present I ftp two files. 51315D and 51315H, the D file loads into data_table and H file to header_table)
Hope I have not confused everyone!