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
41
42
43
44
45
46
47
48
49
50
51
52
53
54
55
56
57
58
59
60
61
62
63
64
65
66
67
68
69
70
71
72
73
74
75
76
77
78
79
80
81
82
83
84
85
86
87
88
89
90
91
92
93
94
|
<?php
function generatkey($nbcaract){
$word = "a,b,c,d,e,f,g,h,i,j,k,l,m,1,2,3,4,5,6,7,8,9,0";
$array=explode(",",$word);
shuffle($array);
$newstring = implode($array,"");
return substr($newstring, 0, $nbcaract);
}
function Verif_tinyurl($tinyurl,$url,$ip,$browser,$date){
$bool_ok = false;
if (($tinyurl <> '') && ($url <> '') && ($ip <> '') && ($browser <> '') && ($date <> '')) {
require_once("/app_code/dal_sql.php");
$bool_exist_tiny = false;
$sql_SELECT1="SELECT tinyurl_tinyurl FROM ws_tinyurl WHERE tinyurl_tinyurl='".$tinyurl."'";
//echo 'DEBUG : '.$sql_SELECT1.'<br/>';
try {
$sql_EXECUTE1 = $pdo->prepare($sql_SELECT1);
$sql_EXECUTE1->execute();
$nbrows = $sql_EXECUTE1->rowcount();
while ($row = $sql_EXECUTE1->fetch()) {
if($row[0] = $tinyurl){$bool_exist_tiny = true; }
}
}
catch (Exception $e){
$msg = '<p>ERREUR PDO : ' . $e->getFile() . ' L.' . $e->getLine() . ' : ' . $e->getMessage()."</p>";
echo $msg;
}
$bool_exist_url = false;
$sql_SELECT2="SELECT url_tinyurl FROM ws_tinyurl WHERE url_tinyurl='".$url."'";
//echo 'DEBUG : '.$sql_SELECT2.'<br/>';
try {
$sql_EXECUTE2 = $pdo->prepare($sql_SELECT2);
$sql_EXECUTE2->execute();
$nbrows = $sql_EXECUTE2->rowcount();
while ($row = $sql_EXECUTE2->fetch()) {
if($row[0] = $url){$bool_exist_url = true;}
}
}
catch (Exception $e){
$msg = '<p>ERREUR PDO : ' . $e->getFile() . ' L.' . $e->getLine() . ' : ' . $e->getMessage()."</p>";
echo $msg;
}
if ((!$bool_exist_tiny) && (!$bool_exist_url)){
$sql_INSERT="INSERT INTO ws_tinyurl (tinyurl_tinyurl,url_tinyurl,user_ip_tinyurl,user_browser_tinyurl,date_crea_tinyurl) VALUES (?,?,?,?,?)";
$add_parameter=array($tinyurl,$url,$ip,$browser,$date);
try {
$sql_EXECUTE = $pdo->prepare($sql_INSERT);
$sql_EXECUTE->execute($add_parameter);
$nbrows = $sql_EXECUTE->rowcount();
$bool_ok = true;
$msg = 'votre miniurl : '.$tinyurl.'<br/>';
echo $msg;
$bool_ok = true;
}
catch (Exception $e){
$msg = '<p>ERREUR PDO : ' . $e->getFile() . ' L.' . $e->getLine() . ' : ' . $e->getMessage().'</p>';
echo $msg;
}
}
else{
if ($bool_exist_tiny){
$g_tinyurl = generatkey(8);
Verif_tinyurl($g_tinyurl,$url,$ip,$browser,$date);
}
if ($bool_exist_url){
$msg = '<p>l\'url ('.$url.') est déjà enregistré</p>';
echo $msg;
}
}
}
else{echo 'DEBUG tiny : '.$tinyurl.'<br/> url : '.$url.'<br/> ip : '.$ip.'<br/> browser : '.$browser.'<br/> date : '.$date.'<br/>';}
return $bool_ok;
}
$ip = $_SERVER['REMOTE_ADDR'];
$browser = $_SERVER['HTTP_USER_AGENT'];
$date = date("Y-m-d H:i:s");
$get_url = 'MONURL';
$get_tinyurl = 'TINYURL'; //generatkey(6);
if (Verif_tinyurl($get_tinyurl,$get_url,$ip,$browser,$date)) {
echo '<br/>OK<br/>';
}
else {
echo '<br/>PAS OK<br/>';
}
?> |
