Beefy Boxes and Bandwidth Generously Provided by pair Networks
Just another Perl shrine
 
PerlMonks  

Re^3: statement handles (dbi)

by chargrill (Parson)
on Nov 22, 2006 at 07:28 UTC ( [id://585459]=note: print w/replies, xml ) Need Help??


in reply to Re^2: STATEMENT HANDLES
in thread statement handles (dbi)

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?



--chargrill
s**lil*; $*=join'',sort split q**; s;.*;grr; &&s+(.(.)).+$2$1+; $; = qq-$_-;s,.*,ahc,;$,.=chop for split q,,,reverse;print for($,,$;,$*,$/)

Log In?
Username:
Password:

What's my password?
Create A New User
Domain Nodelet?
Node Status?
node history
Node Type: note [id://585459]
help
Chatterbox?
and the web crawler heard nothing...

How do I use this?Last hourOther CB clients
Other Users?
Others drinking their drinks and smoking their pipes about the Monastery: (2)
As of 2024-04-19 20:47 GMT
Sections?
Information?
Find Nodes?
Leftovers?
    Voting Booth?

    No recent polls found