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); }