statement handles (dbi)

[opensourcer]

This node falls below the community's threshold of quality. You may see it by logging in.

[Zaxo]

A DBI statement handle is an object that represents a database query, usually an SQL statement. You obtain a statement handle from one of its constructors, prepare or prepare_cached. Those constructors are methods of a connection handle, since the statement handle must depend on a particular db connection.

A statement handle's execute method causes the statement to be run by the server, and there are a variety of fetch methods to obtain the results of the query.

[chargrill]

What is it in the documentation and examples provided by the respective modules is it that you don't understand?

Do you have a more specific question?

[opensourcer]

use DBmanager qw ($dbh $table);

sub tableinfo
{
    my ($dbh, $table) = @_;

    $table = "download";
    
    my $sth = $dbh->prepare("QUERY");

    my $tables = $sth->{'NUM_OF_FIELDS'};

    print Dumper($tables);
}

&tableinfo ($dbh, $table);

output : $VAR1 = undef;
may be im doing somewhere wrong, i hoping for an sample code.

[chargrill]

What's "DBmanager"?

I'm used to seeing database code like this (for mysql):

use DBI;

my $dbh = DBI->connect( "DBI:mysql:database=test;host=localhost",
  "username", "password" );

my $sth = $dbh->prepare( 'select * from table_foo' );

$sth->execute();

my $numrecords = $sth->rows;

my $numfields = $sth->{'NUM_OF_FIELDS'};

$sth->finish;

print "I found $numrecords records, each having $numfields fields.\n";

Please note, I took this example code directly from the documentation. It makes sense to me - is there something you have a question about that the documentation doesn't answer?