Xampp, perl, mysql

[rj12a]

Ok, so im trying to get perl working with xampp and Mysql heres the code i have, just doing a simple listing of tables.

Code: Select all

#!/usr/bin/perl

use Mysql;
#use strict;
print "Content-type: text/html \n\n";
#prevent Perl from creating undeclared variables
#not used
#my($host, $database, $tablename, $user, $pw, $connect, $db, $table);
#my(@tables);

# MYSQL CONFIG VARIABLES
$host = "localhost";
$database = "reg_perl";
$tablename = "tblcontacts";
$user = "username";
$pw = "password";

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

# SELECT DB
$connect->selectdb($database);

# LISTTABLES()
@tables = $db->listtables;

# PRINT EACH TABLE NAME
@tables = $connect->listtables;
foreach $table (@tables) {
   print "$table<br />";
}

despite that i get this error when running it

Code: Select all

Can't locate Mysql.pm in @INC (@INC contains: /Applications/XAMPP/xamppfiles/lib/perl5/site_perl/5.10.0//darwin-2level /Applications/XAMPP/xamppfiles/lib/perl5/site_perl/5.10.0/ /Applications/XAMPP/xamppfiles/lib/perl5/5.10.0/darwin-2level /Applications/XAMPP/xamppfiles/lib/perl5/5.10.0 /Applications/XAMPP/xamppfiles/lib/perl5/site_perl/5.10.0/darwin-2level /Applications/XAMPP/xamppfiles/lib/perl5/site_perl/5.10.0 . /Applications/XAMPP/xamppfiles) at /Applications/XAMPP/xamppfiles/htdocs/perl/perl_reg_sql/registration.pl line 5. BEGIN failed--compilation aborted at /Applications/XAMPP/xamppfiles/htdocs/perl/perl_reg_sql/registration.pl line 5. ,


this line here though is close, its just in /DBD, is there any fix for this? I dont know where to even start

Code: Select all

/Applications/XAMPP/xamppfiles/lib/perl5/site_perl/5.10.0//darwin-2level

Any help would be appreciated thanks

[jmdirc]

if your looking for Perl in xampp - isn't this line mis-directing

Code: Select all

#!/usr/bin/perl

shouldn't it be

Code: Select all

#!/Applications/XAMPP/xamppfiles/var/perl/

and should you place your .pl files in htdocs - the call in the terminal will be: /Applications/XAMPP/xamppfiles/htdocs/

works fine here

[rj12a]

they are in htdocs, and i have already tried it with both shebang lines, neither works, i get the same error. Regular .pl files work just fine, its when it try to use the mysql there is a problem

[Wiedmann]

Code: Select all

use Mysql;

Can't locate Mysql.pm in @INC

You have a Mysql module somewhere?