Name
fetchall_arrayref
Synopsis
$tbl_ary_ref = $sth->fetchall_arrayref; $tbl_ary_ref = $sth->fetchall_arrayref( $slice_array_ref ); $tbl_ary_ref = $sth->fetchall_arrayref( $slice_hash_ref );
The
fetchall_arrayref
method can be used to fetch all the data to be returned from a
prepared and executed statement handle. It returns a reference to an
array that contains one reference per row.
If there are no rows to return, fetchall_arrayref
returns a reference to an empty array. If an error occurs,
fetchall_arrayref
returns the data fetched thus
far, which may be none. You should check
$sth-
>err
afterwards (or use
the RaiseError
attribute) to discover if the data
is complete or was truncated due to an error.
When passed an array reference, fetchall_arrayref
uses fetchrow_arrayref
to fetch each row as an
array ref. If the parameter array is not empty, then it is used as a
slice to select individual columns by index number.
With no parameters, fetchall_arrayref
acts as if
passed an empty array ref.
When passed a hash reference, fetchall_arrayref
uses fetchrow_hashref
to fetch each row as a hash
reference. If the parameter hash is not empty, then it is used as a
slice to select individual columns by name. The names should be lower
case regardless of the letter case in
$sth-
>{NAME}
. The values of
the hash should be set to 1
.
For example, to fetch just the first column of every row:
$tbl_ary_ref = $sth->fetchall_arrayref([0]);
To fetch the second to last and last column of every row:
$tbl_ary_ref ...
Get Programming the Perl DBI now with the O’Reilly learning platform.
O’Reilly members experience books, live events, courses curated by job role, and more from O’Reilly and nearly 200 top publishers.