Frequently Asked Questions

Help Center Search

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();