Oh, man! It's been so long since I wrote PHP/MySQL long-hand, so you'll just 
have to translate this example for yourself. Take it as written, and just try 
to abstract out the magic of my ORM layer.

table: widgets
        id              int(11) primary key, auto-incrementing
        name    varchar(255)
        position        int(11)

index.php: https://gist.github.com/1341161

save_sort_order.php: https://gist.github.com/1341162

http://scripty.walterdavisstudio.com/sortable/

Walter

On Nov 4, 2011, at 7:03 PM, Joel B wrote:

> Thanks, 
> 
> I'm using PHP/mySql. I found one good example this morning, finally,(several 
> years old though) and have it 90% bolted onto my web app, with a few bugs 
> left to stamp out (for some reason, drag&drop isn't changing the last row in 
> the db)
> 
> Any examples that are straight PHP/mySql would be helpful in learning. I 
> haven't had a project that requires me to use ruby or rails yet, so I know 
> very little about the syntax.
> 
> Joel
> http://www.musiclouds.com
> Premium Roku Channel Development 
> 
> Sent from my iPhone 
> 
> On Nov 4, 2011, at 7:25 AM, Walter Lee Davis <[email protected]> wrote:
> 
>> The Scriptaculous Wiki on Github has examples on the Sortable Serialize 
>> page, IIRC.
>> 
>> What (if any) server-side framework are you using? I can show code for Rails 
>> or my own PHP Rails-lite clone.
>> 
>> Walter
>> 
>> On Nov 3, 2011, at 5:30 PM, joelbrave wrote:
>> 
>>> Are there any examples I can see for integrating the various effects
>>> with a MySQL database, specifically, re-ordering database rows via
>>> drag and drop?
>>> 
>>> - Joel
>>> 
>>> -- 
>>> 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.
>>> 
>> 
>> -- 
>> 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.
>> 
> 
> -- 
> 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.
> 

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

Reply via email to