Hello

Ive started learning perl development with dbi to mysql. I have managed to read from tables etc. i have now started reading abit on cgi on apache, and made a little script based on one i made before reading form the mysql. It just does not work, can anyone please help



The error i get is:


Global symbol "$string1" requires explicit package name at c:\PROGRA~1\APACHE~1\apache\cgi-bin\test.cgi line 12.
Global symbol "$sth" requires explicit package name at c:\PROGRA~1\APACHE~1\apache\cgi-bin\test.cgi line 13.
Global symbol "$dbh" requires explicit package name at c:\PROGRA~1\APACHE~1\apache\cgi-bin\test.cgi line 13.
Global symbol "$string1" requires explicit package name at c:\PROGRA~1\APACHE~1\apache\cgi-bin\test.cgi line 13.
Global symbol "$sth" requires explicit package name at c:\PROGRA~1\APACHE~1\apache\cgi-bin\test.cgi line 14.
Global symbol "$string1" requires explicit package name at c:\PROGRA~1\APACHE~1\apache\cgi-bin\test.cgi line 20.
Execution of c:\PROGRA~1\APACHE~1\apache\cgi-bin\test.cgi aborted due to compilation errors.





And my script is:



#!c:/perl/bin/perl

use DBI;
$dbh = DBI->connect('dbi:mysql:exelstock');
use CGI qw(:standard);
use CGI::Carp qw(warningsToBrowser fatalsToBrowser);
use strict;

my $string;

#prepare and execute SQL statement
$string1 = "Show tables";
$sth = $dbh->prepare($string1);
$sth->execute ||
die "Could not execute SQL statement ... maybe invalid?";

print header;
print start_html("Thank You");
print h2("Thank You");
print $string1;

my %form;
foreach my $p (param()) {
$form{$p} = param($p);
print "$p = $form{$p}<br>\n";
}
print end_html;





I basically want a web front end to a mysql database table...

whats with the c;/ drive sounds like ms window problems

Im doing this develpment as part of my university group, the laptop we use, is windows im afraid. It has activeperl, my sql, apache all installed and scripts run all ok, just when i try to access a mysql table using DBI it doesnt work, i am very new to perl, dbi, cgi

rofl... should they be looking in /usr/bin/perl, lukeleia3? you are so bad :P

doesn't windoze use a backwards slash? maybe this is your problem in the first line.

when i use appache i usually grab the 6 inch thick manual "Apache Server Unleased" I also have the "Samba Unleashed" I do how ever have the pdf "Apache Server Unleased" if you want and have a big enough email box i could send it to you.

possible solution is " what the heck happened to ms windows? How did linux get installed on here?"

I dont know how it is installed on ms winders i use linux and nikki your correct on linux

hahaha trust me ive been planning to install suse on there just thinking of a good enuff excuse

can you mail it to jinda@go.com my trash, crap, bucket of email

Id like to have that apache server unleased on pdf and my mailbox should be plenty big enough

so did correcting the slashes in the path to perl fix it?

Nope....perl still works with either slashes.....