3LYTN3CF

1$servername = "localhost";
2$username = "root";
3$password = "signion";
4$db = "In_band";
5$conn = mysqli_connect($servername, $username, $password,$db);
6
7if (!$conn) {
8   die("Connection failed: " . mysqli_connect_error());
9}
10$x = "(ID,TIME";
11for ($num=1;$num<=1024;$num++){
12
13    $x = $x.",@OMF_ID".$num;
14}
15$x = $x.")";
16
17$sql = "CREATE TABLE IF NOT EXISTS table_7(ID INT,TIME TEXT,status TEXT)";
18mysqli_query($conn, $sql);
19$sql = "LOAD DATA INFILE '/var/lib/files/data86400_1024.csv' REPLACE INTO TABLE table_7 FILEDS TERMINATED BY ',' ENCLOSED BY '' LINES TERMINATED BY 'n' IGNORE 1 LINES ".$x." set status=@status1024"; 
20     
21LOAD DATA INFILE '/var/lib/files/data86400_1024.csv' REPLACE INTO TABLE table_7 FILEDS TERMINATED BY ',' ENCLOSED BY '' LINES TERMINATED BY 'n' IGNORE 1 LINES (ID,TIME,@status1,@status2,@status3,.......@status1024) set status=@status1024";