Question

This question is unlikely to help any future visitors; it is only relevant to a small geographic area, a specific moment in time, or an extraordinarily narrow situation that is not generally applicable to the worldwide audience of the internet. For help making this question more broadly applicable, visit the help center.

Closed 11 years ago.

我有一个以下函数, 用文字表示用户证书并验证它们。如果它们有效的话, 请在 db 中插入它们。一旦插入检查它们是否成功插入。如果不返回错误。如果电子邮件在一开始无效, 则返回错误。 Eclipse + Aptana 插件正在用其他最后一节报告一个语法错误。当我试图使代码合理化时, 它似乎应该正常运行。我可以确认所有 { brackets} 都在正确的等级顺序中。

这是代码:

   public function storeUser($name, $email, $password) {
    $uuid = uniqid(  , true);
    $hash = $this->hashSSHA($password);
    $encrypted_password = $hash["encrypted"]; // encrypted password
    $salt = $hash["salt"]; // salt
    if((filter_var($email, FILTER_VALIDATE_EMAIL)) && preg_match( /@.+./ , $email)); { //validate the email 
    $result = mysql_query("INSERT INTO users(unique_id, name, email, encrypted_password, salt, created_at) VALUES( $uuid ,  $name ,  $email ,  $encrypted_password ,  $salt , NOW())"); 

    // check for successful store
    if ($result) {
        // get user details 
        $uid = mysql_insert_id(); // last inserted id
        $result = mysql_query("SELECT * FROM users WHERE uid = $uid");
        // return user details
        return mysql_fetch_array($result);
    } else {
        return false; //unsuccessful store
    }
     else { //THIS IS LINE 45
        //not a valid email
        return false;
    }
    }
}

它返回以下错误:

05-23 11:07:10.758: E/JSON(1601): <b>Parse error</b>:  syntax error, unexpected T_ELSE in <b>/home/content/40/8529140/html/webapps/projects/functions/DB_Functions.php</b> on line <b>45</b><br />
05-23 11:07:10.758: E/JSON Parser(1601): Error parsing data org.json.JSONException: Value <br of type java.lang.String cannot be converted to JSONObject

Answer 1

您的 else 语句在关闭括号上的位置不对。如果您在第二个 else 之前移动一个语句, 将会有效。实际上, 也许它不会有效, 您也有一个错误 < code> ; , 但其它建议仍然有效。

如果你更一致地缩进代码, 你就不会被这种问题所困住。

public function storeUser($name, $email, $password) {
    $uuid = uniqid(  , true);
    $hash = $this->hashSSHA($password);
    $encrypted_password = $hash["encrypted"]; // encrypted password
    $salt = $hash["salt"]; // salt
    if ( //validate the email 
         filter_var($email, FILTER_VALIDATE_EMAIL) &&
         preg_match( /@.+./ , $email)
         ) {
        $result = mysql_query (
            "INSERT INTO users(unique_id, name, email, encrypted_password, salt, created_at) VALUES( $uuid ,  $name ,  $email ,  $encrypted_password ,  $salt , NOW())"
        );
        if ($result) { // check for successful store
            // get user details 
            $uid = mysql_insert_id(); // last inserted id
            $result = mysql_query("SELECT * FROM users WHERE uid = $uid");
            // return user details
            return mysql_fetch_array($result);
        } else {
            return false; //unsuccessful store
        }
    } else {
        //not a valid email
        return false;
    }
}

另外: 不要使用 mysql/code> 函数。学习使用 PDO 和参数查询。

Answer 2

if((filter_var($email, FILTER_VALIDATE_EMAIL)) 
      && preg_match( /@.+./ , $email)); { //<<<REMOVE THE ;

Answer 3

您没有正确关闭您的牙套, 在外部 < code> if 之后有一个额外的分号 :

if((filter_var($email, FILTER_VALIDATE_EMAIL)) && preg_match( /@.+./ , $email)) { //validate the email 
   $result = mysql_query("INSERT INTO users(unique_id, name, email, encrypted_password, salt, created_at) VALUES( $uuid ,  $name ,  $email ,  $encrypted_password ,  $salt , NOW())"); 

   // check for successful store
   if ($result) {
      // get user details 
      $uid = mysql_insert_id(); // last inserted id
      $result = mysql_query("SELECT * FROM users WHERE uid = $uid");
      // return user details
      return mysql_fetch_array($result);
   } else {
     return false; //unsuccessful store
   }
} // close of outer if
else {
    //not a valid email
    return false;
}

Answer 4

您看到此结尾的小分号吗? if (( filter_var( $email, FILTER_ VALIDATE_ EMAIL)) & amp; & amp; preg_ match (/@.+. /, $email) ;

Answer 5

你把括号放错位置。试试这个

 public function storeUser($name, $email, $password) {
    $uuid = uniqid(  , true);
    $hash = $this->hashSSHA($password);
    $encrypted_password = $hash["encrypted"]; // encrypted password
    $salt = $hash["salt"]; // salt
    if((filter_var($email, FILTER_VALIDATE_EMAIL)) && preg_match( /@.+./ , $email)) { //validate the email 
    $result = mysql_query("INSERT INTO users(unique_id, name, email, encrypted_password, salt, created_at) VALUES( $uuid ,  $name ,  $email ,  $encrypted_password ,  $salt , NOW())"); 

    // check for successful store
    if ($result) {
        // get user details 
        $uid = mysql_insert_id(); // last inserted id
        $result = mysql_query("SELECT * FROM users WHERE uid = $uid");
        // return user details
        return mysql_fetch_array($result);
    } else {
        return false; //unsuccessful store
    }
    }
     else {
        //not a valid email
        return false;
    }

}

Answer 6

为什么你在最后有两个 else {{{{{{{{{{{{{{{{{{{{{{{{{{{{{{{{{{{{{{{{{{{{{{{{{{{{{{{{{{{{{{{{{{{{{{{{}}块块?

友情链接