checking JSON data with jQuery

Question

I have written a php script:

cch.php:

$stmtcheck = $mysqli->prepare("SELECT id,email,location FROM members WHERE email=? AND unlock_code=?");
$stmtcheck->bind_param("si", $_SESSION['unlockemail'], $_POST['code']);
$stmtcheck->execute();
$stmtcheck->bind_result($id,$email,$location);
$stmtcheck->fetch();
         $array=array($id,$email,$location);    
        json_encode($array);
$stmtcheck->close();

And jquery for submitting form is

recover.php:

$("#formUnlock").submit(function(e)
{
   e.preventDefault();

   $.ajax(
   {
        url: '../scripts/cch.php',
        method: 'POST',
        data: $(#formUnlock).serialize(),
        dataType: 'JSON',
        success: function()
        {

        }
   }); 
});

The script is returning more than one variable and the returned data should be in JSON format.

How do I read the data in jQuery?

you need to echo the json on the PHP side, the response is returned to the success callback function in JS. — JimL
– JimL, Commented Nov 13, 2016 at 12:46
Same question as here: stackoverflow.com/questions/40572547/… -You can edit question there itself — Ima
– Ima, Commented Nov 13, 2016 at 12:48

Ima · Accepted Answer · 2016-11-13 12:52:50Z

1

    $("#formUnlock").submit(function(e)
    {
       e.preventDefault();

       $.ajax(
       {
            url: '../scripts/cch.php',
            method: 'POST',
            data: $(#formUnlock).serialize(),
            dataType: 'JSON',
            success: function(data) //parameter missing
            {
    var json = $.parseJSON(data);
console.log(json);
//in console you will get the result response        
            }
       }); 
    });

edited Nov 13, 2016 at 12:52

Ima

1,10912 silver badges26 bronze badges

answered Nov 13, 2016 at 12:50

user6533277

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

Comments

Popsyjunior · Accepted Answer · 2016-11-16 13:23:02Z

Hello your php code should echo the JSON output like this:

<?php
$stmtcheck = $mysqli->prepare("SELECT id,email,location FROM members WHERE email=? AND unlock_code=?");
$stmtcheck->bind_param("si", $_SESSION['unlockemail'], $_POST['code']);
$stmtcheck->execute();
$stmtcheck->bind_result($id,$email,$location);
$stmtcheck->fetch();
$array=array($id,$email,$location);
$stmtcheck->close();
echo json_encode($array);
?>

Now, in your javascript, you can use JSON.parse method to get the JSON. Also, specifying your response type as JSON will automatically return a JSON object.

$("#formUnlock").submit(function (e) {
    e.preventDefault();
    $.ajax({
        url: '../scripts/cch.php',
        method: 'POST',
        data: $('#formUnlock').serialize(),
        dataType: 'JSON',
        success: function (json_string) {
            var res = JSON.parse(json_string);
            console.log(res);//This should output your JSON in console..
        }
    });
});

Collectives™ on Stack Overflow

checking JSON data with jQuery

2 Answers 2

Comments

Comments

Your Answer

Linked

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

Comments

Comments

Your Answer

Sign up or log in

Post as a guest

Linked

Related