SQL error or PHP error it returning in my ajax [object object]

Question

The ajax is being called when the button inside the modal window is click. So I got a button then it pop up a modal window with the yes or no button and if click yes it will trigger this ajax and send data to my php. it actually save or update my table in my database but it returns an [object object] in my ajax when it returns.

here is the php

// get data
$selGuest = $_POST["selGuest"];

include("openDB.php");

//3.) insert a record

$insertintoCanceled = "insert into tbl_canceled "
        ."(reserved_id, guest_id, checkin, checkout, type_id, numAdults, numChildren, transacstatus, amountDue)"
        ."("
        ."SELECT * FROM tbl_bookings where reserved_id = " .$selGuest
        .")";
if(!mysql_query($insertintoCanceled, $con))//if it fails
    {
    echo json_encode(array('msg'=>'Error')) //error msg goes here
    die('Error: ' . mysql_error() . "\n");//show the mysql error

    }
echo json_encode(array('msg'=>'Successfully updated')) //success msg goes here



include("closeDB.php");
?>

and here is my ajax

var canceldata_json = {
            'selGuest': selGuest,
    };
    $.ajax({
            type: "POST",
            data: canceldata_json,
            dataType:'json',
            url: "./php/cancelBooking.php",
            success: function(msg) {
                    alert("guest information updated real")
                    $('#confirmDialog').fadeOut('slow');

            },
            error:function(msg){
            alert(msg)
            }
    });

I'm sorry but I think I didn't tag it in asp.net. I tag it in php, mysql, ajax, and jquery — propaganja
– propaganja, Commented Sep 20, 2012 at 17:13

Explosion Pills · Accepted Answer · 2012-09-20 16:14:45Z

2

It's parsing the JSON you return. Do this instead:

alert(msg.msg);

answered Sep 20, 2012 at 16:14

Explosion Pills

192k56 gold badges341 silver badges417 bronze badges

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

2 Comments

propaganja Over a year ago

thank you for your response. it output is undefined. And before I even click ok in the alert window it already closed or fade out without doing anything.

Explosion Pills Over a year ago

@propaganja does closeDB.php have any output?

Collectives™ on Stack Overflow

SQL error or PHP error it returning in my ajax [object object]

1 Answer 1

2 Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

2 Comments

Your Answer

Sign up or log in

Post as a guest

Related