kanewilliam7777 has asked for the wisdom of the Perl Monks concerning the following question:
In PERL I have connet the database using DBI concept. The database connection & select table query everything working fine in .pl file. But i have run the DBI database connection code in .pm file. It's not working.
Please review code.
Sample.pl (It's working fine)
use DBI; my $driver = "mysql"; my $database = "marketplace_perl"; my $dsn = "DBI:$driver:database=$database"; my $userid = "root"; my $password = "root"; my $dbh = DBI->connect($dsn, $userid, $password ); my $dbh=connect_db(); my $sth = $dbh->prepare("SELECT UserEmail,UserPassword FROM pj +_user where UserEmail=? and UserPassword=?"); $sth->execute($UserEmail,$UserPassword);
Marketplace.pm (It's not working)
package Marketplace; use DBI; sub connect_db { my $driver = "mysql"; my $database = "marketplace_perl"; my $dsn = "DBI:$driver:database=$database"; my $userid = "root"; my $password = "root"; my $dbh = DBI->connect($dsn, $userid, $password ); return $dbh; } sub login_marketplace { my $dbh=connect_db(); my $sth = $dbh->prepare("SELECT UserEmail,UserPassword FRO +M pj_user where UserEmail=? and UserPassword=?"); $sth->execute($UserEmail,$UserPassword); my $User_count=$sth->rows; return $User_count }
It's rertun the error message of "Failed to access class (Marketplace): Can\'t locate DBI.pm in @INC (you may need to install the DBI module)"
Please let me know how to fix the DB issue.
|
|---|
| Replies are listed 'Best First'. | |
|---|---|
|
Re: Perl Database connect not working in .pm file
by Corion (Patriarch) on Aug 31, 2018 at 06:07 UTC | |
by kanewilliam7777 (Novice) on Aug 31, 2018 at 06:20 UTC | |
by poj (Abbot) on Aug 31, 2018 at 06:35 UTC | |
|
Re: Perl Database connect not working in .pm file
by Marshall (Canon) on Sep 01, 2018 at 07:57 UTC |