[php] PHP+MySQL Drag and Drop

[S_Hannah]

Hi,

At present the PHP page reads the MySQL data and prints on screen and if the result if 'FREE' it shows a clickable image for the user to book. I am looking for something that allows the user to drag the result they fund to another location with in the table. I.e. user has box 1 filled with their name, they can drag their name to box 9 and it saves it, so they can go back on the it will be their.

 

If anyone knows where I can firn maybe a tutorial, or guide to get started with this, as I have looked and cannot see anything.

 

Cheers.

Stu

[InterwebsGuy]

You need to read up on either some JavaScript (jQuery is a good call for this) or HTML 5 drag and drop.

 

PHP has nothing to do with the dragging and dropping mark up, that will just handle the POST/GET requests from the JS.

 

Google it for a gazillion tutorials.

[zag]

You can do this with HTML5 now

 

http://html5demos.com/drag

[S_Hannah]

Hi,

Thank you for the responses, it has given me an idea of where to start on where to look. The reason I asked about its intergration into PHP was because our current booking system is driven by this and runs the mysql queries

and display through PHP.

 

Thanks again,

Stuart

[InterwebsGuy]

Hi,

Thank you for the responses, it has given me an idea of where to start on where to look. The reason I asked about its intergration into PHP was because our current booking system is driven by this and runs the mysql queries

and display through PHP.

 

Thanks again,

Stuart

No problem.

PHP would work fine, as would any server side language, it doesn't really matter what you use as generally when the item has been 'dropped', the d&d syntax will send a POST or GET request off to a script - PHP if you like - to handle the action. How the PHP script acts is entirely up to you, as it is just like handling any other form submission really.

 

There is more to it, but in a nutshell that is how something like that works.