Greetings --
What I'm trying do here is generate a html table using
CGI + Mysql?
--Thanks David
#!/bin/perl -w
use DBI;
use diagnostics;
use strict;
use CGI::Pretty qw(:all);
my ($dbh,$sth);
my ($dbname)="test";
my ($login)="who_am_i";
my ($password) ="secret_word";
my ($query);
my ($cl_first_name);
# Define query
$query=qq(SELECT cl_first_name from client);
#
$dbh = DBI->connect("DBI:mysql:$dbname",$login,$password)
or die "Can't connect to $dbh: $dbh->errstr\n";
$sth = $dbh->prepare("$query")
or die "Can't connect to $dbh: $sth->errstr\n";
$sth-> execute()
or die "Can't connect to $dbh: $sth->errstr\n";
print start_html({-title=>"CGI Table"});
print table(
while (($cl_first_name) = $sth -> fetchrow_array())
{
Tr([td([$cl_first_name])])
}
);
$dbh->disconnect();
print end_html;
Title =~ s/GGI/CGI/; - 2002-02-24 dvergin
-
Are you posting in the right place? Check out Where do I post X? to know for sure.
-
Posts may use any of the Perl Monks Approved HTML tags. Currently these include the following:
<code> <a> <b> <big>
<blockquote> <br /> <dd>
<dl> <dt> <em> <font>
<h1> <h2> <h3> <h4>
<h5> <h6> <hr /> <i>
<li> <nbsp> <ol> <p>
<small> <strike> <strong>
<sub> <sup> <table>
<td> <th> <tr> <tt>
<u> <ul>
-
Snippets of code should be wrapped in
<code> tags not
<pre> tags. In fact, <pre>
tags should generally be avoided. If they must
be used, extreme care should be
taken to ensure that their contents do not
have long lines (<70 chars), in order to prevent
horizontal scrolling (and possible janitor
intervention).
-
Want more info? How to link
or How to display code and escape characters
are good places to start.
|