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
-~----------~----~----~----~------~----~------~--~---
