Troy Hickey wrote:
>Is there a different method of logging onto a DB when using it in a
>cgi-bin script rather than running the script from the DOS prompt? This
>would indeed explain a not connecting problem.
>
>My code snippet is:
>
>#########################################################
>$db="employees";
>$host="localhost";
>$port="3306";
>$userid="user";
>$passwd="pass";
>$connectionInfo="DBI:mysql:database=$db;$host:$port";
>
># make connection to database
>#$dbh = DBI->connect($connectionInfo);
>$dbh = DBI->connect($connectionInfo,$userid,$passwd);
>
># prepare and execute query
>$query = "INSERT INTO staff (firstName, lastName)
> VALUES ('$firstName', '$lastName')";
>$sth = $dbh->prepare($query);
>$sth->execute();
>
>print "Record inserted into the database";
>
>$sth->finish();
>
># disconnect from database
>$dbh->disconnect;
>#########################################################
>
>- Troy
>
>
You are using the CGI on the same server as the MySQL is running?
And maybe change the line:
$dbh = DBI->connect($connectionInfo,$userid,$passwd);
to:
$dbh = DBI->connect($connectionInfo,$userid,$passwd) or print "Connect failed";
Maybe you get the info then.
>
>
>Ralf Narozny wrote:
>
>
>>Hello!
>>
>>Troy Hickey wrote:
>>
>>
>>
>>>Hi,
>>>
>>>I am pretty new to perl and am currently involved in setting up MySQL
>>>database using Perl. My setup includes MySQL running on Win95.
>>>I have a simple program which writes a few values to a database. The
>>>file works fine when using the Command Line interface and the database
>>>gets the correct entries. However when I try to use the script from a
>>>web-browser I keep getting the same error message:
>>>
>>>"Software error:
>>>Can't call method "prepare" on an undefined value at
>>>/cgi-bin/add_employee.cgi line 33."
>>>
>>>
>>>
>>>
>>Is it possible that the connect() did not succeed? that would explain
>>why $dbh->prepare() would not work.
>>
>>
>>
>>>I don't know why this is happening, although I have read as much as I
>>>could fine on the net regarding this subject.
>>>I'd be grateful for any help.
>>>Thanks, -T
>>>
>>>
>>>
>>>
>>>
>>--
>>Ralf Narozny
>>SPLENDID Internet GmbH & Co KG
>>Skandinaviendamm 212, 24109 Kiel, Germany
>>fon: +49 431 660 97 0, fax: +49 431 660 97 20
>>mailto:[EMAIL PROTECTED], http://www.splendid.de
>>
>>
--
Ralf Narozny
SPLENDID Internet GmbH & Co KG
Skandinaviendamm 212, 24109 Kiel, Germany
fon: +49 431 660 97 0, fax: +49 431 660 97 20
mailto:[EMAIL PROTECTED], http://www.splendid.de
---------------------------------------------------------------------
Before posting, please check:
http://www.mysql.com/manual.php (the manual)
http://lists.mysql.com/ (the list archive)
To request this thread, e-mail <[EMAIL PROTECTED]>
To unsubscribe, e-mail <mysql-unsubscribe-##L=##[EMAIL PROTECTED]>
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
