Connecting to a MySQL Database Using CGI/Perl
Print this Article
Comment on this Article
Last Updated:
May 29, 2008 11:33 AM
This example describes using CGI/Perl to connect to a MySQL Database.
#!/usr/bin/perl -T
print "ContentType: text/html";
use DBI;
# Connecting to the database
# Replace DATABASENAME with the name of the database,
# HOSTNAME with the hostname/ip address of the MySQL server.
$drh = DBI->install_driver("mysql");
$dsn = "DBI:mysql:database=your_databasename;host=mysql.secureserver.net";
$dbh = DBI->connect($dsn,"your_dbusername","your_dbpassword");
# Select the data and display to the browser
my $sth = $dbh->prepare("SELECT * FROM customers");
$sth->execute();
while (my $ref = $sth->fetchrow_hashref()) {
print "Found a row: id = $ref->{'id'}, name = $ref->{'name'}";
}
$sth->finish();
# Disconnect from the database.
$dbh->disconnect();
print "ContentType: text/html";
use DBI;
# Connecting to the database
# Replace DATABASENAME with the name of the database,
# HOSTNAME with the hostname/ip address of the MySQL server.
$drh = DBI->install_driver("mysql");
$dsn = "DBI:mysql:database=your_databasename;host=mysql.secureserver.net";
$dbh = DBI->connect($dsn,"your_dbusername","your_dbpassword");
# Select the data and display to the browser
my $sth = $dbh->prepare("SELECT * FROM customers");
$sth->execute();
while (my $ref = $sth->fetchrow_hashref()) {
print "Found a row: id = $ref->{'id'}, name = $ref->{'name'}";
}
$sth->finish();
# Disconnect from the database.
$dbh->disconnect();