-
Notifications
You must be signed in to change notification settings - Fork 12
/
linkclass.php
39 lines (29 loc) · 906 Bytes
/
linkclass.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
<?php
class Link {
public $id;
public $redditid;
public $url;
public $firstvisit;
public $lastvisit;
public $numcomments;
public $commenttime;
public $userid;
public $devices;
public $developers;
public function loadLink($i) {
global $mysql;
$sql = "SELECT * FROM `links` WHERE `linkid` = '".$mysql->real_escape_string($i)."' LIMIT 1";
if(!($res = $mysql->query($sql))) {
return false;
}
$link = $res->fetch_assoc();
$this->id = $link["id"];
$this->redditid = $link["linkid"];
$this->firstvisit = $link["firstvisit"];
$this->lastvisit = $link["lastvisit"];
$this->numcomments = $link["lastcommentcount"];
$this->commenttime = $link["lastcommenttime"];
$this->developers = $link["developers"];
$this->devices = $link["lastcall"];
}
}