What does your HTML look like? Are your list element IDs in the form
that Sortable requires?
<ul id="my_sortable_list">
<li id="someString_1">The visible draggable part</li>
<li id="someString_3">The visible draggable part</li>
<li id="someString_4">The visible draggable part</li>
</ul>
Unless your LIs have an ID and that ID begins with one or more letters
a-z, has exactly one underscore in it followed by a unique number
(which should be the ID column value from your database, just to tie a
bow on things here) then you won't get anything out of
Sortable.serialize() -- not even an error.
Walter
On Jun 13, 2009, at 12:29 PM, WLQ wrote:
>
> As you've noted the "post" should give you some feedback like this:
>
> whatever_your_list_ID_is = Array(
> 0 => 12,
> 1 => 13,
> 2 => 24,
> 3 => 2,
> 4 => 42
> )
>
> But it does not return any number on the other side:
>
> Array
> (
> [whatever_your_list_ID_is] => Array
> (
> [0] =>
> [1] =>
> [2] =>
> [3] =>
> )
>
> )
>
>
>> Yes, mysql_query doesn't return a list, it returns a resource
>> identifier. You have to create the list yourself using a loop and
>> mysql_fetch_object or mysql_fetch_array or one of the other
>> "fetchers".
>>
>> Before we go much further, I need to remind you that this is not a
>> PHP
>> list, and that those things do exist -- that's got to be one of the
>> best* explained languages on earth.
>>
>> The example I posted was working code ripped out of a busy site.
>> However it relies on the MyActiveRecord ORM to do anything.
>>
>> define('MYACTIVERECORD_CONNECTION_STR', 'mysql://user:p...@localhost/
>> databasename');
>> require_once('MyActiveRecord.0.5.php');
>> class widgets extends MyActiveRecord{}
>> $list = MyActiveRecord::FindAll('widgets',null,'position ASC');
>> foreach($list as $item){
>> //print_r($item);
>> //do what you want with $item->name, $item->description...
>>
>> }
>>
>> That is all there is to that. Anything else, I really recommend this
>> book: ISBN:0-672-31784-2 (may be -3 now, don't know what the current
>> version is). PHP and MySQL Web Development, by Luke Welling and Laura
>> Thomson. (SAMS)
>>
>> Walter
>>
>> *Where by "best" I simply mean "most".
>>
>> On Jun 13, 2009, at 9:04 AM, WLQ wrote:
>>
>>
>>
>>> I've followed your link and tried to build the list as you suggested
>>> there. But it gives me.
>>
>>> "ERRNO: 2 TEXT: Invalid argument supplied for foreach()
>>> LOCATION: ...,
>>> line 7"
>>> http://jsbin.com/elocu/edit
>>
>>>> Here's a list of problems. (I use database to drive the second
>>>> sortable too).
>>>> Now, if you drag an item from originals to clones any item but not
>>>> the
>>>> first, it will be cloned and "reverted". But you wont be able to
>>>> move
>>>> it (inside of cloned sortable), when you drag and drop one more
>>>> item,
>>>> that item wont move ass well, but previous dropped item apparently
>>>> receives the ability of being dragged. What is extremely weir.
>>>> Here's
>>>> one more weirdness, if you drag items from originals in order they
>>>> appear, then they will be cloned but won't be "reverted". I've also
>>>> added your print_r($_POST) to the update_order.php but it's giving
>>>> some unfair results.
>>>> I've uploaded the whole pack to a "some" website. Check it
>>>> outhttp://scriptaculous.host22.com/
>>
>>>> On Jun 8, 1:00 pm, Walter Lee Davis <[email protected]> wrote:
>>
>>>>> Gaaaaaa! I always get this backward. As Mr. Wonka would say,
>>>>> "Strike
>>>>> that; reverse it!"
>>
>>>>> whatever_your_list_ID_is = Array(
>>>>> 12 => 0,
>>>>> 13 => 1,
>>>>> 24 => 2,
>>>>> 2 => 3,
>>>>> 42 => 4
>>>>> )
>>
>>>>> Walter
>>
>>>>> On Jun 8, 2009, at 6:56 AM, Walter Lee Davis wrote:
>>
>>>>>> The data generated by Sortable.serialize looks like this after
>>>>>> PHP
>>>>>> grabs it from the POST:
>>
>>>>>> whatever_your_list_ID_is = Array(
>>>>>> 0 => 12,
>>>>>> 1 => 13,
>>>>>> 2 => 24,
>>>>>> 3 => 2,
>>>>>> 4 => 42
>>>>>> )
>>
>>>>>> The keys of the array give the position, the values give the
>>>>>> numerical
>>>>>> part of the list item ID. So in this case, the list looked like
>>>>>> this
>>>>>> in the DOM when serialize() wrapped it up:
> >
--~--~---------~--~----~------------~-------~--~----~
You received this message because you are subscribed to the Google Groups
"Prototype & script.aculo.us" group.
To post to this group, send email to [email protected]
To unsubscribe from this group, send email to
[email protected]
For more options, visit this group at
http://groups.google.com/group/prototype-scriptaculous?hl=en
-~----------~----~----~----~------~----~------~--~---
