<?php
error_reporting(0);
ini_set("display_errors",0);
$pdo = new PDO("pgsql:host=localhost;dbname=adx_system", "admin", "admin123");
$code = basename($_SERVER['REQUEST_URI']);
$stmt = $pdo->prepare("SELECT original_url FROM admin.wrapped_links WHERE short_code = ?");
$stmt->execute([$code]);
$link = $stmt->fetch(PDO::FETCH_ASSOC);
if ($link) {
    $pdo->exec("UPDATE admin.wrapped_links SET clicks = clicks + 1 WHERE short_code = '$code'");
    header("Location: " . $link['original_url']);
} else {
    http_response_code(404);
    echo "Not found";
}