mysql> use test Reading table information for completion of table and column names You can turn off this feature to get a quicker startup with -A Database changed mysql> show tables; +----------------+ | Tables_in_test | +----------------+ | items | | name | | news | | user | +----------------+ 4 rows in set (0.00 sec) mysql> select * from items; +---------+---------+-------+ | item_id | name | price | +---------+---------+-------+ | 1 | U+1F363 | NULL | +---------+---------+-------+ 1 row in set (0.00 sec)
#!/usr/bin/perl --
use CGI;
use DBI;
print "Content-type:text/html\n\n";
print "hello";
my $user = 'root';
my $passwd = '';
my $db = DBI->connect('DBI:mysql:test:localhost', $user, $passwd);
my $sth = $db->prepare("select * from items;");
$sth->execute();
while (my $ary_ref = $sth->fetchrow_arrayref){
my($a, $b) = @$ary_ref;
print "$a, $b\n";
}
$sth->finish;
$dbh->disconnect;

OKなんだけど、これ、tableで表示するとき、whileが2つになるけど、どうするんだっけ?
print "<table>";
while (my $ary_ref = $sth->fetchrow_arrayref){
my($a, $b) = @$ary_ref;
print "<tr><td>$a</td><td>$b</td></tr>\n";
}
print "</table>";
tableはtableで良いんだが。。