SHOW:
|
|
- or go back to the newest paste.
1 | <?php | |
2 | class Shortener { | |
3 | protected $db; | |
4 | ||
5 | public function __construct() { | |
6 | - | $this->db = new mysqli('HOST', 'USER', 'WW', 'DB'); <-- even weg gehaald |
6 | + | $this->db = new mysqli('HOST', 'USER', 'WW', 'DB'); // even weg gehaald |
7 | } | |
8 | ||
9 | public function generateCode($num) { | |
10 | return base_convert($num, 10, 36); | |
11 | } | |
12 | ||
13 | public function makeCode($url) { | |
14 | $url = trim($url); | |
15 | ||
16 | if(!filter_var($url, FILTER_VALIDATE_URL)) { | |
17 | return ''; | |
18 | } | |
19 | ||
20 | $url = $this->db->escape_string($url); | |
21 | return $url; | |
22 | ||
23 | // Kijken of de link al bestaat | |
24 | - | $exists = $this->db->query("SELECT code FROM links WHERE url = '{$url}'"); |
24 | + | $exists = $this->db->query("SELECT code FROM links WHERE url = '" . $url . "'"); |
25 | ||
26 | - | if($exists->num_rows) { |
26 | + | if($exists->num_rows > 0) { |
27 | return $exists->fetch_object()->code; | |
28 | } else { | |
29 | - | $this->db->query("INSERT INTO links (url, created) VALUES ('{$url}', NOW())"); |
29 | + | $this->db->query("INSERT INTO links (url, created) VALUES ('" . $url . "', UNIX_TIMESTAMP())"); |
30 | $code = $this->generateCode($this->db->insert_id); | |
31 | - | $this->db->query("UPDATE links SET code = '{$code}' WHERE url = '{$url}'"); |
31 | + | $this->db->query("UPDATE links SET code = '" . $code . "' WHERE url = '" . $url . "'"); |
32 | ||
33 | return $code; | |
34 | } | |
35 | } | |
36 | ||
37 | public function getUrl($code) { | |
38 | $code = $this->db->escape_string($code); | |
39 | - | $code = $this->db->query("SELECT url FROM links WHERE = '$code'"); |
39 | + | $code = $this->db->query("SELECT url FROM links WHERE = '" . $code . "'"); |
40 | ||
41 | if($code->num_rows) { | |
42 | return $code->fetch_object()->url; | |
43 | } | |
44 | ||
45 | return ''; | |
46 | } | |
47 | } | |
48 | ?> |