Mercurial > hg > extraction-interface
diff _xampp/contrib/testperldbi.pl @ 0:b12c99b7c3f0
commit for previous development
author | Zoe Hong <zhong@mpiwg-berlin.mpg.de> |
---|---|
date | Mon, 19 Jan 2015 17:13:49 +0100 |
parents | |
children |
line wrap: on
line diff
--- /dev/null Thu Jan 01 00:00:00 1970 +0000 +++ b/_xampp/contrib/testperldbi.pl Mon Jan 19 17:13:49 2015 +0100 @@ -0,0 +1,21 @@ +#!/opt/lampp/bin/perl +use DBI; + +my $dsn = 'DBI:mysql:cdcol:localhost'; +my $db_user_name = 'root'; +my $db_password = ''; +my ($id, $password); +my $dbh = DBI->connect($dsn, $db_user_name, $db_password); + +my $sth = $dbh->prepare(qq{ + SELECT id,titel,interpret,jahr FROM cds ORDER BY interpret; +}); +$sth->execute(); + +while (my ($id, $title, $interpret, $jahr ) = + $sth->fetchrow_array()) +{ + print "$title, $interpret\n"; +} +$sth->finish(); +