use LWP::Simple; use DBI; $url = "http://weather.unisys.com/satellite/sat_ir_west.gif"; $file = "/usr/home/mhearse/weather_images/sat_ir_west.gif"; $newfile = "/usr/home/mhearse/weather_images/latest.gif"; ($min, $hour, $day, $month, $year) = (localtime)[1,2,3,4,5]; $image_name = "$month-$day-$year-$hour:$min"; getstore($url, $file); if (-s $file != -s $newfile) { rename $file, $newfile; $img_data = getFile($newfile); $dbh = DBI->connect("dbi:mysql:weather_images", "user", "********") or die("Error! $!\nAborting"); $sql = qq(INSERT INTO gw_ir (image_name, image_file) VALUES ("$image_name", "$image_file")); $sth = $dbh->prepare($sql); $sth->execute or die("\nError executing SQL statement! $DBI::errstr"); $dbh->disconnect; } else { print "file is current\n"; } sub getFile { my($file) = @_; my $fh; unless (open $fh, "<", $file) { die "Error opening $file : $!\n"; } my $data; { local $/ = undef; $data = <$fh>; } close $fh; return $data; }