结果是在ajax成功中连接起来

Question

This is my ajax call code...I call this function on body onload.

function get_booking_id() {


    var baseurl = "<?php echo base_url().'index.php/controller_bookplot2/getbookingid'; ?>";

    $.ajax({ 
        url: baseurl,
        datatype:"html",
        success: function(html) {

            alert('booking'+html);
            $("#booking_id").val(html);
        }
    });
}

And this is my controller function..

function getbookingid() {

    $sql="select IFNULL(max(booking_id),0) as bookingID from booking";
    $query=$this->db->query($sql);

    if($query->num_rows() > 0) {

        foreach($query->result() as $row) {
                echo $x=$row->bookingID;
                echo $x+1;
        }
    }
}

So in alert when in database there is no value, it display 1, but next time it display 12 instead of 2. So I think it concatenating the result. I want to only 2 as alert not 12. What am I doing wrong???

Answer 1

Please remove echo for $x=$row->bookingID; if you don't need in response.

Updated controller function code:

function getbookingid(){

    $sql="select IFNULL(max(booking_id),0) as bookingID from booking";
    $query=$this->db->query($sql);

    if($query->num_rows() > 0){


    foreach($query->result() as $row){
        $x=$row->bookingID;
        echo $x+1;
    }
    }
   }