upload / insert

[okiesplace]

A little help please.
I sure this is easy for someone that understand, but not for a numbnuts like me HaHa

During the course of a day i receive several files uploaded in sql format.

The script used to receive the files is...

<?php
$uploaddir = "filelist/";
$file = $uploaddir . $FILES['uploadfile']['name'];
move_uploaded_file($FILES['uploadfile']['tmp_name'], $file)
?>

At the moment i realise there is no file checking done, but that is not my problem.

The files arrive in this format...

DELETE FROM webuserdata WHERE NickName = "OkiesPlace";
Insert into webuserdata (NickName, FileStatus, Correspondent, Period, FileName, Series, Files) values ('OkiesPlace','Sent','Enforcer','May 2008','CB30001-05 - Spears Britney - From The Bottom Of My Broken Heart.zip','CB','1');

There could be in excess of 1000 lines of Inset.

All files received are named ******-logfile.sql

At moment these files are moved to folder filelist with no problems. And i can manually insert into mysql.

I would like to auto insert these files into mysql as they are uploaded.

How can this be done please...

Regards
Keith

[AsaSchool]

I would look into the possibility of using an array to handle the inserts. Write a script to parse the files and insert each one of them at a certain time in the day. Or, have a script that runs on a cron to check for files periodically and insert them when new ones are found.

I dont know if this will work, but this is the direction I would go in.

Good Luck