Auto upload sort of thing

[Double_M]

Hey all,

I have a script that uploads a selected csv file by the user and then changes the database and all that. I was wondering if it is possible to actually hardcode the location of the csv file into the script and then just run the code when page loads, and it udates the table.

This code below is the start of the script, so you can see on submit by the user it uploads it. But just wanted to hardcode the location of the csv file instead and have the script run on page load.

Any ideas?

//Verify uploaded file is a CSV
if ($_POST["submit"]=="submit") {
	//Sets uploaded file a temporary name
    if (is_uploaded_file($_FILES['userfile']['tmp_name'])) {

		//Sets temp name to variable
        $file=$_FILES['userfile']['tmp_name'];
		//Connect to database
        $linkdata = mysql_connect($hostname_localhost, $username_localhost, $password_localhost) or die('Could not connect: ' . mysql_error());
        mysql_select_db($database_localhost) or die('Could not select database');

        //Post $file variable to getcsv function and set $dump to $CSVarray
        $CSVarray = getcsv($file);
		//Post $CSVarray and table name to makeINSERTS function 
        $CSVarray = makeINSERTS($CSVarray, "$tbl");

		//Connect to database and remove field headings
		mysql_select_db($database_localhost, $localhost);
		$query_remove_headings = "DELETE FROM ".$tbl." WHERE `RECORDID` = '' AND `ID` = 'ID' AND `COMPANY_NAME` = 'COMPANY_NAME' AND `CUSTOMER_NAME` = 'CUSTOMER_NAME' LIMIT 1";
		$headings = mysql_query($query_remove_headings, $localhost) or die(mysql_error());

Thanks for your response.

[bogu]

What do u mean by "hardcode the location of the csv file into the script"? it has something to do with XXX sites? 😃

[Double_M]

I mean set the actual location of the csv file to a variable or something. Instead of the user having to find it in the file input browse thing 😛

[Weedpacket]

No. For obvious security reasons you cannot have a web page just pull an arbitrary file off a client computer without the user's explicit say-so.

[Weedpacket]

No. For obvious security reasons you cannot have a web page just pull an arbitrary file of your choosing off a client computer without the user's explicit say-so.

[Double_M]

Is it possible to set up a cron job on the server to upload the csv and update the table? Not sure about cron jobs.

Thanks for the replys.

[Double_M]

Well is there absolutley anyway to automate uploading a csv file and update a database? There must be a way. Any ideas?