Databases
StackOverflow2013
Postsdbo
POPass specific info through JSON, JQuery, PHP
 

Note that there are some explanatory texts on larger screens.

plurals
  1. POPass specific info through JSON, JQuery, PHP
    primarykey
    data
    text
    <p>My PHP:</p> <pre><code>if($count == 1 &amp;&amp; $user_level &lt; 4 &amp;&amp; $if_active == 1) { $response = array("success" =&gt; true); //The login stuff happens here echo json_encode($response); } elseif($count == 1 &amp;&amp; $user_level &lt; 4 &amp;&amp; $if_active == 0) { $response = array("success" =&gt; not_act); echo json_encode($response); } else { $response = array("success" =&gt; false); echo json_encode($response); } </code></pre> <p>The JQuery that sends and recieves the data from that PHP file</p> <pre><code>$('#login_form').submit(function(){ var emailB = encodeURIComponent($('#email_B').val()); var passwordB = encodeURIComponent($('#password_B').val()); $('#wrapper').fadeOut(); $('#login_effect').fadeIn(); $.ajax({ type: 'POST', url: 'checklogin.php', dataType: "json", data: { email: emailB, password: passwordB, }, success: function(result) { if (!result.success) { timeout = setTimeout(function(){ $('#login_effect').fadeOut(); }, 1500); $('#wrong_password').fadeIn(); } else if (result.success == not_act) {timeout = setTimeout(function(){ $('#login_effect').fadeOut(); }, 1500); $('#not_act').fadeIn();} else { timeout = setTimeout(function(){ $('#login_effect').fadeOut(); }, 1500); document.location.href='http://matchmingle.net/profile/'; } } }); return false; }); </code></pre> <p>This works fine and dandy EXCEPT for the not activated part. How do I find out in the JQuery what the JSON returned besides just true and false? I tried to </p> <pre><code>$response = array("success" =&gt; not_act); </code></pre> <p>and then in the JQUery </p> <pre><code>else if (result.success == not_act) {do cool stuff} </code></pre> <p>but I can't get it to work because I'm obviously doing it wrong. BTW I'm very new to this JQuery/JSON/Javascript, what you're seeing me do is what I've learned from a dummies book over the corse of a few weeks and a bunch of help from you guys. </p> <p>So yeah, what's the proper way to set the json response variable and find out what it's value is in the JQuery? Thanks a bunch -Mike</p>
    singulars
    1. PO
      singulars
      1. PTAnswer
    1. This table or related slice is empty.
    1. PTQuestion
    1. This table or related slice is empty.
    1. USuser1053263
    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. PO
      singulars
      1. PTAnswer
    2. PO
      singulars
      1. PTAnswer
    3. PO
      singulars
      1. PTAnswer
    1. VO
      singulars
      1. POPass specific info through JSON, JQuery, PHP
      1. This table or related slice is empty.
      1. VTUpMod
    1. COWhy are you using unquoted strings? They work in PHP if they are a valid but undefined constant name, but in pretty much every other language they luckily don't.
      singulars
      1. POPass specific info through JSON, JQuery, PHP
      1. USThiefMaster
    2. COTheifMaster is right, not_act without quotes causes PHP to look for a constant named not_act, and when it doesn't find one, it uses the string literal "not_act" instead. this is an unfortunate quirk in PHP that encourages bad coding habits. always use quotes or <<< when defining string literals.
      singulars
      1. POPass specific info through JSON, JQuery, PHP
      1. USdqhendricks
    3. COyeah it was something so stupid I over looked, embarrassedface.jpg
      singulars
      1. POPass specific info through JSON, JQuery, PHP
      1. USuser1053263
 

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