Thread Perl Problem Code (48 answers)
Opened by zeus75 at 2006-07-18 10:52

GwenDragon
 2006-07-19 16:47
#8372 #8372
User since
2005-01-17
14835 Artikel
Admin1
[Homepage]
user image
Code: (dl )
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
use CGI::Carp qw(fatalsToBrowser);
use CGI::Cookie;
use DBI;
use CGI;

my $db = DBI->connect( 'dbi:mysql:usr_web41_1', 'web41', 'xxxxxx') ||
   die "Kann keine Verbindung zum MySQL-Server aufbauen: $DBI::errstr\n";

my %cookies = fetch CGI::Cookie;
my $userinfo;

if(check_login() && not validate_login() ) {
 logout_user();
}
else {
 my $sth = $db->prepare("SELECT * FROM sites WHERE webmaster_email=? AND webmaster_url=? LIMIT 1")
        or die( "cant prepare SQL: $DBI::errstr");
 $sth->execute($cookies{'email'}, $cookies{'url'} )
        or die "Can't execute statement: $DBI::errstr";  
 $userinfo = $sth->fetchrow_hashref; # Hashreferenz!
}

#...
# später:

print 'URL: ', CGI::textfield( 'url', $userinfo->{'domain'} ),
CGI::br(),
'E-Mail: ', CGI::textfield( 'email', $userinfo->{'webmaster_email'} );


So, mehr geht heute nicht mehr.\n\n

<!--EDIT|GwenDragon|1153313295-->

View full thread Perl Problem Code