Hi,


Please can any one tell me how to connect the mysql to perl script becoz am using the active perl with mysql . pls try to give the correct command.


Thanks
Deepa

perlmysqlconnect.pl:

#!/usr/bin/perl

# PERL MODULE
use Mysql;

# HTTP HEADER
print "Content-type: text/html \n\n";

# CONFIG VARIABLES
$host = "localhost";
$database = "store";
$tablename = "inventory";
$user = "username";
$pw = "password";

# PERL MYSQL CONNECT
$connect = Mysql->connect($host, $database, $user, $pw);

that was on the tutorial , just google for more info

I'd strongly recommend using DBI along with DBD::mysql. Example of connecting here.

The Mysql module is an obsolete interface and you should not use it in new code. Source.

This is the danger of just copying and pasting random crap off the web. CPAN (which I linked to above) always has the latest versions of modules and has the documentation straight from the authors. Why would you grab a random tutorial when the subject matter experts, the guys who wrote the module have the latest and greatest right in the docs?

I mean, aside from laziness.