jquery Ajax dataType text error

Question

I can't figure out why this is triggering the alert. The error value is undefined. add_size.php is just a simple update query and it is returning a string response. The query works fine and the record is updated. Why is the success not being triggered?

$('#size_add_btn').on('click', function(e){
    e.preventDefault();
    sizeboxvalue = $('#size_name').val();
    $.ajax({
        type: "POST",
        url: "add_size.php",
        data: {name: sizeboxvalue},
        dataType: 'text',
        success: function(text) {
            $("#sizeRow").prepend("<div class='col-lg-4'><input type='checkbox' name='attr_size[]' value='"+ text +"' > " + text + "</div>");
        },
        error:function(err){
            //handle your error
            alert('did not work ' + err + 'e: ' + e);
        }
    });
});

php file:

$name = $mysqli->real_escape_string($_REQUEST['name']);
$sql = "update attributes set size=concat(size, ',$name');";
$mysqli->query($sql);
$result->close();
echo $name;

Please post your php file, and describe more the error that you retrieve — Alessandro Minoccheri
– Alessandro Minoccheri, Commented Apr 20, 2015 at 20:28
500 (Internal Server Error) jquery.js:6send jquery.js:6x.extend.ajax jquery.js:6(anonymous function) product:751x.event.dispatch jquery.js:5v.handle — snaed
– snaed, Commented Apr 20, 2015 at 21:00

Aneesh R S · Accepted Answer · 2015-04-21 05:06:27Z

1

Its because the response is not text. So you should add the text header before the echo statement in the add_size.php

So the final code will looks like

$name = $mysqli->real_escape_string($_REQUEST['name']);
$sql = "update attributes set size=concat(size, ',$name');";
$mysqli->query($sql);
//$result->close();
header("Content-type: text/xml");
echo $name;

edited Apr 21, 2015 at 5:06

answered Apr 20, 2015 at 20:55

Aneesh R S

3,8174 gold badges25 silver badges35 bronze badges

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

5 Comments

snaed Over a year ago

That did not help. Still get the alert triggered.

snaed Over a year ago

It updates the database record fine. err is "undefined" and so is e

Aneesh R S Over a year ago

can u tell me what is the response in the console.not the alert.

snaed Over a year ago

sorry, I posted the console reply in my previous replies to others.

snaed Over a year ago

500 (Internal Server Error) jquery.js:6send jquery.js:6x.extend.ajax jquery.js:6(anonymous function) product:751x.event.dispatch jquery.js:5v.handle

snaed · Accepted Answer · 2015-04-20 23:06:52Z

0

the problem was the line

$result->close();

in the php file. There was no $result! Why is it always so obvious?!

answered Apr 20, 2015 at 23:06

snaed

273 bronze badges

Collectives™ on Stack Overflow

jquery Ajax dataType text error

2 Answers 2

5 Comments

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

5 Comments

Comments

Your Answer

Sign up or log in

Post as a guest

Related