Re: Perl and DBI and CGI

Replies are listed 'Best First'.
Re^2: Perl and DBI and CGI by sOKOle (Acolyte) on Jun 23, 2005 at 13:19 UTC
Dear monkey_boy ! Thank you, Much better, but I have no idea how to improve formating and assign fields to the variables: $Name and $Email. In other words, how to make `print "<font color=\"red\"> $Name"; print "<font color=\"ble\"> $Email";` [download] Regards, sOKOle	[reply] [d/l]
Re^3: Perl and DBI and CGI by monkey_boy (Priest) on Jun 23, 2005 at 13:26 UTC
You would be better specifying the column names in the sql, thus would be able to help you more, also dont forget to close your font tags , something like this: `my $ref = $dbh->selectall_arrayref(" select name , email , age from users ") \|\| die $dbh->errstr; foreach my $person (@{$ref}) { my ($name,$email,$age) = @{$person}; print "<font color=\"red\" > $name </font>"; print "<font color=\"blue\"> $email </font>"; };` [download] This is not a Signature...	[reply] [d/l]
Re^4: Perl and DBI and CGI by sOKOle (Acolyte) on Jun 23, 2005 at 13:53 UTC
monkey_boy, your script works, but main problem re-occured When I have "Dr. John Bull" field it prints "Dr." only... could you solve ?	[reply]
Re^5: Perl and DBI and CGI by monkey_boy (Priest) on Jun 23, 2005 at 14:26 UTC
Re^6: Perl and DBI and CGI by sOKOle (Acolyte) on Jun 27, 2005 at 13:30 UTC
Some notes below your chosen depth have not been shown here
Re^3: Perl and DBI and CGI by sapnac (Beadle) on Jun 23, 2005 at 13:27 UTC
Hi! Check if this is helps... `$query = "SELECT Name, Email FROM users"; $sth = $dbh->prepare($query); $sth->execute(); while($Name,$Email) = $sth->fetchrow_array){ print "$Name, $Email";} $sth->finish(); $dbh->disconnect;` [download]	[reply] [d/l]
Re^4: Perl and DBI and CGI by fmerges (Chaplain) on Jun 24, 2005 at 12:49 UTC
Hi, The code is right, but using arrayref is more efficient/faster, consider it if you have a lot of data. Regards, ;-)	[reply]
Re^4: Perl and DBI and CGI by sOKOle (Acolyte) on Jun 23, 2005 at 14:05 UTC
Sorry, it does not help.	[reply]
Re^5: Perl and DBI and CGI by sapnac (Beadle) on Jun 23, 2005 at 15:06 UTC
Re^6: Perl and DBI and CGI by Anonymous Monk on Jun 24, 2005 at 12:04 UTC
Re^3: Perl and DBI and CGI by blazar (Canon) on Jun 23, 2005 at 13:23 UTC
Hint: use alternate delimiters, e.g. `qq\|"$whatever"\|`.	[reply] [d/l]


Think about Loose Coupling
	PerlMonks