");
foreach ($paths as $path) {
if (str_contains($path, '.')) {
if (!str_contains(strtolower($path), '.jpg')) {
echo ("");
$title = explode(".", $path)[0];
$file_path = substr($rootPath, 4) . "/" . $path;
$path = "title:" . $title . "path:" . $file_path . " dir_id:" . $row["id"];
echo ($path);
echo ("");
$sql = "BEGIN
IF NOT EXISTS (SELECT * FROM [BIMComponents].[dbo].[Video_Table] WHERE [file_path] = '" . $file_path . "')
BEGIN
INSERT INTO [BIMComponents].[dbo].[Video_Table] ([title],[file_path],[file_name],[dir_id]) VALUES ('" . $title . "','" . $file_path . "','" . $title . "','" . $row["id"] . "')
END
END";
$fetchResult = sqlsrv_query($GLOBALS["conn"], $sql);
}
} else {
echo ("");
echo ("dir_name: " . $path . "parent: " . $folder);
$sql = "BEGIN
IF NOT EXISTS (SELECT * FROM [BIMComponents].[dbo].[Video_Node] WHERE [dir_name] = 'videos')
BEGIN
INSERT INTO [BIMComponents].[dbo].[Video_Node] ([dir_name],[parent]) VALUES ('videos','.')
END
END";
$fetchResult = sqlsrv_query($GLOBALS["conn"], $sql);
$sql = "BEGIN
IF NOT EXISTS (SELECT * FROM [BIMComponents].[dbo].[Video_Node] WHERE [dir_name] = '" . $path . "')
BEGIN
INSERT INTO [BIMComponents].[dbo].[Video_Node] ([dir_name],[parent]) VALUES ('" . $path . "','" . $folder . "')
END
END";
$fetchResult = sqlsrv_query($GLOBALS["conn"], $sql);
FindPath($rootPath, $path);
echo ("");
}
}
echo ("");
}