JSON ajax and jquery, cannot get to work?

Question

I have the following script in my javascript...

$.ajax({
    type: 'POST',
    url: 'http://www.example.com/ajax',
    data: {email: val},
    success: function(response) {   
             alert(response);
    }
});

And my php file looks like this...

    if ($_REQUEST['email']) {

$q = $dbc -> prepare("SELECT email FROM accounts WHERE email = ?");
$q -> execute(array($_REQUEST['email']));
if (!$q -> rowCount()) {

    echo json_encode(error = false);
}
else {

    echo json_encode(error = true);
}

    }

I cannot get either the variable error of true or false out of the ajax call?

Does it matter how I put the data into the ajax call?

At the minute it is as above, where email is the name of the request, and val is a javascript variable of user input in a form.

Are you using firebug or a similar tool to view the AJAX request/response? — rwilliams
– rwilliams, Commented Sep 24, 2011 at 2:12
I have firebug lite for chrome. The ajax request was sucessfull but was returning [object]:[object] before. — Project V1
– Project V1, Commented Sep 24, 2011 at 2:17
Good deal. Thanks for the update. FYI the chrome developer tools are pretty darn good themselves if you want to try to ween yourself off of firebug lite. — rwilliams
– rwilliams, Commented Sep 24, 2011 at 2:25

aziz punjani · Accepted Answer · 2011-09-24 02:10:59Z

2

Try this instead. Your current code should give you a syntax error.

if (!$q -> rowCount()) {

    echo json_encode(array('error' => false));
}
else {

    echo json_encode(array( 'error' => true ))
}

answered Sep 24, 2011 at 2:10

aziz punjani

25.8k9 gold badges49 silver badges56 bronze badges

Sign up to request clarification or add additional context in comments.

3 Comments

Project V1 Over a year ago

This works but why does it have to be in an array? Thanks Interstellar

aziz punjani Over a year ago

Because json_encode() takes a mixed argument as its parameter, but more than that an array is the most logical structure to store a key, value pair in. The array eventually gets translated into {"error":true}

Project V1 Over a year ago

This works but how do I call the variable now? error isn't it, and I tried response['error'], response[error], response["error"]? This JSON stuff is annoying lol.

Shamrocker · Accepted Answer · 2011-09-24 02:17:29Z

1

In your code, the return parameter is json

$.ajax({
    type: 'POST',
    url: 'http://www.example.com/ajax',
    dataType: 'json',
    data: {email: val},
    success: function(response) {   
             alert(response);
    }
});

PHP FILES

if ($_REQUEST['email']) {

   $q = $dbc -> prepare("SELECT email FROM accounts WHERE email = ?");
   $q -> execute(array($_REQUEST['email']));
   if (!$q -> rowCount()) {
       echo json_encode(error = false);
       return json_encode(error = false);
   } else {

       echo json_encode(error = true);
       return json_encode(error = true);
    }
 }

answered Sep 24, 2011 at 2:17

Shamrocker

1212 silver badges11 bronze badges

1 Comment

Shamrocker Over a year ago

Yes, you are right, I thought the problem was without dataType.

Collectives™ on Stack Overflow

JSON ajax and jquery, cannot get to work?

2 Answers 2

3 Comments

1 Comment

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

3 Comments

1 Comment

Your Answer

Sign up or log in

Post as a guest

Related