use DBI;
use strict;

my $user = $ENV{REMOTE_USER};
my $driver = 'mysql';
my $database = 'db';
my $dsn = "DBI:$driver:database=$database";
my $dbh = DBI->connect($dsn, 'user', 'password')
        or die $DBI::errstr;

my $result = $dbh->prepare("SELECT * FROM tablename WHERE username =?");
$result->execute($user);

my $row = $result->fetchrow_hashref;
my $engr     = $row->{engr};
my $team     = $row->{team_name};
my $position = $row->{team_position};
my $group    = $row->{grp};
my $level    = $row->{level};

$result->finish;
$dbh->disconnect;