my $query = 'INSERT INTO datum (bestelldatum, expire, any_column) VALUES( now(), adddate(now(), interval 1 year), ?)';
my @query_data = ( $userinput );
$dbh->do($query, undef, @query_data);