How to send the jquery array value to codeigniter controller

Question

I am passing an array through jQuery like this

$.ajax({
    url: "<?php echo base_url();?>index.php/autocomplete/test_search?added_ids[]="+ids,

.....

Here is the network text from chrome

..../autocomplete/test_search?added_ids[]=5190,3574,5369&term=s

I have to catch this array in my controller to run a query like

$selected = $this->input->get('added_ids');

$this->db->select('first_nm, last_nm , title');
$this->db->where_not_in('my_id', $selected);

But for the first entry in the array it is working. The next element are not being excluded in the where_not_in section. Can you please help me where am I doing it wrong?

Pass it as a string & than convert the values into an array using implode or join function. — Rikesh
– Rikesh, Commented Jan 9, 2014 at 13:55

Rohit Agrawal · Accepted Answer · 2014-01-09 13:59:20Z

1

use -

ids.join(", ");

and pass them as a string

answered Jan 9, 2014 at 13:59

Rohit Agrawal

5,5305 gold badges21 silver badges30 bronze badges

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

Comments

Pranav C Balan · Accepted Answer · 2014-01-09 14:02:17Z

1

In your Ajax call

$.ajax({
    url: "<?php echo base_url();?>index.php/autocomplete/test_search?added_ids="+ids.join("_"),

In controller

$selected = $this->input->get('added_ids');
$selected=explode('_',$selected);

$this->db->select('first_nm, last_nm , title');
$this->db->where_not_in('my_id', $selected);

You can use .join() to combine array elements .In your controller you can get element by using explode()

answered Jan 9, 2014 at 14:02

Pranav C Balan

115k25 gold badges172 silver badges195 bronze badges

Comments

Nouphal.M · Accepted Answer · 2014-01-09 14:03:09Z

0

Try where_not_in() function expects an array not a string.

$selected = $this->input->get('added_ids');
 $ids = explode(',',$selected[0]);
 $this->db->select('first_nm, last_nm , title');
 $this->db->where_not_in('my_id', $ids);

more info here

answered Jan 9, 2014 at 14:03

Nouphal.M

6,3281 gold badge20 silver badges28 bronze badges

Collectives™ on Stack Overflow

How to send the jquery array value to codeigniter controller

3 Answers 3

Comments

Comments

Comments

Hot Network Questions

Collectives™ on Stack Overflow

3 Answers 3

Comments

Comments

Comments

Related