7datak0P

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