function __construct($id = null)
{
if ($id) {
$db = new ConexionBd();
$sql = "SELECT * FROM `" . $this->tabla . "` WHERE id = '" . $id . "'";
$t = $db->getRow($sql);
foreach ($this->campos as $c => $nombre) {
$this->{$c} = $t[$c];
}
}
}
function login($username, $password)
{
$db = new ConexionBd();
$sql = "SELECT * FROM users WHERE username = '******' AND password = '******'";
$result = $db->getRow($sql);
//echo "<pre>"; print_r($result);echo "</pre>";
if (empty($result)) {
return FALSE;
} else {
if (!isset($_SESSION)) {
session_start();
}
$_SESSION['login'] = $result['username'];
$_SESSION['idusuario'] = $result['id'];
return TRUE;
}
}
public function getClicks()
{
$sql = "SELECT count(*) AS num FROM clicks WHERE id_link = " . $this->id;
$db = new ConexionBd();
return $db->getRow($sql);
}
