Beefy Boxes and Bandwidth Generously Provided by pair Networks
We don't bite newbies here... much
 
PerlMonks  

Answer: How do I pass a database handle in DBI between subroutines?

by lhoward (Vicar)
on Aug 09, 2000 at 21:33 UTC ( #27115=categorized answer: print w/replies, xml ) Need Help??

Q&A > database programming > How do I pass a database handle in DBI between subroutines? - Answer contributed by lhoward

Just like you would any other object... See my example below showing passing a database handle in and out of 2 functions.
my $dbh=bar(); foo($dbh); sub foo{ my $dbh=shift; # do something with the database handle.... } sub bar{ my $dbh=DBI->connect(...... return $dbh; }

  • Comment on Answer: How do I pass a database handle in DBI between subroutines?
  • Download Code
Log In?
Username:
Password:

What's my password?
Create A New User
Chatterbox?
[Corion]: Meh, I found another Amazon "used" scam reseller... If a product sells for "almost new" at half the price, it's a scam, most likely...
[ambrus]: Corion: that's not true. Actually for Christmas and Thanksgiving, a lot of people buy electronics such as cameras as present, then many of them figure out they don't need it,
[ambrus]: and the electronics gets reselled almost new, but it has to be sold at half price because otherwise everyone chooses to buy the new product which has fewer risk of selling damaged products labelled as almost new.
[ambrus]: You can actually get a lot of useful cheap really almost new products that way, with only a little risk of scams.

How do I use this? | Other CB clients
Other Users?
Others chanting in the Monastery: (15)
As of 2017-11-21 14:57 GMT
Sections?
Information?
Find Nodes?
Leftovers?
    Voting Booth?
    In order to be able to say "I know Perl", you must have:













    Results (304 votes). Check out past polls.

    Notices?