Welcome Guest, Not a member yet? Register   Sign In
Getting array parameters from POST
#1

[eluser]derekt[/eluser]
I'm writing a page to reorder images using JQuery and Ajax to POST the image order back to my controller so I can update the database; I've got the page returning this via POST:

POST
item[] 17
item[] 1
item[] 9

However, the database isn't updating. I'd really appreciate some advice on what I'm missing here. The controller function looks like this:

Code:
function index ()
    {
        foreach($this->input->post('item',TRUE) as $key=>$value):
        {
                $this->db->where('id', $value)->update('photo_order_map', array ('sort_order'=>$key));
        }
    }

I tried setting $config['enable_query_strings'] = TRUE; to no avail.
Any suggestions??

Thanks!
#2

[eluser]umefarooq[/eluser]
first get the value of your post data and then loop

Code:
$sorts = $this->input->post('item');

foreach($sorts as $key=>$value){
$this->db->where('id', $value)->update('photo_order_map', array ('sort_order'=>$key));
}
#3

[eluser]derekt[/eluser]
Worked like a charm- many thanks umefarooq!
#4

[eluser]saidai jagan[/eluser]
yeah thats fine Smile




Theme © iAndrew 2016 - Forum software by © MyBB