$dbh = DBI->connect('dbi:mysql:Database','root','password')
or die "Connection Error: $DBI::errstr\n";

my $sth = $dbh->prepare("insert into studenttbl(fname, lname, grade, DOB, email, tel_no, membertype, username) values ('$fname','$lname','$grade','$DOB','$email', '$tel_no', '$membertype', '$username') "); 
$sth->execute();
my $sth2 = $dbh->prepare("insert into logintbl(username, password) values('$username', '$password') ");
print "Content-type: text/html\n\n";
print "<h1> thanks for registering </h1>";
}