I have perl code like
my $username = $query-param(username);
my $password1 = $query-param(password1);
my $sql= INSERT INTO apidbusers ;
$sql .= VALUES(?, ?);
$sth-execute($username, $password1);
In this way, password1 will be in mysql table as plain text.
how can i let it
sth-execute($username, password($password1)) does not work.
On Fri, 28 Feb 2003, Jianping Zhu wrote:
I have perl code like
my $username = $query-param(username);
my $password1 = $query-param(password1);
my $sql= INSERT INTO apidbusers ;
$sql .= VALUES(?, ?);
How about:
my $sql = INSERT INTO apidbusers VALUES (?, password(?));
--jeff
- Original Message -
From: Jianping Zhu [EMAIL PROTECTED]
To: [EMAIL PROTECTED]
Sent: Friday, February 28, 2003 2:48 PM
Subject: Re: mysql encripted password from perl
sth-execute($username, password
change
$sql .= VALUES(?, ?);
into
$sql .= VALUES(?, password(?));
Please note that password is a mySQL function and not a PERL function. So,
you need to use the password function again in verify the password.
Regards,
KH
I have perl code like
my $username = $query-param(username);