This example describes using CGI/Perl to connect to a MySQL Database.
#!/usr/bin/perl use cPanelUserConfig;
print "ContentType: text/html\n\n";
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'}";
}
Pay less for website domain names. Register your own .com, .net or .org
for as low as $10.18 per year. We have everything you need to get online
with your new domain.
For as little as $3.89 per month you can build your Website online with
Website Builder using our easy to use professional templates.
Play Video -
Demo
Everything needed to give your website the high-performance home it
deserves. Protect transactions and secure your customer's data
with a SSL Certificate