Databases
StackOverflow2013
Postsdbo
POIf Else statement syntax error
Body
 

Note that there are some explanatory texts on larger screens.

plurals
  1. POIf Else statement syntax error
    text
    copied!<p>I have the following function which in words should take user credentials and validate them. If they are valid insert them into the db. Once inserted check if they are successfully inserted. If not return false. If the email was invalid in the first place return false. Eclipse + Aptana plugin is reporting a syntax error with the last else section. It seems like it should be functioning correctly when I try to rationalize the code. I can confirm all of the {brackets} are in the correct hierarchical order</p> <p>Here is the code:</p> <pre><code> public function storeUser($name, $email, $password) { $uuid = uniqid('', true); $hash = $this-&gt;hashSSHA($password); $encrypted_password = $hash["encrypted"]; // encrypted password $salt = $hash["salt"]; // salt if((filter_var($email, FILTER_VALIDATE_EMAIL)) &amp;&amp; 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; } } } </code></pre> <p>It returns the following error:</p> <pre><code>05-23 11:07:10.758: E/JSON(1601): &lt;b&gt;Parse error&lt;/b&gt;: syntax error, unexpected T_ELSE in &lt;b&gt;/home/content/40/8529140/html/webapps/projects/functions/DB_Functions.php&lt;/b&gt; on line &lt;b&gt;45&lt;/b&gt;&lt;br /&gt; 05-23 11:07:10.758: E/JSON Parser(1601): Error parsing data org.json.JSONException: Value &lt;br of type java.lang.String cannot be converted to JSONObject </code></pre>
 

Querying!

 
Guidance
An individual column

Larger individual text columns get their own page to allow for proper reading.

SQuiL has stopped working due to an internal error.

If you are curious you may find further information in the browser console, which is accessible through the devtools (F12).

Reload