// verify_certificate.php
require_once('config.php');  // Include the database configuration

if (isset($_GET['verification_key'])) {
    $verification_key = $_GET['verification_key'];

    // Query the database to retrieve certificate details by verification key
    try {
        $stmt = $pdo->prepare("SELECT * FROM certificates WHERE verification_key = ?");
        $stmt->execute([$verification_key]);
        $certificate_details = $stmt->fetch(PDO::FETCH_ASSOC);

        if ($certificate_details) {
            // Display the certificate details
            echo "<h1>Certificate Details</h1>";
            echo "<p>Organization: " . $certificate_details['organization'] . "</p>";
            echo "<p>Application: " . $certificate_details['application'] . "</p>";
            echo "<p>Type of Audit: " . $certificate_details['audit_type'] . "</p>";
            echo "<p>URL: " . $certificate_details['url'] . "</p>";
            echo "<p>Initial Testing Date: " . $certificate_details['testing_date'] . "</p>";
            echo "<p>Revalidation Date: " . $certificate_details['revalidation_date'] . "</p>";
            echo "<p>Report ID: " . $certificate_details['report_id'] . "</p>";
            echo "<p>Issued On: " . $certificate_details['issued_on'] . "</p>";
            echo "<p>Certificate Number: " . $certificate_details['certificate_number'] . "</p>";
            echo "<p>Conclusion: " . $certificate_details['conclusion'] . "</p>";
            echo "<p>Recommendations: " . $certificate_details['recommendations'] . "</p>";
        } else {
            echo "Invalid verification key.";
        }
    } catch (PDOException $e) {
        die("Error retrieving certificate from the database: " . $e->getMessage());
    }
} else {
    echo "No verification key provided.";
}