class DB
{
    private $_dbh;
    private static $dsn  = 'mysql:host=localhost;dbname=lp;charset:UTF8';
    private static $user = 'root';
    private static $pass = '';
    private static $driver_options = array( PDO::MYSQL_ATTR_INIT_COMMAND => 'SET NAMES UTF8', PDO::ATTR_ERRMODE => PDO::ERRMODE_EXCEPTION );
    public function __construct()
    {
       $this->_dbh = new PDO(self::$dsn,self::$user,self::$pass, self::$driver_options);
    }
    public function query($query, $params = array())
    {
        $stmt = $this->_dbh->prepare( $query );
        if (!empty($params)){
            foreach ($params as $param_key=>$param_value){
                $stmt->bindValue($param_key, $param_value);
            }
        }
        $stmt->execute();
        return $stmt;
    }
    private function _fetch(){
        $params = array(':id'=> &$this->_userid);
        $query = "SELECT up.birthday, up.photo_thumb AS 'avatar',
        u.id, u.firstname, u.lastname, u.sex, u.bostadsort, u.user_level AS 'isadmin',
        u.last_access AS 'lastaccess', u.lastname AS 'fullname' FROM users u
        INNER JOIN users_profile up ON (up.uID = u.id)
         WHERE u.id=:id";
        $stmt = $this->_pdo->query($query, $params);
        $row = $stmt->fetch( PDO::FETCH_ASSOC );

     return $row;
    }
}