· 7 years ago · Nov 27, 2018, 10:02 AM
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 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 $tmp_name = $file["tmp_name"];
20 $presql = "CREATE TABLE IF NOT EXISTS `'$_SESSION[SESS_MEMBER_ID],'_',{$file}`";
21 $sql = <<<EOF
22 LOAD DATA LOCAL INFILE '{$tmp_name}'
23 INTO TABLE `$_SESSION[SESS_MEMBER_ID],'_',{$file}`
24 FIELDS TERMINATED BY ',' OPTIONALLY ENCLOSED BY '\\'
25 LINES TERMINATED BY "\\r\\n"
26 IGNORE 1 LINES
27EOF;
28 mysql_query($presql);
29 mysql_query($sql);
30 //var_dump($sql);
31 echo '$sql';
32 if(mysql_error())
33 {
34 echo(mysql_error());
35 }
36 else
37 {
38 print('Import of campaign emails sucessfull into mysql table.');
39 }
40 }
41 }
42 else
43 {
44 print('Invalid file type. Please make sure it is a text file.');
45 }
46}
47
48//var_dump($_FILES);
49uploadList();
50?>