setAttribute(PDO::ATTR_ERRMODE, PDO::ERRMODE_EXCEPTION); } catch (PDOException $e) { die("Database connection failed: " . $e->getMessage()); } // Get the 'link' parameter from the query string $link = $_GET['link'] ?? ''; // If the link parameter is empty, show the welcome page if ($link === '' || $link === 'index.php') { ?> Sterling Public Schools | URL Shortener

Sterling Public Schools

This domain (strk12.link) is used by Sterling Public Schools to provide shortened URLs. If you are a parent or community member, please note the link you are trying to access may be invalid.



Copyright © Sterling Public Schools

prepare("SELECT redirect_url FROM links WHERE short_link = :short_link AND deleted_at IS NULL"); $stmt->execute(['short_link' => $link]); $row = $stmt->fetch(PDO::FETCH_ASSOC); if ($row) { // Redirect to the corresponding URL if a valid link is found header("Location: " . $row['redirect_url']); exit(); } } catch (PDOException $e) { die("Error fetching link: " . $e->getMessage()); } // If no valid link is found, show the "Page Not Found" content ?> Page Not Found

404 - Page Not Found

We're sorry, but the short link you entered does not exist.

Redirecting to Sterling Public Schools | Home in 5 seconds.