"LOAD DATA" MYSQL

[meghatronic]

LOAD DATA loads, as the name suggests, data from a file on the server... however.... how can I get this to 'load' the data from a text box and/or select a file to upload, then load...?

It sounds simple but I'm stumped... again!

 

[robmiller]

Use a sever-side language to create a temporary file from either the textarea input or the uploaded file, then run the query also with said language.

 

[meghatronic]

Use a sever-side language to create a temporary file from either the textarea input or the uploaded file, then run the query also with said language.

Okay, I can upload the text file as a temporary file and then get use this.. however I have no idea how to get the text from the text area... unless it is just as simple as writing the contents of the text area to a temp. file...? Then reading it as before. In which case I'm stupidly blind.

(php for what it is worth)