Thread MySQL und Perl
(71 answers)
Opened by H3llGhost at 2007-10-14 17:05
Den Fehler habe ich ja nun gefunden, aber ich poste gerne den ebend auch noch:
Code (perl): (dl
)
1 2 3 4 5 6 7 $db_conn = DBI->connect( "DBI:mysql:$db_name:$db_host", $db_user, $db_pass ) or die ("\nCan't connect to MySQL database '$db_name' on '$db_host'\n" . "Server error: $DBI::errstr\n"); &printEvent("MYSQL", "Connecting to MySQL database '$db_name' on '$db_host' as user '$db_user' ... connected ok", 1) Und hier der doquery: Code (perl): (dl
)
1 2 3 4 5 6 7 8 sub doQuery { my ($query, $callref) = @_; my $result = $db_conn->prepare($query) or die("Unable to prepare query:\n$query\n$DBI::errstr\n$callref"); $result->execute or die("Unable to execute query:\n$query\n$DBI::errstr\n$callref"); return $result; } |