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 | ?> |
