codeigniter access data array in ajax success function

Question

my problem is that i can't access the array returned from controller to ajax success function.

here my controller code:

function get_slot()
{
    $fac_id = 1;
    $date = $this->input->post('date');

    $this->load->model('booking_model');
    $result = $this->booking_model->get_slot_availablity($date, $fac_id );  
    $data['booking'] = $result['row'];

    echo json_encode($data);
}

my ajax function:

 $.ajax({
          type : "Post",
           url : "<?php echo base_url(); ?>index.php/index/get_slot",
          data : "date="+date,
      dataType : 'json',
       success : function(result)
                {
                    $.each(result, function(index, val) {
                        alert(val.slot_id); 
                    });
                }
       });

my model function:

public function get_slot_availablity($date, $fac_id){

    $q = $this->db->select('*')
    ->from('booking')
    ->where('f_id', $fac_id)
    ->where('date', $date);

    $res['row'] = $q->get()->result();

    return $res;
}

the function displays undefined

there is no need to header() first alert(result); in your success block then start parse your json data — Rakesh Sharma
– Rakesh Sharma, Commented Jan 20, 2015 at 7:23
i already delete header(), and i add dataType json..but still get undefined @RakeshSharma — Marco
– Marco, Commented Jan 20, 2015 at 7:36
Please list this $this->booking_model->get_slot_availablity() function's code as well. — Mysteryos
– Mysteryos, Commented Jan 20, 2015 at 7:44

Mysteryos · Accepted Answer · 2015-01-20 07:56:39Z

2

As per your latest comment, your JS code should be as follows:

$.ajax({
      type : "Post",
       url : "<?php echo base_url(); ?>index.php/index/get_slot",
      data : "date="+date,
  dataType : 'json',
   success : function(result)
            {
                $.each(result.booking, function(index, val) {
                    alert(val.slot_id); 
                });
            }
   });

answered Jan 20, 2015 at 7:56

Mysteryos

5,8013 gold badges35 silver badges54 bronze badges

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

5 Comments

Marco Over a year ago

please could you explain more about your latest comment above?

Mysteryos Over a year ago

You are echoing a json encoded $data variable, whereby the $data['booking'] contains your DB result. Translating the array to JSON, booking becomes an attribute of your result object, hence the result.booking.

Marco Over a year ago

i got it, i guess its better to return the array from model directly to result object instead of using multiple objects. thank you @Mysteryos

Mysteryos Over a year ago

Indeed. Also, i would recommend you step away from CodeIgniter's active record. It may be good for simple stuff, but has no alternative for complex mySQL queries. Go with raw mySQL and bring uniformity to your codebase.

Marco Over a year ago

thank you @Mysteryos for the hints and advices, appreciate it :)

Collectives™ on Stack Overflow

codeigniter access data array in ajax success function

1 Answer 1

5 Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

5 Comments

Your Answer

Sign up or log in

Post as a guest

Related