UPLOAD MULTIPLE FILES AND SAVE CATEGORY, PATH AND FILE NAMES IN YII 2

Create Uploads table.

1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16

CREATE TABLE `uploads` ( `id` int(11) NOT NULL, `category` varchar(45) DEFAULT NULL, `excelFile` varchar(255) DEFAULT NULL, `path` varchar(45) DEFAULT NULL, `dateUploaded` datetime DEFAULT CURRENT_TIMESTAMP ) ENGINE=InnoDB DEFAULT CHARSET=utf8;   ALTER TABLE `uploads` ADD PRIMARY KEY (`id`);   ALTER TABLE `uploads` MODIFY `id` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=6; COMMIT;   <span style="background-color:#f3f6f8;font-family:Monaco, Consolas, 'Andale Mono', 'DejaVu Sans Mono', 'Courier 10 Pitch', Courier, monospace;">