短网址 php

<?php
// 数据库连接
$servername = "localhost";
$username = "username";
$password = "password";
$dbname = "short_url_db";

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

if ($conn->connect_error) {
    die("连接失败: " . $conn->connect_error);
}

// 生成短网址
function generateShortUrl($longUrl) {
    global $conn;
    $shortCode = substr(md5($longUrl), 0, 8); // 使用MD5哈希算法生成短码

    $sql = "INSERT INTO short_urls (long_url, short_code) VALUES ('$longUrl', '$shortCode') ON DUPLICATE KEY UPDATE long_url='$longUrl'";
    if ($conn->query($sql) === TRUE) {
        return $shortCode;
    } else {
        echo "Error: " . $sql . "<br>" . $conn->error;
    }
}

// 获取长网址
function getLongUrl($shortCode) {
    global $conn;
    $sql = "SELECT long_url FROM short_urls WHERE short_code = '$shortCode'";
    $result = $conn->query($sql);

    if ($result->num_rows > 0) {
        $row = $result->fetch_assoc();
        return $row["long_url"];
    } else {
        return "短网址不存在";
    }
}

// 示例
$longUrl = "https://www.example.com/very/long/url";
$shortCode = generateShortUrl($longUrl);
echo "短网址: http://short.url/$shortCode<br>";

$retrievedLongUrl = getLongUrl($shortCode);
echo "原始长网址: $retrievedLongUrl";

$conn->close();
?>