> Which one of these would be best equipped for SQL database
> work/designs? If one is a webmaster or webmaster in
> training, which language would have the best means for
> creating and marinating a dynamic database driven web site?
> I'm thinking in particular of a mysql database to create a
> dynamic database driven web site and application.
>
Perl by a land slide! Perl land mysql are great bed fellows, I use them everyday!
> I could use some tools/tutorials for learning about Perl
> Modules... also how to use perl for the above mentioned
> tasks, specifically mysql. Thanks so much, Bruce
perldoc DBI will help tons!!!
Here's a simple example, it doesn't do any error/input checking so you'll want to do
that.
#!/usr/bin/perl -w
use strict;
use DBI;
use CGI qw(:standard);
print header();
my $dbh = DBI->connect('mysql:database:localhost','user','pass');
my $name = $dbh->quote(param('name'));
my $email = $dbh->quote(param('email'));
if($dbh->do("INSERT INTO mytable VALUES(NULL,NOW(),$name,$email")) {
print "Added record ok";
} else { print "Couldn't add the record"; }
$dbh->diconnect;
--
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]
