Hi Michael,

Sorry but I’m Italian, I’m using a translator.

Can you tell me how I should set this script to my database?

I downloaded the package and I hosted on my site, I configured the “mysql_connect.php” but if I go on the “index.php” can not display the drag & drop.

Ok, i saw the file:

Now what are the tables that I create?

Thanks in advance.

Ok, thanks but now I put to you that you saved positions do I do?
On the index.php not save ..

So:

/* mysql_query(“INSERT INTO blocks (block_id, column_id, order_id) VALUES (‘{$block_id}’, ‘{$column_id}’, {$order_id})”); */

and this:

/* mysql_query(“UPDATE blocks SET block_id = ‘{$block_id}’, column_id = ‘{$column_id}’, order_id = {$order_id} WHERE unique_id = “.$block_exists[0]); */

PS= Sorry if you do not waste time but are very experienced like you!

HELP, please Michael!

Ok, ho levato quelle stringhe e il block_save.php è così:

$block_id) {

/* check if the block is already present in the database */
$block_exists = mysql_fetch_row(mysql_query(“SELECT * FROM blocks WHERE block_id = ‘{$block_id}’”));

/* if not, we insert it */
if ($block_exists == FALSE) {

echo date(“h:i:s”) . ” – Moved block: {$block_id} to column: {$column_id} and updated rank to: {$order_id}“;
}
/* or else we update it */
else {
echo date(“h:i:s”) . ” – Moved block: {$block_id} to column: {$column_id} and updated rank to: {$order_id}“;
}
}

}

?>

Quando vado sulla index, nonostante abbia aggiornato la pagina i box non rimangono nella stessa posizione e non si salvano!

Come mai?

Sorry i don’t have translate!! XD

This is the code that I find myself in block_save.php

When I go on the index, although it has updated the page, the boxes do not stay in one place and not saved!

Why?

Don’t work!

Michel Hiemstra:

@Marco,
I do not understand italian but you REMOVED the lines, you have to UNCOMMENT them.
So this is the code:
< ?php
/* establish the mysql connection */
require_once 'mysql_connect.php';
$data = $_POST;
foreach ($data as $row) {
/* split up in segments */
$segments = explode(':', $row);
/* define the column */
$column_id = $segments[0];
/* the blocks */
$blocks = explode(',', $segments[1]);
/* we take each block */
foreach ($blocks as $order_id => $block_id) {
/* check if the block is already present in the database */
$block_exists = mysql_fetch_row(mysql_query("SELECT * FROM blocks WHERE block_id = '{$block_id}'"));
/* if not, we insert it */
if ($block_exists == FALSE) {
mysql_query("INSERT INTO blocks (block_id, column_id, order_id) VALUES ('{$block_id}', '{$column_id}', {$order_id})");
}
/* or else we update it */
else {
mysql_query("UPDATE blocks SET block_id = '{$block_id}', column_id = '{$column_id}', order_id = {$order_id} WHERE unique_id = ".$block_exists[0]);
}
}
}
?>

I have that code on block_save.php replaced, but it does not! HELP ME!

Michel Hiemstra:

I’m sorry mate but that should work perfectly. Are you sure the connection to the mysql database was established? Check the ajax response with firebug or some tool to verify.
It should work that way.

When I try to move a box on the toolbar of the information I get this code:

$block_id) { /* check if the block is already present in the database */ $block_exists = mysql_fetch_row(mysql_query(“SELECT * FROM blocks WHERE block_id = ‘{$block_id}’”)); /* if not, we insert it */ if ($block_exists == FALSE) { mysql_query(“INSERT INTO blocks (block_id, column_id, order_id) VALUES (‘{$block_id}’, ‘{$column_id}’, {$order_id})”); } /* or else we update it */ else { mysql_query(“UPDATE blocks SET block_id = ‘{$block_id}’, column_id = ‘{$column_id}’, order_id = {$order_id} WHERE unique_id = “.$block_exists[0]); } } } ?> $block_id) { /* check if the block is already present in the database */ $block_exists = mysql_fetch_row(mysql_query(“SELECT * FROM blocks WHERE block_id = ‘{$block_id}’”)); /* if not, we insert it */ if ($block_exists == FALSE) { mysql_query(“INSERT INTO blocks (block_id, column_id, order_id) VALUES (‘{$block_id}’, ‘{$column_id}’, {$order_id})”); } /* or else we update it */ else { mysql_query(“UPDATE blocks SET block_id = ‘{$block_id}’, column_id = ‘{$column_id}’, order_id = {$order_id} WHERE unique_id = “.$block_exists[0]); } } } ?>

Michel Hiemstra:

@Marco
Did your save file start with <!–?php
Or does your server even support PHP?

My server support the PHP.
I don’t understand this:
Did your save file start with (???)

Sorry..

Michel Hiemstra:

@Marco
Did your save file start with <!–?php
Or does your server even support PHP?

My block_save.php file start with

< ?php