stdin

stdin.txt

<?php
var_dump($_FILES);
//db connection
require 'dbConnect.php';
//session file
require_once('../auth.php');
function uploadList(){
	$file = $_FILES["file"];
	$filename = $file["name"];
	var_dump($_FILES);
	$memberID = $_SESSION["SESS_MEMBER_ID"];
	if ($file["type"] == "text/plain")
		{
		if ($file["error"] > 0)
			{
			echo "Return Code: " . $file['error'] . "<br />";
		}
		else
			{
			dbConnect();
			mysql_select_db('mailList') or die(mysql_error());
			$tmp_name =  $file["tmp_name"];
			$presql = "CREATE TABLE IF NOT EXISTS `{$memberID}` (id MEDIUMINT AUTO_INCREMENT PRIMARY KEY UNIQUE)";
			$midsql = "ALTER TABLE `{$memberID}` ADD `{$filename}` VARCHAR(60)";
			$sql = <<<EOF
			LOAD DATA LOCAL INFILE '{$tmp_name}'
			INTO TABLE `{$memberID}` 
			FIELDS TERMINATED BY ',' OPTIONALLY ENCLOSED BY '\\''
			LINES TERMINATED BY "\\r\\n"
			IGNORE 1 LINES
EOF;
                        var_dump($sql);
                        echo '$sql';
			mysql_query($presql) or die(mysql_error());
			mysql_query($midsql) or die(mysql_error());
			mysql_query($sql) or die(mysql_error());
			var_dump($sql);
			echo '$sql';
			if(mysql_error())
				{
				echo(mysql_error());
			}
			else
				{
				print('Import of campaign emails sucessfull into mysql table.');
			}
		}
	}
	else
		{
		print('Invalid file type. Please make sure it is a text file.');
	}
}

//var_dump($_FILES);
uploadList();
?>