JSON.parse: unexpected end of data error

Question

For the code below i am getting this error :

JSON.parse: unexpected end of data

at line var data = JSON.parse(json);

the code used is:

$(document).ready(function(){  
$("#button1").click(function(){
    $.post(
        'script_1.php',
        { id: $('input[name="id"]', '#myForm').val() },
        function(json) { 
            var data = JSON.parse(json);
            if (data.length === 0){
             alert('no data');   
            }
            else{
            $("input[name='title']").val(json.title);
                    $("input[name='age']").val(json.age); 
            }},
        "json"
    );
});
});

the back end php is

$sql ="SELECT * FROM parent WHERE id = '$name'";       
$result = mysql_query($sql);
$row = mysql_fetch_array($result);
if ($row) {
$row=  array('title' => $row['title'],'rno' => $row['reportno'],'url' =>      
$row['calc_url'], 'institution' => $row['institution']);
 echo json_encode($row);
 } else {
 echo json_encode(array());
 }

What is reason for the error here?

Note: Beware of SQL injection and use mysql_real_escape_string on $name before inserting into your $sql string. — betamax
– betamax, Commented Aug 18, 2011 at 16:47

Craig Stuntz · Accepted Answer · 2011-08-18 16:44:10Z

9

When you specify "json" the data argument to your callback will already be parsed. There is no need to invoke JSON.parse, here.

answered Aug 18, 2011 at 16:44

Craig Stuntz

127k12 gold badges257 silver badges275 bronze badges

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

Collectives™ on Stack Overflow

JSON.parse: unexpected end of data error

1 Answer 1

Comments

Your Answer

Linked

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

Comments

Your Answer

Sign up or log in

Post as a guest

Linked

Related