Help with SHA1 or MD5 in PHP

Question

Hi,

I have created a form that inserts the entered data into the database. It works perfectly except when I put SHA1('$password') into the INSERT INTO VALUSE tag. If I put only '$password it works fine.

Putting SHA1 displays - You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near '' at line 1

Can you help me out.

Thanks

$q = "insert into users (fullname,email,website,username,password) values ('$fn','$e','$w','$u', SHA1('$password')";
    $r = mysql_query($q) or die(mysql_error()); //Run the query.

Answer 1

Looks like you are missing a parenthesis in your statement. Try:

$q = "insert into users (fullname,email,website,username,password) values ('$fn','$e','$w','$u', SHA1('$password'))";