Re: How to use MySQL from CGI?

[matthewb]

Can someone just give me a snippet on how to connect to a MySQL db from a website?

#!/usr/bin/perl -T

use warnings FATAL => 'all';
use strict;
use DBI;
use CGI;

my( $dsn, $username, $password ) = qw( you tell me );

my $dbh = DBI->connect( $dsn, $username, $password )
    or die DBI::errstr;

my $q = CGI->new;

print $q->header, $q->h1( "Looks like we connected to $dsn!" );

exit;

You have much reading to do.