[thelist] Perl & Unix epoch

CDitty mail at redhotsweeps.com
Sun Apr 7 00:28:00 CST 2002

Found it.  For those that don't know, you can just use $epochTime =
time;.  Go figure.  :)

I have 2 other problems if anyone has the time to troubleshoot.  I am
trying to right a perl program that hits my database. In the program below,
when it is run, I get the error "TERM environment variable not set. ".  I
did a google search, but it looks like most pointed to using this on the
command line.  Any idea?

My other problem.is getting the output to display.  I had this running
several months ago, but I didn't retain enough to make it work again.  Anyone?




use DBI;

$num_active = 10; # number of threads to show
$twentyfourhours = 24*60*60; # Last 24 hours in seconds
$epochTime = time; # Unix Epoch Time
$date1 = $epochTime - $twentyfourhours;

my $dbh = DBI->connect("dbi:mysql:database", "userid", "password") or
die("Failed to connect to Database");

my $sth = $dbh->prepare('select threadid, title from thread where
lastpost > $date1 and forumid <> 34 order by lastpost desc limit
$num_active') or die "Cant executer SQL statement: $DBI::errstr\n";


print "Content-type: text/html\n\n";

  while(my $sysname = <>) {

   my @data;
   chomp $sysname;

   $sth->execute($sysname) or die "Can't execute SQL statement:$DBI::errstr\n";
   print "ifDescr\tifInOctets\tifOutOctets\n";
   my @row;
    while (@row = $sth->fetchrow_array( )) {
      print " @row[0]\t$row[1]\n";

   if($sth->rows == 0) {
     print "No Match for `$sysname`.\n\n";

   print "\n";

$dbh->disconnect or warn "Error disconnecting: $DBI::errstr\n";

More information about the thelist mailing list