<?php print SITE

prepare("SELECT id FROM " . DB_TABLE . " WHERE url=?"); $sth->bindParam(1, $url, PDO::PARAM_STR); $sth->execute(); if ($row = $sth->fetch(PDO::FETCH_ASSOC)) { $hash = $row['id']; } else { $hash = substr(str_shuffle(CHARSET), 0, HASH_LENGTH); $sth = $dbh->prepare("SELECT COUNT(*) FROM " . DB_TABLE . " WHERE id=?"); $sth->bindParam(1, $hash, PDO::PARAM_STR, HASH_LENGTH); $sth->execute(); $loop = 0; while ($sth->fetchColumn() > 0) { if ($loop == 10) { $hash = "ERROR
Unable to create hash!"; break; } $hash = substr(str_shuffle(CHARSET), 0, HASH_LENGTH); $sth->bindParam(1, $hash, PDO::PARAM_STR, HASH_LENGTH); $sth->execute(); $loop++; } try { $sth = $dbh->prepare("INSERT INTO " . DB_TABLE . " (id, url, ip, count) VALUES (?, ?, ?, '0')"); $sth->bindParam(1, $hash, PDO::PARAM_STR, HASH_LENGTH); $sth->bindParam(2, $url, PDO::PARAM_STR); $sth->bindParam(3, $clientip, PDO::PARAM_STR, 255); $sth->execute(); } catch (PDOException $e) { $hash = "ERROR
Failed to insert hash!"; } } return $hash; } function find_short($hash, $dbh) { $sth = $dbh->prepare("SELECT * FROM " . DB_TABLE . " WHERE id=?"); $sth->bindParam(1, $hash, PDO::PARAM_STR, HASH_LENGTH); $sth->execute(); if ($row = $sth->fetch(PDO::FETCH_ASSOC)) { $link = $row['url']; $sth = $dbh->prepare("UPDATE " . DB_TABLE . " SET count = count + 1 WHERE id=?"); $sth->bindParam(1, $row['id'], PDO::PARAM_STR, HASH_LENGTH); $sth->execute(); } else { $link = false; } return $link; } if (isset($_POST['url'])) { if ($_POST['url'] != '' && strlen($_POST['url']) > 0) { $link = generate_short($_POST['url'], $dbh); } else { $link = false; } } if (isset($_GET['hash']) && $_GET['hash'] != '' && strlen($_GET['hash']) > 0) { $path = explode('/', $_SERVER['REQUEST_URI']); $uri = $path[count($path)-1]; if ($uri != '') { $link = find_short($uri, $dbh); if ($link != '') { header("Cache-Control: no-cache, must-revalidate"); header("Expires: Wed, 29 Feb 1984 00:00:00 GMT"); header("Location: $link", TRUE, 301); } } } if ($callback == 'NO') { $sth = $dbh->query("SELECT COUNT(*) FROM ". DB_TABLE); $count = $sth->fetchColumn(); ?> <?php print SITE_TITLE ?>

Unknown / Invalid URL"; } elseif (str_contains($link, "ERROR")) { echo "$link"; } else { if ($link != '') { echo "" . BASE_URL . $link . ""; } } ?>

Currently holding entries.