#! /usr/bin/perl
use warnings;
use strict;
use feature qw'say';
use DBI;
my ($link_id, $events_item, $events_type, $events_longdesc, $starttime, $endtime,
$location, $who, $note, $extra,
%skedhash, $skedhash); # %skedhash & $skedhash declared!
my $FH_out;
# get data from db # LN12
... (irrelevant)
$select->execute or die $DBI::errstr;
# Create html #LN27
# ... (irrelevant)
sub sked { #LN44
no warnings "uninitialized";
%skedhash = @_;
say "In sub 'sked'";
say "LN50: \$link_id, \$events_item, \$events_type, \$starttime,
\$endtime, \$location, \$who, \$note, \$extra: $skedhash{'link_id'},
$skedhash{'events_item'}, $skedhash{'starttime'}, $skedhash{'endtime'},
$skedhash{'where'}, $skedhash{'who'}, \n $skedhash{'note'}, \n
$skedhash{'extra'} $skedhash{'events_longdesc'} \n";
if ($skedhash{'who'} ne '') {
$skedhash{'who'} = 'Hosted by ' . $skedhash{'who'};
}
print $FH_out "
$skedhash{'$events_item'}
$skedhash{'$events_type'} $skedhash{'who'}
$skedhash{'starttime'} - $skedhash{'endtime'}
$skedhash{'location'} |
$skedhash{'events_longdesc'} |
";
use warnings "all";
}
### END sub sked() ########
my $sql = qq/SELECT events.link_id, events.item, events.type, events.longdesc,
times.starttime, times.endtime, times.location, times.who,
times.note, times.extra
FROM events, times
WHERE events.link_id = times.link_id
ORDER BY starttime/;
# LN65
my $sth = $db->prepare($sql); # LN66
$sth->execute();
while ( my ($events_link_id, $events_item, $events_type, $events_longdesc,
$starttime, $endtime, $location, $who, $note, $extra)
= $sth->fetchrow_array ) {
my %skedrow = (
'events_link_id' => $events_link_id,
'events_item' => $events_item,
'events_type' => $events_type,
'events_longdesc' => $events_longdesc,
'starttime' => $starttime,
'endtime' => $endtime,
'location' => $location,
'who' => $who,
'note' => $note,
'extra' => $extra
);
....