Пример #1
0
 function delete()
 {
     if (is_null($this->id)) {
         return false;
     }
     //....
     \_db::query('');
 }
Пример #2
0
 /**
  * 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;
 }
Пример #3
0
    /**
     * 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;
        }
    }