- 论坛徽章:
- 0
|
一:我曾经实验过的一段:- $db_dsn = "DBI:mysql:$db_dat;host=$db_hst;port=$db_prt";
- $dbh=DBI->connect($db_dsn, $db_usr, $db_pas)
- or die("Failed to connect: $DBI::errstr\n");
- print "HOST: $db_hst, SERV: $db_ser, BY $db_usr", "\n\n";
- $sth=$dbh->prepare("select * from $db_tbl");
- $sth->execute;
- while(@row = $sth->fetchrow_array){
- $fmt .= "%-10s" while $i++ <= $#row;
- $str = sprintf $fmt, @row;
- print "$str\n";
- }
- print "\n***Selected***\n";
- $sth->finish;
- $dbh->disconnect();
复制代码 二:$s = "adcdadbbdacdaadabddaidrd";
$c = $s =~ tr/d//; |
|