The script at the end of this note gets customer codes from a mysql database and displays them in a webpage. Each customer code has a consistent naming convention and I could use it to assess their internal webpage link and add it to the webpage. Can someone help me to get my script to make the link and add it to the page?
An example of a customer code is: Cand
I would like to modify my script to add the following link beside:
www.Cand_lin.comAny ideas?
#!/usr/bin/perl
use strict;
use CGI::Carp qw(fatalsToBrowser);
use CGI;
use DBI;
my $q = new CGI;
print $q->header;
my $dbh = DBI->connect("DBI:mysql:NA
VUSERS;loc
alhost",
"foms");
my $sth = $dbh->prepare("SELECT hostname FROM HomeHost where
UID = 0 order by hostname");
$sth->execute();
print "\tUser
Names:\n==================
==========
=========\
n";
while ( my @row = $sth->fetchrow_array()) {
print "@row\n";
}
exit;
$sth->finish;
$dbh->disconnect;
Start Free Trial
