$servername = "localhost";
$username = "wnesporg_user";  // Your MySQL user
$password = "your_password";  // Your MySQL password
$dbname = "wnesporg_verify_db";

$conn = new mysqli($servername, $username, $password, $dbname);

if ($_SERVER["REQUEST_METHOD"] == "POST") {
    $code = $_POST["code"];
    $sql = "SELECT name, issue_date, file_path FROM documents WHERE code = ?";
    $stmt = $conn->prepare($sql);
    $stmt->bind_param("s", $code);
    $stmt->execute();
    $result = $stmt->get_result();
    
    if ($row = $result->fetch_assoc()) {
        echo "<p>✅ Document Found: " . htmlspecialchars($row["name"]) . " (Issued on " . $row["issue_date"] . ")</p>";
        echo "<p><a href='" . htmlspecialchars($row["file_path"]) . "' target='_blank'>📄 View Document</a></p>";
    } else {
        echo "<p style='color:red;'>❌ Invalid Code. Document Not Found.</p>";
    }
    $stmt->close();
}
$conn->close();
?>

<form method="post">
    <label>Enter Verification Code:</label>
    <input type="text" name="code" required>
    <input type="submit" value="Verify">
</form>