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