Hi all,
I'm new to PHP and SQL and just wondered if anyone could help out with this parsing error:
Parse error: syntax error, unexpected T_ENCAPSED_AND_WHITESPACE, expecting T_STRING or T_VARIABLE or T_NUM_STRING in /home/web80484/domains/manversuspillow.se/public_html/labs/iwantthemlive/inc/class.users.inc.php on line 171
public function verifyAccount()
{
$sql = "SELECT Username
FROM users
WHERE ver_code=:ver
AND SHA1(Username)=:user
AND verified=0";
if($stmt = $this->_db->prepare($sql))
{
$stmt->bindParam(':ver', $_GET['v'], PDO::PARAM_STR);
$stmt->bindParam(':user', $_GET['e'], PDO::PARAM_STR);
$stmt->execute();
$row = $stmt->fetch();
if(isset($row['Username']))
{
// Logs the user in if verification is successful
$_SESSION['Username'] = $row['Username'];
$_SESSION['LoggedIn'] = 1;
}
else
{
return array(4, "<h2>Verification Error</h2>n"
. "<p>This account has already been verified. "
. "Did you <a href="/password.php">forget "
. "your password?</a>");
}
$stmt->closeCursor();
// No error message is required if verification is successful
return array(0, NULL);
}
else
{
return array(2, "<h2>Error</h2>n<p>Database error.</p>");
}
}
This: $stmt->bindParam(':ver', $_GET['v'], PDO:😛ARAM_STR);
is line 171