my $id = $cgi->param('user_id'); my $query = $dbh->prepare("SELECT columns FROM users WHERE id = ?"); $query->execute($id);