jquery use json_encoded array from AJAX

Question

I'm just trying to spit the elements of an array into seperate input fields on a form via jquery's AJAX.

Heres my javascript code:

        $('#based').change(function() { 
        if ($(this).val().length > 0)
        {           
            $.ajax({
                type: "POST",
                url: "ajax.php",
                data: "id="+$(this).val(),
                success: function(data){
                    if (data != 'error')
                    {                       
                        $('#keyword').val(data[2]);
                        $('#keyword_slug').val(data[3]);
                    }
                }
            });
        }
    });

Heres my PHP code for 'ajax.php':

$sql = mysql_query("select * from `keywords` where `id`='".mysql_real_escape_string($_POST['id'])."'");

if (mysql_num_rows($sql) == 0)
{
    echo 'error';
}
else
{
    while ($row = mysql_fetch_assoc($sql))
    {
        foreach ($row as $k => $v)
            $data[] = $v;
    }

    echo json_encode($data);
}

Its not working. What do I do here? I've looked into serializeArray but can't get anything to work properly.

Can you print the length of the data array on the server and also on the client ? — allthenutsandbolts
– allthenutsandbolts, Commented Mar 24, 2011 at 1:03

alex · Accepted Answer · 2011-03-24 01:11:59Z

2

I think you need dataType: 'json' if you are expecting JSON back.

Otherwise jQuery has to guess, and if you are not sending the Content Type application/json, it may guess wrong.

edited Mar 24, 2011 at 1:11

answered Mar 24, 2011 at 1:03

alex

492k205 gold badges890 silver badges992 bronze badges

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

4 Comments

user578895 Over a year ago

If that's the issue, it's better to do this in PHP and set the Content-Type header to JSON

alex Over a year ago

@cwolves I hope you mean application/json. I also prefer to explicitly state the return type.

scarhand Over a year ago

setting the dataType worked perfectly :). one more problem - one of the fields is a textarea and this doesn't seem to be passing linebreaks "\n"

alex Over a year ago

@scarhand You may better off asking a new question with that :) Worked for me with a string.

Collectives™ on Stack Overflow

jquery use json_encoded array from AJAX

1 Answer 1

4 Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

4 Comments

Your Answer

Sign up or log in

Post as a guest

Related