my $sth = $dbh->prepare(<<sqlend

   insert into url_connect (sourceIP, dt, tm, remoteIP)
                    values (?, ?, ?, ?)
sqlend

# and then:
$sth->execute($sourceIP, $date, $time, $targetIP);

# and again:
$sth->execute($sourceIP2, $date2, $time2, $targetIP2);