a2NNd0Ma

1<?php
2var_dump($_FILES);
3//db connection
4require 'dbConnect.php';
5//session file
6require_once('../auth.php');
7function uploadList(){
8	//var_dump($_FILES['file']);
9	if ($_FILES["file"]["type"] == "text/plain")
10		{
11		if ($_FILES["file"]["error"] > 0)
12			{
13			echo "Return Code: " . $_FILES['file']['error'] . "<br />";
14		}
15		else
16			{
17			dbConnect();
18			mysql_select_db('mailList') or die(mysql_error());
19			//$file=''
20			$file = $_FILES["file"];
21			$tmp_name =  $file["tmp_name"];
22			$presql = "CREATE TABLE IF NOT EXISTS `'$_SESSION[SESS_MEMBER_ID]','_',['file']`";
23			$sql = <<<EOF
24			LOAD DATA LOCAL INFILE '{$tmp_name}'
25			INTO TABLE `$_SESSION[SESS_MEMBER_ID],'_',['file']`
26			FIELDS TERMINATED BY ',' OPTIONALLY ENCLOSED BY '\\'
27			LINES TERMINATED BY "\\r\\n"
28			IGNORE 1 LINES
29EOF;
30			mysql_query($presql);
31			mysql_query($sql);
32			//var_dump($sql);
33			echo '$sql';
34			if(mysql_error())
35				{
36				echo(mysql_error());
37			}
38			else
39				{
40				print('Import of campaign emails sucessfull into mysql table.');
41			}
42		}
43	}
44	else
45		{
46		print('Invalid file type. Please make sure it is a text file.');
47	}
48}
49
50//var_dump($_FILES);
51uploadList();
52?>