Files

0) { try { $stmt = $conn->prepare(' INSERT INTO "FILE" ("COMPONENT_ID", "FILE_NAME", "CODE") VALUES (?, ?, ?) '); $stmt->bindParam(1, $component_id, PDO::PARAM_INT); $stmt->bindParam(2, $filename, PDO::PARAM_STR); $stmt->bindParam(3, $code_content, PDO::PARAM_LOB); // Use LOB for bytea $stmt->execute(); // Redirect to prevent form resubmission header("Location: FILE.php?repository_id=" . $repository_id . "&project_id=" . $project_id . "&component_id=" . $component_id); exit(); } catch (PDOException $e) { echo "Error: " . htmlspecialchars($e->getMessage(), ENT_QUOTES, 'UTF-8'); } } } // Search functionality $search = ""; if ($_SERVER["REQUEST_METHOD"] == "GET" && isset($_GET["search"])) { $search = trim($_GET["search"]); } // Fetch files try { $base_query = ' SELECT f.*, c."COMPONENT_NAME", p."PROJECT_NAME", p."PROJECT_ID", r."REPOSITORY_NAME", r."REPOSITORY_ID" FROM "FILE" f LEFT JOIN "COMPONENT" c ON f."COMPONENT_ID" = c."COMPONENT_ID" LEFT JOIN "PROJECT" p ON c."PROJECT_ID" = p."PROJECT_ID" LEFT JOIN "REPOSITORY" r ON p."REPOSITORY_ID" = r."REPOSITORY_ID" '; if ($search !== "") { $searchParam = "%{$search}%"; // Corrected Search: Only search FILE_NAME using ILIKE for case-insensitivity $stmt = $conn->prepare($base_query . ' WHERE f."FILE_NAME" ILIKE ? ORDER BY f."CREATED_AT" DESC'); $stmt->bindParam(1, $searchParam, PDO::PARAM_STR); } else { $stmt = $conn->prepare($base_query . ' WHERE f."COMPONENT_ID" = ? ORDER BY f."CREATED_AT" DESC'); $stmt->bindParam(1, $component_id, PDO::PARAM_INT); } $stmt->execute(); $results = $stmt->fetchAll(PDO::FETCH_ASSOC); } catch (PDOException $e) { echo "Error: " . htmlspecialchars($e->getMessage(), ENT_QUOTES, 'UTF-8'); $results = []; } $conn = null; // Close PDO connection ?> Files

文件路径

代码内容

时间戳

/ / /

Decrypting…

未找到任何文件记录。