Databases
StackOverflow2013
Postsdbo
POjQuery mobile getting wrong authentication
 

Note that there are some explanatory texts on larger screens.

plurals
  1. POjQuery mobile getting wrong authentication
    primarykey
    data
    text
    <p>I have the following situation:</p> <p>index.html (which is my login page)</p> <pre><code>&lt;div data-role="page" id="page_login"&gt; &lt;div id="wrapper_top_image"&gt; &lt;div id="top_image"&gt;&lt;/div&gt; &lt;/div&gt; &lt;div data-role="content" data-theme="b"&gt; &lt;div id="landmark-1" data-landmark-id="1"&gt; &lt;form id="loginForm" onsubmit="return submitLogin();"&gt; &lt;div data-role="fieldcontain" class="ui-hide-label"&gt; &lt;label for="username"&gt;Username:&lt;/label&gt; &lt;input type="text" name="username" id="username" value="" placeholder="Username" /&gt; &lt;/div&gt; &lt;div data-role="fieldcontain" class="ui-hide-label"&gt; &lt;label for="password"&gt;Password:&lt;/label&gt; &lt;input type="password" name="password" id="password" value="" placeholder="Password" /&gt; &lt;/div&gt; &lt;input type="submit" value="Login" id="submitButton"&gt; &lt;/form&gt; &lt;/div&gt; &lt;/div&gt; &lt;div data-role="footer"&gt; &lt;h4&gt;&amp;copy; 2013 Company&lt;/h4&gt; &lt;h6&gt;Developed by Alex&lt;/h6&gt; &lt;/div&gt; </code></pre> <p></p> <p>and then my PHP Script that is going to check everything -> ps.. I fixed to avoid injection already! :</p> <p>auth.php</p> <pre><code>$mysqli = new mysqli($mysql_hostname,$mysql_user, $mysql_password, $mysql_database); // Parse the log in form if the user has filled it out and pressed "Log In" if (isset($_POST["username"]) &amp;&amp; isset($_POST["password"])) { $username =$_POST['username']; $password =$_POST['password']; $sql = "SELECT id, password, username FROM users WHERE username='$username' AND password='$password' LIMIT 1"; $result = $mysqli-&gt;query($sql) or die( $mysqli-&gt;error() ); $rowN= mysqli_num_rows($result); if($rowN==1){ $response_array['status'] = 'success'; } else { $response_array['status'] = 'error'; } echo json_encode($response_array); } $mysqli-&gt;close(); </code></pre> <p>Finally my JQuery Script:</p> <pre><code>function submitLogin(){ jQuery.support.cors = true; $.ajax({ url: 'http://www.xxxx.com/mobile/auth.php', crossDomain: true, type: "post", data: $("#loginForm").serialize(), success: function(data){ if(data.status == 'success'){ //alert("Granted Access!"); $.mobile.changePage("main.html"); }else if(data.status == 'error'){ alert("Authentication Invalid. Please try again!"); navigator.app.exitApp(); $.mobile.changePage("index.html"); } } }); }; </code></pre> <p>Everything is working ok! Data is checked and if it is okay, is redirected to main.html (main page) otherwise the app pops up a window saying that the authentication is wrong, keeping the user in the same page.</p> <p>Here is the dilemma: If users type the wrong credential trying to login again, any credential that he/she enter will be considerate invalid even if he/she entered the right one and the app will keep going back to the login page until I refresh the browser or end the app in case of running in the device.</p> <p>Does anyone knows what may be happening?</p>
    singulars
    1. This table or related slice is empty.
    1. This table or related slice is empty.
    1. PTQuestion
    1. USCharles
    1. USAlexandre Araujo
    plurals
    1. This table or related slice is empty.
    1. This table or related slice is empty.
    1. This table or related slice is empty.
    1. This table or related slice is empty.
    1. This table or related slice is empty.
    1. COHmm check your HTTP requests and see what it is actually posting to the PHP script.. your code appears valid. You said that you "fixed to avoid injection".. What changes did you make to the script? Are you using parameterized queries now?
      singulars
      1. POjQuery mobile getting wrong authentication
      1. UStrevorkavanaugh
    2. CO@Your, knock it off with the meta tagging, please. If you feel a question should be closed, then vote for it to be closed and/or downvote. There is a custom close reason field available under the Off Topic category.
      singulars
      1. POjQuery mobile getting wrong authentication
      1. USCharles
    3. CO@Charles I'd be glad to submit if you ask me to do something sensible or useful. BTW, bubbling up pointless questions just spam the list. Why not just let it go?
      singulars
      1. POjQuery mobile getting wrong authentication
      1. USYour Common Sense
 

Querying!

 
Guidance
A row detail

Detail views are divided into sections. All the information in the data section comes from columns in the selected row. The other sections display data from other, related rows.

Related data can be related in a to-one or a to-many fashion. Captions of data related in a to-many fashion link to a list view showing a filtered view of the table.

Try moving around until you find a non-empty to-many entry and click on the label to get to one. You can move back to the root by clicking on the database name in the header.

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