function delete() { if (is_null($this->id)) { return false; } //.... \_db::query(''); }
/** * Return exemplar of PDO object * * @return null|PDO */ public static function get() { if (is_null(self::$dbh)) { try { self::$dbh = new PDO(Config::$dbDriver . ':host=' . Config::$dbHost . ';dbname=' . Config::$dbName . ';charset=' . Config::$dbCharset, Config::$dbUsername, Config::$dbPassword, array(PDO::ATTR_ERRMODE => PDO::ERRMODE_EXCEPTION)); } catch (PDOException $pe) { crash($pe->getMessage()); } } return self::$dbh; }
/** * Login */ function login($login = '', $senha = '') { //retornando o status; logado/não logado if ($login == '') { return $this->setup['login']; } //tratando login/senha $login = strtoupper($this->_escape($login)); $senha = md5(trim($senha)); //buscando no BD $q = \_db::query('SELECT * FROM ' . $this->setup['table'] . ' WHERE UPPER(' . $this->setup['col_login'] . ')="' . $login . '" AND ' . $this->setup['col_pass'] . '="' . $senha . '" AND ' . $this->setup['col_active'] . '="S"', $this->setup['db']); if ($q) { //carregando TODOS os dados para acesso rápido foreach ($q[0] as $k => $v) { $this->{$k} = $v; $_SESSION['DB'][$k] = $v; } $this->setup['login'] = true; $_SESSION['login'] = true; $_SESSION['life_time'] = $this->setup['life'] + time(); return true; } else { return false; } }