Re: sha1 function in MySql query.

[Peter Brawley]

> $strLogin = "INSERT INTO t (username, password) VALUES ('$username', sha1('$password'))";

That just assigns a string, you have to call the query func eg

$conn = mysqli_connect( ... );
if( $conn->!query($srlogin) ) exit( $conn->error );

$query = "SELECT username, password FROM t WHERE username = '$user' AND password = sha1('$password')";

Again you need to call query() eg ...

if( !$res=$conn->query($query) ) exit( $conn->error );
if( $row=$res->fetch() ) ...