in reply to DBI question
my $obj = CLASSNAME->new( -server => "mysql:server=xxxx;database=xxxx", -user => "xxxx", -pass => "xxxx" );
#!/usr/bin/perl -w use strict; use DBI; use DBD::mysql; my $dbh = DBI->connect("dbi:mysql:server=somedomain.com;database=main_ +DB", "USER","PASSWD") or die "Failed to connect to the database!"; my $sth = $dbh->prepare( qq{ SQL } ); $sth->execute(); my @column_headings = @{$sth->{NAME}}; while (my @row = $sth->fetchrow()) { # Data elements $row[0] ... $row[$#row-1] ... } $sth->finish; $dbh->disconnect;
|
|---|