Accessing your MySQL database with Perl

The Perl module, DBI.pm is a convenient way to connect to the database from within Perl scripts. Please read the documentation about DBI.pm. Full documentation for the Perl module use is available from: http://search.cpan.org/doc/JWIED/Msql-Mysql-modules-1.2214/mysql/lib/DBD/mysql.pm

Here are the basics of connecting: (Please be advised that we can not support your custom programming or scripts)

Note: substitute the following values in the script below:
$hostname = the database server (i.e. www.jpworld.com), $database = the new database (named after your username), $user = your username and $password = the password you set.

use DBI;
$driver = "mysql";
$dsn = "DBI:$driver:database=$database;host=$hostname";
$dbh = DBI->connect($dsn, $user, $password);

Please see the documentation referenced above for more information.

back

Copyright © 1997 - 2012 JP's High Tech World, Inc. All rights reserved.

Home | Web site design | Web Hosting | Support | Contact us