Select, Execute, and Fetch a Row as a Hash : select « Database « Perl






  1. Perl
  2. Database
  3. select

Select, Execute, and Fetch a Row as a Hash

   

use DBI;

$dbh=DBI->connect(qq(DBI:mysql:database=sample_db;user=root;password=)) or die "Can't connect";

$sth=$dbh->prepare("SELECT name FROM employee") ;

$sth->execute();
$count=0;

while(  my $row = $sth->fetchrow_hashref()){
    print "Name:    $row->{name}\n";
    $count++;
}

print "There are $count rows in the sample database.\n";
$sth->finish();
$dbh->disconnect();








Related examples in the same category

1.Select, Execute, and Dump the Results
2.Select, Execute, and Fetch a Row as an Array
3.Simple query
4.The First SQL Query
5.Using a Placeholder
6.Creating a Web Page Integrated with SQL Data
7.Creating an HTML Table