SHA and Prpeared Statements

[doubledee]

Is this the correct syntax to use the SHA function within a Prepared Statement??

 

$q = "INSERT INTO member(email, pass, first_name, activation_code, created_on)
		VALUES(?, ?, ?, ?, NOW())";

// Prepare statement.
$stmt = mysqli_prepare($dbc, $q);


// Bind variable.
mysqli_stmt_bind_param($stmt, 'ssss', $email, SHA('$pass'), $firstName, $activationCode);

// Execute query.
mysqli_stmt_execute($stmt);

 

Thanks,

 

 

Debbie

 

P.S.  Is there a way to BOLD text within the [ php ] tags?

 

 

[trq]

Providing the SHA function is defined somewhere that syntax is fine.

 

And no, there is no way to bold text within the syntax highlighting.