Please guide me. Here is my .pm

If that is your .pm, it is incomplete -- this is not the beginning

Also, the code you posted features a suspiciously named variable $q ... I've seen others use CGI; inside Dancer ... backwards if thats what it is

Also, you seem to be using "session" keyword/helper, but then you're also using $dbh to query a database ... weird thing to do ... normally you'd configure a Dancer2::Session::DBIC backend and then "session" keyword/helper just does that for you