asked on

Web application advice (PHP / SQL)

Hello,

I'm looking to create a web based application that will give a user a list of available items (picked up from SQL) - but i'd like to try and improve on using html forms to pass data around.

My goal is to have a list of available items on the left, and a workspace on the right - then be able to drag the items (either in text form, or boxes) to the otherside - when the user drags an item across, a few sql queries need to be processed (editing the data to show its been taken)

Can anyone point me in the right direction - just need some info on the best way to create that - i'm guessing AJAX - but is there anything else that will get me a bit further than that (ideally drag and drop / html5) - sample code / examples / tutorials would be good :)

Thanks

ASKER CERTIFIED SOLUTION

Ray Paseur

membership

This solution is only available to members.

To access this solution, you must be a member of Experts Exchange.

Start Free Trial

Member_2_248744

greetings Bergstr, , You outline a DHTML Graphical User Interface, that does a user Drag-and-Drop to "Update" a receiver-Box (<div>) on the right. This alone (NO SERVER AJAX) will require at least mid level Javascript knowledge and some trial and error WORK, even if you use a javascript framework like Jquery or MooTools. Your best bet is to work on this one step at a time in Javascript, to first perfect your user Drag-and-Drop in javascript, and then move on to your other javascript functional aspects like AJAX.

This in total, with the Server Mysql and Ajax is more that should be asked in a single question here.

Bergstr

ASKER

Thanks very much for both your comments :)

The jquery looks like what I'm after! - I've also come across this guide using DHTML / AJAX:
http://www.dhtmlgoodies.com/scripts/drag-drop-nodes/drag-drop-nodes-demo2.html

I'll look into both of these and see what I end up with, pretty sure with this info I can produce what I need :)

Thanks again.

Ray Paseur

Thanks for using EE and thanks for the points. And best of luck with your project, ~Ray