ba72jy2S

1/*CREATE MANIFEST TABLE*/
2$sqlDrop = "DROP TABLE IF EXISTS db.table";
3$rsDrop = mysqli_query($conn, $sqlDrop);
4check_query($rsDrop,$sqlDrop);
5
6$sqlCreate = "CREATE TABLE db.table
7(
8manifest_files CHAR(100) NOT NULL,
9PRIMARY KEY(manifest_files)
10)";
11$rsCreate = mysqli_query($conn, $sqlCreate);
12check_query($rsCreate,$sqlCreate);
13
14
15/*GET FILENAMES FROM DIRECTORY TO INSERT INTO TABLE ABOVE*/
16$dir = "<Path to data>";
17
18$files = array_diff(scandir($dir), array('..', '.'));
19
20while(list(,$value) = each($files)){
21
22    $sqlInsert = "INSERT INTO db.table (manifest_files) VALUES('".$value."')";
23    $rsInsert = mysqli_query($conn, $sqlInsert);
24    check_query($rsInsert,$sqlInsert);