· 7 years ago · Sep 12, 2018, 01:56 PM
1mysql_select_db('mailList') or die(mysql_error());
2$sql = "LOAD DATA LOCAL INFILE '".$_FILES["file"]["tmp_name"]."'
3 REPLACE
4
5$sql = "CREATE TABLE IF NOT EXISTS '$_SESSION[SESS_MEMBER_ID]'.'$tmp_name'
6 INTO TABLE '$_SESSION[SESS_MEMBER_ID]'.'$tmp_name'
7 FIELDS TERMINATED BY ',' OPTIONALLY ENCLOSED BY '\'
8 LINES TERMINATED BY '\r\n'
9 IGNORE 1 LINES;";
10 mysql_query($sql);