Re: Clean Up MySQL Code

by DrManhattan (Chaplain)

on Apr 20, 2003 at 15:31 UTC ( #251831=note: print w/replies, xml )

Need Help??

You can reduce three of your lines to one by using selectall_arrayref() like so:

my $results = $dbh->selectall_arrayref(
   "SELECT * FROM shop_items", { Slice => {} }
);
foreach my $hash_ref (@$results)
{
   # blah
}
[download]

If you want to write it as a subroutine, this would work:

sub fetch_data
{
    my $dbh = shift;
    return $dbh->selectall_arrayref(
       "SELECT * FROM shop_items", { Slice => {} }
    );
}
[download]

Then you could call it like this:

foreach my $hash_ref (@{&fetch_data($dbh)})
{
    # blah
}
[download]

-Matt

Comment on Re: Clean Up MySQL Code Select or Download Code

Domain Nodelet^?

Node Status^?

node history
Node Type: note [id://251831]
help

Chatterbox^?

How do I use this? • Last hour • Other CB clients

Other Users^?

Others having an uproarious good time at the Monastery: (7)

As of 2023-12-06 16:38 GMT

Sections^?

Information^?

Find Nodes^?

Leftovers^?

Voting Booth^?

Notices^?