/
func.inc.php
40 lines (32 loc) · 1.11 KB
/
func.inc.php
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
<?php
include 'db.inc.php';
function is_min($url){
return (preg_match("/tvdt\.us/i", $url)) ? true : false;
}
function gen_code(){
$charset = 'abcdefghijklmnopqrstuvwxyzABCDEFGHIJKLMNOPQRSTUVWXYZ0123456789';
return substr(str_shuffle($charset), 0, 6);
}
function code_exists($code){
$code = mysql_real_escape_string($code); //security against injection
$code_exists = mysql_query("SELECT COUNT(`url_id`) FROM `urls` WHERE `code`='$code' LIMIT 1");
return(mysql_result($code_exists, 0) == 1) ? true : false;
}
function shorten($url, $code){
$url = mysql_real_escape_string($url);//security against injection
$code = mysql_real_escape_string($code);
mysql_query("INSERT INTO `urls` VALUES ('','$url','$code','','')");
return $code;
}
function redirect($code){
$code = mysql_real_escape_string($code);
if(code_exists($code)){
$url_query = mysql_query("SELECT * FROM `urls` WHERE `code`='$code'");
$url = mysql_result($url_query,0,'url');
$hits = mysql_result($url_query,0,'hits');
$hits++;
mysql_query("UPDATE urls SET hits= ' ".$hits." ' WHERE code = '".$code."'");
header('Location: ' .$url);
}
}
?>