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");
> 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 appear in mysql table as encripted?
>
> Thanks
>
> ---------------------------------------------------------------------
> 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-
[EMAIL PROTECTED]>
> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
$sql .= "VALUES(?, ?)";
---------------------------------------------------------------------
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 <[EMAIL PROTECTED]>
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
