轮廓：输入有效的长网址并进行缩短，出现一个弹出框，其中包含一个短网址和一个保存按钮（编辑或保存短网址）单击保存按钮后，页面重新加载，并显示创建的短网址、源网址等信息。
<?php
include "php/config.php"; // 包含配置文件，连接到数据库
$new_url = ""; // 初始化变量
// 判断是否存在GET请求
if(isset($_GET)){
foreach($_GET as $key=>$val){
$u = mysqli_real_escape_string($conn, $key); // 获取短链接参数并进行转义处理，防止SQL注入攻击
$new_url = str_replace('/', '', $u); // 替换短链接中的斜杠字符
}
// 查询数据库中对应的长网址
$sql = mysqli_query($conn, "SELECT full_url FROM url WHERE shorten_url = '{$new_url}'");
// 如果存在查询结果
if(mysqli_num_rows($sql) > 0){
$sql2 = mysqli_query($conn, "UPDATE url SET clicks = clicks + 1 WHERE shorten_url = '{$new_url}'"); // 更新点击次数
if($sql2){
$full_url = mysqli_fetch_assoc($sql);
header("Location:".$full_url['full_url']); // 跳转到原始URL
}
}
}
?>数据库配置
<?php
$domain = "https://dabenshi.cn/"; //例如: dabenshi.cn/
$host = "localhost";
$user = ""; //数据库用户名
$pass = ""; //数据库密码
$db = ""; //数据库名
$conn = mysqli_connect($host, $user, $pass, $db);
if(!$conn){
echo "Database connection error".mysqli_connect_error();
}
?>创建"urlshortener"数据库，"url"表。包含四个字段：id、shorten_url、full_url和clicks。
id字段是一个自增的整数类型，作为主键使用。shorten_url字段是一个长度为200的非空字符串，用于保存缩短后的URL。full_url字段是一个长度为1000的非空字符串，用于保存完整的URL。clicks字段是一个整数类型，用于记录URL的点击次数。
数据删除
<?php
include "config.php";
if(isset($_GET['id'])){
$delete_id = mysqli_real_escape_string($conn, $_GET['id']);
$sql = mysqli_query($conn, "DELETE FROM url WHERE shorten_url = '{$delete_id}'");
if($sql){
header("Location: ../");
}else{
header("Location: ../");
}
}elseif(isset($_GET['delete'])){
$sql3 = mysqli_query($conn, "DELETE FROM url");
if($sql3){
header("Location: ../");
}else{
header("Location: ../");
}
}else{
header("Location: ../");
}
?>自定义短网址
<?php
include "config.php";
$og_url = mysqli_real_escape_string($conn, $_POST['shorten_url']);
$shorten_url = str_replace(' ', '', $og_url);
$hidden_url = mysqli_real_escape_string($conn, $_POST['hidden_url']);
if(!empty($shorten_url)){
if(preg_match("/\//i", $shorten_url)){
$explodeURL = explode('/', $shorten_url);
$shortURL = end($explodeURL);
if($shortURL != ""){
$sql = mysqli_query($conn, "SELECT shorten_url FROM url WHERE shorten_url = '{$shortURL}' && shorten_url != '{$hidden_url}'");
if(mysqli_num_rows($sql) == 0){
$sql2 = mysqli_query($conn, "UPDATE url SET shorten_url = '{$shortURL}' WHERE shorten_url = '{$hidden_url}'");
if($sql2){
echo "success";
}else{
echo "错误 - 无法更新链接!";
}
}else{
echo "你输入的短网址已存在。请输入另一个!";
}
}else{
echo "必需 - 你必须输入短网址!";
}
}else{
echo "无效网址 - 你无法编辑域名!";
}
}else{
echo "错误 - 你必须输入短网址!";
}
?>URL控制
<?php
include "config.php";
$full_url = mysqli_real_escape_string($conn, $_POST['full_url']);
if(!empty($full_url) && filter_var($full_url, FILTER_VALIDATE_URL)){
$ran_url = substr(md5(microtime()), rand(0, 26), 5);
$sql = mysqli_query($conn, "SELECT * FROM url WHERE shorten_url = '{$ran_url}'");
if(mysqli_num_rows($sql) > 0){
echo "出了点问题. 请重新缩短!";
}else{
$sql2 = mysqli_query($conn, "INSERT INTO url (full_url, shorten_url, clicks)
VALUES ('{$full_url}', '{$ran_url}', '0')");
if($sql2){
$sql3 = mysqli_query($conn, "SELECT shorten_url FROM url WHERE shorten_url = '{$ran_url}'");
if(mysqli_num_rows($sql3) > 0){
$shorten_url = mysqli_fetch_assoc($sql3);
echo $shorten_url['shorten_url'];
}
}
}
}else{
echo "$full_url - 这不是有效的网址!";
}
?>JаvaScript
const form = document.querySelector(".wrapper form"),
fullURL = form.querySelector("input"),
shortenBtn = form.querySelector("form button"),
blurEffect = document.querySelector(".blur-effect"),
popupBox = document.querySelector(".popup-box"),
infoBox = popupBox.querySelector(".info-box"),
form2 = popupBox.querySelector("form"),
shortenURL = popupBox.querySelector("form .shorten-url"),
copyIcon = popupBox.querySelector("form .copy-icon"),
saveBtn = popupBox.querySelector("button");
form.onsubmit = (e)=>{
e.preventDefault();
}
shortenBtn.onclick = ()=>{
let xhr = new XMLHttpRequest();
xhr.open("POST", "php/url-controll.php", true);
xhr.onload = ()=>{
if(xhr.readyState == 4 && xhr.status == 200){
let data = xhr.response;
if(data.length <= 5){
blurEffect.style.display = "block";
popupBox.classList.add("show");
//网址填写到这里. 例如: dabenshi.cn/
let domain = "https://dabenshi.cn/";
shortenURL.value = domain + data;
copyIcon.onclick = ()=>{
shortenURL.select();
document.execCommand("copy");
}
saveBtn.onclick = ()=>{
form2.onsubmit = (e)=>{
e.preventDefault();
}
let xhr2 = new XMLHttpRequest();
xhr2.open("POST", "php/save-url.php", true);
xhr2.onload = ()=>{
if(xhr2.readyState == 4 && xhr2.status == 200){
let data = xhr2.response;
if(data == "success"){
location.reload();
}else{
infoBox.classList.add("error");
infoBox.innerText = data;
}
}
}
let shorten_url1 = shortenURL.value;
let hidden_url = data;
xhr2.setRequestHeader("Content-type", "application/x-www-form-urlencoded");
xhr2.send("shorten_url="+shorten_url1+"&hidden_url="+hidden_url);
}
}else{
alert(data);
}
}
}
let formData = new FormData(form);
xhr.send(formData);
}
日记笔录 本站采用 CC BY-NC-SA 4.0 授权协议，转载请注明来源，谢谢！