setAttribute(PDO::ATTR_ERRMODE, PDO::ERRMODE_EXCEPTION); } catch (PDOException $e) { echo $e; echo json_encode('Error connecting to the server.'); die(); } $root = '../../assets/建置資料/土地開發'; //$folder = $_GET["folder"]; $plan = ''; FindPath($root, '19004-菓林市地重劃設計', $plan, 1,$pdo); function FindPath($root, $folder, $plan, $type,$pdo) { $rootPath = $root . "/" . $folder; $paths = array_diff(scandir($rootPath), array('.', '..', 'Thumbs.db')); echo ("

"); $i = 1; foreach ($paths as $path) { if (is_file($rootPath . '/' . $path)) { $original_name = $path; if(str_contains($original_name,'-')){ $original_name = explode("-", $original_name,2)[1]; }else if(str_contains($original_name,'_')){ $original_name = explode("_", $original_name,2)[1]; } $filename = $path; $plan = '19004'; $href = substr($rootPath, 4) . "/" . $path; echo ("
• "); $path = "" . $original_name . ""; echo ($path); echo ("
"); $sth = $pdo->prepare("INSERT INTO [21000X].[dbo].[File_Table] ([project_id] ,[SN] ,[type_id] ,[original_name] ,[filename] ,[keyword]) VALUES ('19004', '" . $i . "', '" . $type . "', '" . $original_name . "', '" . $filename . "', '')"); $i++; //$sth->execute(); } else { if (str_contains($path, '-')) { $plan = $path; } echo ("
• "); echo ($path); $type = explode('_', $path)[0]; if ($path != "3_設計圖") FindPath($rootPath, $path, $plan, $type,$pdo); echo ("
"); } } echo ("

"); }