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();
+