fetchrow_array()与fetchrow_arrayref()与fetchrow_hashref()的使用方法

最新推荐文章于 2021-02-27 06:46:08 发布

高尔夫golf

最新推荐文章于 2021-02-27 06:46:08 发布

阅读量3.1k

点赞数

分类专栏： Perl

Perl 专栏收录该内容

81 篇文章 2 订阅

订阅专栏

fetchrow_array 作为一个字段数组取出下一行
fetchrow_arrayref 作为一个字段的引用数组取出下一行
fetchrow_hashref 作为一个哈希表的引用取出下一行

使用方法：

@row_ary = $sth->fetchrow_array;
$ary_ref = $sth->fetchrow_arrayref;
$hash_ref = $sth->fetchrow_hashref;

fetchrow_hashref 的使用

———————————————————————————————————————–

#!/usr/bin/perl
use DBI;
# Connect to target DB
my $dbh = DBI->connect( "DBI:mysql:database=mysql;host=172.1.1.232",
    "root", "enchanter", { ‘RaiseError’ => 1 } );
my $sql =$dbh->prepare("select user,password,host from user");
$sql->execute();
while ( my $ref = $sql->fetchrow_hashref() ) {
    print "$ref->{‘user’}\n";
    print "$ref->{password}\n";
    print "$ref->{host}";
}

$dbh->disconnect();

运行结果：

root
*740E81A1D1219B7E40E29162C81FACB5DE7CD223
localhostroot
*740E81A1D1219B7E40E29162C81FACB5DE7CD223
localhost.localdomainroot
*740E81A1D1219B7E40E29162C81FACB5DE7CD223
10.1.1.0/255.255.255.0www

%www
*FA5E54D0886179C17E82B2D63E9C9C04780AEEB7
172.1.0.0/255.255.0.0lichunwu
*740E81A1D1219B7E40E29162C81FACB5DE7CD223
%www
*D87AC37871FBBD7A9B23D87666C9CA53AF73FAF0
10.1.1.0/255.255.255.0neiwang
*B1F9386C2F6E30262ECC39C8DA2649D60B3C1DE7
%mobile
*6F4D8658D1795A94BD4A5B70854491EEA36BDF45
%liubo
*87B651BE4FF9E6814738DF70D32DCDBAC240EB80
%root
*740E81A1D1219B7E40E29162C81FACB5DE7CD223
172.1.0.0/255.255.0.0jiaqi
*F7F0680F63DFF8656D0A9CA9C92396724A48C6EC
%checker
*23AE809DDACAF96AF0FD78ED04B6A265E05AA257
%

———————————————————————————————————————–

fetchrow_array()的使用

#!/usr/bin/perl
use DBI;
# Connect to target DB
my $dbh = DBI->connect( "DBI:mysql:database=mysql;host=172.1.1.232",
    "root", "enchanter", { ‘RaiseError’ => 1 } );
my $sql =$dbh->prepare("select user,password,host from user");
$sql->execute();
while ( my @rows = $sql->fetchrow_array() ) {
    print "user:$rows[0]\n";
    print "password:$rows[1]\n";
    print "host:$rows[2]\n";
}

$dbh->disconnect();

运行结果：

user:root
password:*740E81A1D1219B7E40E29162C81FACB5DE7CD223
host:localhost
user:root
password:*740E81A1D1219B7E40E29162C81FACB5DE7CD223
host:localhost.localdomain
user:root
password:*740E81A1D1219B7E40E29162C81FACB5DE7CD223
host:10.1.1.0/255.255.255.0
user:www
password:
host:%
user:www
password:*FA5E54D0886179C17E82B2D63E9C9C04780AEEB7
host:172.1.0.0/255.255.0.0
user:lichunwu
password:*740E81A1D1219B7E40E29162C81FACB5DE7CD223
host:%
user:www
password:*D87AC37871FBBD7A9B23D87666C9CA53AF73FAF0
host:10.1.1.0/255.255.255.0
user:neiwang
password:*B1F9386C2F6E30262ECC39C8DA2649D60B3C1DE7
host:%
user:mobile
password:*6F4D8658D1795A94BD4A5B70854491EEA36BDF45
host:%
user:liubo
password:*87B651BE4FF9E6814738DF70D32DCDBAC240EB80
host:%
user:root
password:*740E81A1D1219B7E40E29162C81FACB5DE7CD223
host:172.1.0.0/255.255.0.0
user:jiaqi
password:*F7F0680F63DFF8656D0A9CA9C92396724A48C6EC
host:%
user:checker
password:*23AE809DDACAF96AF0FD78ED04B6A265E05AA257
host:%