实例讲述了php生成短网址/短链接原理和用法,分享给大家供大家参考,具体如下:文章源自菜鸟学院-https://www.cainiaoxueyuan.com/bc/42933.html
需求文章源自菜鸟学院-https://www.cainiaoxueyuan.com/bc/42933.html
在我们的项目当中,如果需要更好传播我们的活动链接,但是链接太长1来是不美观,2来是太过于“笨重”,例如拼多多,淘宝联盟,他们的推广链接都是有短链接的,还有新浪微博。文章源自菜鸟学院-https://www.cainiaoxueyuan.com/bc/42933.html
但是,这些始终都是别人的,我们调用别人的API进行生成,不稳定,所以可以自己做一个,注册一个稍微短一些的域名就行。文章源自菜鸟学院-https://www.cainiaoxueyuan.com/bc/42933.html
生成源码api.php文章源自菜鸟学院-https://www.cainiaoxueyuan.com/bc/42933.html
header("Content-type:application/json");文章源自菜鸟学院-https://www.cainiaoxueyuan.com/bc/42933.html
//GET URL文章源自菜鸟学院-https://www.cainiaoxueyuan.com/bc/42933.html
$url = $_GET["url"];文章源自菜鸟学院-https://www.cainiaoxueyuan.com/bc/42933.html
//过滤数据文章源自菜鸟学院-https://www.cainiaoxueyuan.com/bc/42933.html
if (trim(emptyempty($url))) {文章源自菜鸟学院-https://www.cainiaoxueyuan.com/bc/42933.html
echo "{\"code\":\"1\",\"url\":\"未传入URL\"}";文章源自菜鸟学院-https://www.cainiaoxueyuan.com/bc/42933.html
}else{文章源自菜鸟学院-https://www.cainiaoxueyuan.com/bc/42933.html
//定义数据库配置文章源自菜鸟学院-https://www.cainiaoxueyuan.com/bc/42933.html
$dbhost = "xxx";//数据库服务器地址文章源自菜鸟学院-https://www.cainiaoxueyuan.com/bc/42933.html
$dbuser = "xxx";//数据库账号文章源自菜鸟学院-https://www.cainiaoxueyuan.com/bc/42933.html
$dbpwd = "xxx";//数据库密码文章源自菜鸟学院-https://www.cainiaoxueyuan.com/bc/42933.html
$dbname = "xxx";//数据库名文章源自菜鸟学院-https://www.cainiaoxueyuan.com/bc/42933.html
//连接数据库文章源自菜鸟学院-https://www.cainiaoxueyuan.com/bc/42933.html
$con = mysql_connect($dbhost,$dbuser,$dbpwd);文章源自菜鸟学院-https://www.cainiaoxueyuan.com/bc/42933.html
if (!$con)文章源自菜鸟学院-https://www.cainiaoxueyuan.com/bc/42933.html
{文章源自菜鸟学院-https://www.cainiaoxueyuan.com/bc/42933.html
die('Could not connect: ' . mysql_error());文章源自菜鸟学院-https://www.cainiaoxueyuan.com/bc/42933.html
}文章源自菜鸟学院-https://www.cainiaoxueyuan.com/bc/42933.html
mysql_select_db($dbname, $con);文章源自菜鸟学院-https://www.cainiaoxueyuan.com/bc/42933.html
//检查数据库是否已经存在该URL文章源自菜鸟学院-https://www.cainiaoxueyuan.com/bc/42933.html
$check = mysql_query("SELECT * FROM 表名 WHERE long_url = '$url'");文章源自菜鸟学院-https://www.cainiaoxueyuan.com/bc/42933.html
$check_result = mysql_num_rows($check);文章源自菜鸟学院-https://www.cainiaoxueyuan.com/bc/42933.html
//如果已经存在,则直接返回之前生成的链接文章源自菜鸟学院-https://www.cainiaoxueyuan.com/bc/42933.html
if ($check_result) {文章源自菜鸟学院-https://www.cainiaoxueyuan.com/bc/42933.html
while ($row_yicunzai = mysql_fetch_array($check)) {文章源自菜鸟学院-https://www.cainiaoxueyuan.com/bc/42933.html
$yicunzai_key = $row_yicunzai["dwz_key"];文章源自菜鸟学院-https://www.cainiaoxueyuan.com/bc/42933.html
//返回KEY文章源自菜鸟学院-https://www.cainiaoxueyuan.com/bc/42933.html
echo "{\"code\":\"0\",\"url\":\"域名".$yicunzai_key."\"}";文章源自菜鸟学院-https://www.cainiaoxueyuan.com/bc/42933.html
}文章源自菜鸟学院-https://www.cainiaoxueyuan.com/bc/42933.html
}else{文章源自菜鸟学院-https://www.cainiaoxueyuan.com/bc/42933.html
//生成KEY文章源自菜鸟学院-https://www.cainiaoxueyuan.com/bc/42933.html
$key_str = "abcdefghijklmnopqrstuvwxyzABCDEFGHIJKLMNOPQRSTUVWXYZ1234567890";文章源自菜鸟学院-https://www.cainiaoxueyuan.com/bc/42933.html
$key = substr(str_shuffle($key_str),mt_rand(0,strlen($key_str)-11),4);文章源自菜鸟学院-https://www.cainiaoxueyuan.com/bc/42933.html
//生成短链接文章源自菜鸟学院-https://www.cainiaoxueyuan.com/bc/42933.html
mysql_query("INSERT INTO lkydwz (long_url, dwz_key) VALUES ('$url', '$key')");文章源自菜鸟学院-https://www.cainiaoxueyuan.com/bc/42933.html
//返回结果文章源自菜鸟学院-https://www.cainiaoxueyuan.com/bc/42933.html
echo "{\"code\":\"0\",\"url\":\"域名".$key."\"}";文章源自菜鸟学院-https://www.cainiaoxueyuan.com/bc/42933.html
}文章源自菜鸟学院-https://www.cainiaoxueyuan.com/bc/42933.html
//断开数据库连接文章源自菜鸟学院-https://www.cainiaoxueyuan.com/bc/42933.html
mysql_close($con);文章源自菜鸟学院-https://www.cainiaoxueyuan.com/bc/42933.html
}文章源自菜鸟学院-https://www.cainiaoxueyuan.com/bc/42933.html
?>文章源自菜鸟学院-https://www.cainiaoxueyuan.com/bc/42933.html
访问源码index.php文章源自菜鸟学院-https://www.cainiaoxueyuan.com/bc/42933.html
header("Content-Type:text/html;charset=utf-8");文章源自菜鸟学院-https://www.cainiaoxueyuan.com/bc/42933.html
//获得当前传过来的KEY文章源自菜鸟学院-https://www.cainiaoxueyuan.com/bc/42933.html
$key = $_GET["id"];文章源自菜鸟学院-https://www.cainiaoxueyuan.com/bc/42933.html
echo "";文章源自菜鸟学院-https://www.cainiaoxueyuan.com/bc/42933.html
//过滤数据文章源自菜鸟学院-https://www.cainiaoxueyuan.com/bc/42933.html
if (trim(emptyempty($key))) {文章源自菜鸟学院-https://www.cainiaoxueyuan.com/bc/42933.html
echo "链接不存在";文章源自菜鸟学院-https://www.cainiaoxueyuan.com/bc/42933.html
}else{文章源自菜鸟学院-https://www.cainiaoxueyuan.com/bc/42933.html
//解析KEY文章源自菜鸟学院-https://www.cainiaoxueyuan.com/bc/42933.html
//定义数据库配置文章源自菜鸟学院-https://www.cainiaoxueyuan.com/bc/42933.html
$dbhost = "xxx";//数据库服务器地址文章源自菜鸟学院-https://www.cainiaoxueyuan.com/bc/42933.html
$dbuser = "xxx";//数据库账号文章源自菜鸟学院-https://www.cainiaoxueyuan.com/bc/42933.html
$dbpwd = "xxx";//数据库密码文章源自菜鸟学院-https://www.cainiaoxueyuan.com/bc/42933.html
$dbname = "xxx";//数据库名文章源自菜鸟学院-https://www.cainiaoxueyuan.com/bc/42933.html
//连接数据库文章源自菜鸟学院-https://www.cainiaoxueyuan.com/bc/42933.html
$con = mysql_connect($dbhost,$dbuser,$dbpwd);文章源自菜鸟学院-https://www.cainiaoxueyuan.com/bc/42933.html
if (!$con)文章源自菜鸟学院-https://www.cainiaoxueyuan.com/bc/42933.html
{文章源自菜鸟学院-https://www.cainiaoxueyuan.com/bc/42933.html
die('Could not connect: ' . mysql_error());文章源自菜鸟学院-https://www.cainiaoxueyuan.com/bc/42933.html
}文章源自菜鸟学院-https://www.cainiaoxueyuan.com/bc/42933.html
mysql_select_db($dbname, $con);文章源自菜鸟学院-https://www.cainiaoxueyuan.com/bc/42933.html
//查询数据库,通过KEY获取长链接进行跳转文章源自菜鸟学院-https://www.cainiaoxueyuan.com/bc/42933.html
//检查数据库是否存在该KEY文章源自菜鸟学院-https://www.cainiaoxueyuan.com/bc/42933.html
$check = mysql_query("SELECT * FROM 表名 WHERE dwz_key = '$key'");文章源自菜鸟学院-https://www.cainiaoxueyuan.com/bc/42933.html
$check_result = mysql_num_rows($check);文章源自菜鸟学院-https://www.cainiaoxueyuan.com/bc/42933.html
//如果存在,则解析出长链接并跳转文章源自菜鸟学院-https://www.cainiaoxueyuan.com/bc/42933.html
if ($check_result) {文章源自菜鸟学院-https://www.cainiaoxueyuan.com/bc/42933.html
while ($row_long_url = mysql_fetch_array($check)) {文章源自菜鸟学院-https://www.cainiaoxueyuan.com/bc/42933.html
$long_url = $row_long_url["long_url"];文章源自菜鸟学院-https://www.cainiaoxueyuan.com/bc/42933.html
// echo "<script>location.href=\"".$long_url."\";</script>";文章源自菜鸟学院-https://www.cainiaoxueyuan.com/bc/42933.html
header("Location: $long_url");文章源自菜鸟学院-https://www.cainiaoxueyuan.com/bc/42933.html
}文章源自菜鸟学院-https://www.cainiaoxueyuan.com/bc/42933.html
}else{文章源自菜鸟学院-https://www.cainiaoxueyuan.com/bc/42933.html
echo "链接不存在";文章源自菜鸟学院-https://www.cainiaoxueyuan.com/bc/42933.html
}文章源自菜鸟学院-https://www.cainiaoxueyuan.com/bc/42933.html
}文章源自菜鸟学院-https://www.cainiaoxueyuan.com/bc/42933.html
?>文章源自菜鸟学院-https://www.cainiaoxueyuan.com/bc/42933.html
Apache规则.htaccess文章源自菜鸟学院-https://www.cainiaoxueyuan.com/bc/42933.html
RewriteEngine On文章源自菜鸟学院-https://www.cainiaoxueyuan.com/bc/42933.html
#RewriteBase /文章源自菜鸟学院-https://www.cainiaoxueyuan.com/bc/42933.html
RewriteRule ^(\w+)$ index.php?id=$1文章源自菜鸟学院-https://www.cainiaoxueyuan.com/bc/42933.html
数据库字段文章源自菜鸟学院-https://www.cainiaoxueyuan.com/bc/42933.html
id(
int文章源自菜鸟学院-https://www.cainiaoxueyuan.com/bc/42933.html
)自增
dwz_key(varchar)文章源自菜鸟学院-https://www.cainiaoxueyuan.com/bc/42933.html
long_url(text)文章源自菜鸟学院-https://www.cainiaoxueyuan.com/bc/42933.html
creat_time(TIMESTAMP)文章源自菜鸟学院-https://www.cainiaoxueyuan.com/bc/42933.html
文章源自菜鸟学院-https://www.cainiaoxueyuan.com/bc/42933.html
使用方法文章源自菜鸟学院-https://www.cainiaoxueyuan.com/bc/42933.html
1、访问api.php?url=长链接,即可生成短链接,例如返回JSON文章源自菜鸟学院-https://www.cainiaoxueyuan.com/bc/42933.html
{"code":"0","url":"http://xxx.cn/Hp8R"}文章源自菜鸟学院-https://www.cainiaoxueyuan.com/bc/42933.html
2、新建.htaccess,把上面规则复制进去,保存文章源自菜鸟学院-https://www.cainiaoxueyuan.com/bc/42933.html
3、新建index.php,把上面代码拷贝进去,配置好数据库。访问http://xxx.cn/Hp8R,就会自动跳转到你的长链接文章源自菜鸟学院-https://www.cainiaoxueyuan.com/bc/42933.html