Unable to print out intended text - just prints out the contents of .pl file.

[Markus]

I'll leave out the annoying 'i'm a newbie' speech and get to the point: i'm a newbie at perl ;)

First thing i ever wrote in perl and it doesnt work.

I'm using xampp as my localhost - with perl installed on that. When i run this (http://localhost/mysql.pl) it just prints out the contents of the file and not an array if the databases...

Enlighten me, oh gods of perl

#!"C:\xampp\perl\bin\perl.exe"
 
# PERL MODULE WE WILL BE USING
use Mysql;
 
# HTTP HEADER
print "Content-type: text/html \n\n";
 
# MySQL CONFIG VARIABLES
$host = "localhost";
$database = "...";
$tablename = "...";
$user = "...";
$pw = "...";
 
# PERL MYSQL CONNECT
$connect = Mysql->connect($host, $database, $user, $pw);
 
# LISTDBS()
@databases = $connect->listdbs;
foreach $database (@databases) {
    print "$database<br />";
}
 

[numberwhun]

I'll leave out the annoying 'i'm a newbie' speech and get to the point: i'm a newbie at perl ;)

First thing i ever wrote in perl and it doesnt work.

I'm using xampp as my localhost - with perl installed on that. When i run this (http://localhost/mysql.pl) it just prints out the contents of the file and not an array if the databases...

Enlighten me, oh gods of perl

#!"C:\xampp\perl\bin\perl.exe"
 
# PERL MODULE WE WILL BE USING
use Mysql;
 
# HTTP HEADER
print "Content-type: text/html \n\n";
 
# MySQL CONFIG VARIABLES
$host = "localhost";
$database = "...";
$tablename = "...";
$user = "...";
$pw = "...";
 
# PERL MYSQL CONNECT
$connect = Mysql->connect($host, $database, $user, $pw);
 
# LISTDBS()
@databases = $connect->listdbs;
foreach $database (@databases) {
    print "$database<br />";
}
 

If it is printing the contents of the Perl file, instead of executing it, then either the web sever you are using is setup to ONLY execute .cgi files, or not setup to serve CGI at all. You need to figure that out.

Regards,

Jeff

[Markus]

Ahh, thought so. -_-

danke

[eWish]

Since you are a complete newbie, now is the time to learn good coding practices :).

CGI.pm
Declare your variables
Pragmas strict & warnings

Also bookmark perldoc.perl.or g

--Kevin

[Markus]

Since you are a complete newbie, now is the time to learn good coding practices :).

CGI.pm
Declare your variables
Pragmas strict & warnings

Also bookmark perldoc.perl.or g

--Kevin

I'm on it!

Just as soon as i can get this xampp / perl thing sorted ¬_¬

[numberwhun]

I'm on it!

Just as soon as i can get this xampp / perl thing sorted ¬_¬

Ok, first, from the xampp page, here is the link that shows where the configuration files are located. You will specifically need the one for apache.

Once you have that, then you can follow the apache configuration for configuring cgi.

Personally though, I would first try changing the extension of my perl script to ".cgi" instead of ".pl" and see if it is already configured for that.

Regards,

Jeff