· 7 years ago · Nov 28, 2018, 06:04 AM
1<?php
2var_dump($_FILES);
3//db connection
4require 'dbConnect.php';
5//session file
6require_once('../auth.php');
7function uploadList(){
8 $target_path = "/home/nyctelecomm.com/www/mail/upload/";
9 //$_FILE function, grab files
10 $inFile = $_FILES["file"];
11 //Get file name
12 $filename = $inFile["name"];
13 //strip the file extension
14 $filename = preg_replace('/\.[^.]+$/','',$filename);
15 //grab sessionID which is memberID
16 $memberID = $_SESSION["SESS_MEMBER_ID"];
17 //identify cvs, tested with MS excel in csv format
18 if ($inFile["type"] == "application/octet-stream")
19 {
20 if ($inFile["error"] > 0)
21 {
22 echo "Return Code: " . $inFile['error'] . "<br />";
23 }
24 else
25 {
26 dbConnect();
27 mysql_select_db('mailList') or die(mysql_error());
28 //assign temporary name to variable
29 //for insert since tmp_file is the real file
30 $tmp_file = $inFile["tmp_name"];
31 $presql = "CREATE TABLE IF NOT EXISTS `{$memberID}` (id MEDIUMINT AUTO_INCREMENT PRIMARY KEY UNIQUE)";
32 $midsql = "ALTER TABLE `{$memberID}` ADD `{$filename}` VARCHAR(60) FIRST";
33 $sql = <<<EOF
34 LOAD DATA LOCAL INFILE '{$tmp_file}'
35 INTO TABLE `{$memberID}`
36 FIELDS TERMINATED BY ',' OPTIONALLY ENCLOSED BY '\\''
37 LINES TERMINATED BY "\\r\\n
38 IGNORE 1 LINES ($filename)"
39EOF;
40 var_dump($sql);
41 echo '$sql';
42 mysql_query($presql) or die(mysql_error());
43 mysql_query($midsql) or die(mysql_error());
44 mysql_query($sql) or die(mysql_error());
45 var_dump($sql);
46 echo '$sql';
47 if(mysql_error())
48 {
49 echo(mysql_error());
50 }
51 else
52 {
53 print('Import of campaign emails sucessfull into mysql table.');
54 }
55 }
56 }
57 else
58 {
59 print('Invalid file type. Please make sure it is a text file.');
60 }
61}
62
63//var_dump($_FILES);
64uploadList();
65?>