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