bsydz2
01-29-2007, 12:06 AM
This is driving me nuts...
using the scriptalicious library to handle an ajax request, and the serialized array i'm passing to the php page (via POST) isn't being parsed properly by the foreach loop i have in place. It works perfectly on two testing environments, and on a different host, so i think i may just need to set a variable in my php,ini, but i can't figure it out...
the javascript function i'm using on the first page is below:
function updateOrder(){
var options = {
method : 'post',
parameters : Sortable.serialize('item_list')
};
new Ajax.Request('reorder.php', options);
}
the php page:
<? my connection string ?>
<?
$i=1;
foreach($_POST['item_list'] as $key=>$value) {
$q_order = "UPDATE table SET the_order = ".$i." WHERE id =".$value;
mysql_query($q_order, $db->query);
$i++;
}
?>
Someone had suggested exploding what should be an array on the php page into an array itself (implying perhaps the posted value was being interpreted as a string instead of an array), but that didn't work.
Any help or insight at all would be huge.
Thanks in advance.
using the scriptalicious library to handle an ajax request, and the serialized array i'm passing to the php page (via POST) isn't being parsed properly by the foreach loop i have in place. It works perfectly on two testing environments, and on a different host, so i think i may just need to set a variable in my php,ini, but i can't figure it out...
the javascript function i'm using on the first page is below:
function updateOrder(){
var options = {
method : 'post',
parameters : Sortable.serialize('item_list')
};
new Ajax.Request('reorder.php', options);
}
the php page:
<? my connection string ?>
<?
$i=1;
foreach($_POST['item_list'] as $key=>$value) {
$q_order = "UPDATE table SET the_order = ".$i." WHERE id =".$value;
mysql_query($q_order, $db->query);
$i++;
}
?>
Someone had suggested exploding what should be an array on the php page into an array itself (implying perhaps the posted value was being interpreted as a string instead of an array), but that didn't work.
Any help or insight at all would be huge.
Thanks in advance.