Query a database and display the contents in a table : ODBC « Database « Perl






  1. Perl
  2. Database
  3. ODBC

Query a database and display the contents in a table

   

#!/usr/bin/perl


use warnings;
use strict;
use DBI;
use DBD::ODBC;

my $dbh = DBI->connect( "DBI:ODBC:employeeDB", "", "" ) or die( "Could not make connection to database: $DBI::errstr" );

my $sth = $dbh->prepare( q{ SELECT * FROM employee } ) or die( "Cannot prepare statement: ", $dbh->errstr(), "\n" );
     
my $rc = $sth->execute() or die( "Cannot execute statement: ", $sth->errstr(), "\n" );

my @array;

while ( @array = $sth->fetchrow_array() ) {
   write();
}

warn( $DBI::errstr ) if $DBI::err;

$sth->finish();
$dbh->disconnect();

format STDOUT =  
@<<<<<<@<<<<<<<<<@<<<<<<<<<<@<<<<<@<<<<<<<<<<<<
$array[ 0 ], $array[ 1 ], $array[ 2 ], $array[ 3 ], $array[ 4 ]

.








Related examples in the same category

1.DBI ODBC
2.Delete a record from the database
3.Delete statement and DBI ODBC connection
4.Insert statement with DBI connection
5.Program to insert a new record into the database