English 中文(简体)
j Query Linked Sortable Lists, Save Order to MySQL
原标题:jQuery Connected Sortable Lists, Save Order to MySQL

想像这种变幻灯一样,有可能在两栏内和两栏之间 d取物品,并更新其订单,要么生活,要么与MySQL的“勇敢”纽扣。 指出你可以作改动,然后返回网页,查看或更新你的命令。

rel=“noretinger”>http://pilotmade.com/examples/draggable/

仅一栏就算是罚款,但当我试图通过两栏的次序时,这个问题似乎通过多个序列式阵列,把 j子带入PHP/MySQL更新的文字。

任何见解都会受到高度赞赏。

如果你看下面的话,我要说......

类型1

表2

EDIT:这最后是trick。

传真

<ol id="sortable1"><li id="entry_####">blah</li></ol>

页: 1 学历

<script type="text/javascript">
$(function() 
{
    $("#sortable1, #sortable2").sortable(
    {
        connectWith:  .connectedSortable ,
        update : function () 
        { 
            $.ajax(
            {
                type: "POST",
                url: "phpscript",
                data: 
                {
                    sort1:$("#sortable1").sortable( serialize ),
                    sort2:$("#sortable2").sortable( serialize )
                },
                success: function(html)
                {
                    $( .success ).fadeIn(500);
                    $( .success ).fadeOut(500);
                }
            });
        } 
    }).disableSelection();
});

这就是PHP的询问。

parse_str($_REQUEST[ sort1 ], $sort1);
foreach($sort1[ entry ] as $key=>$value)
{
do stuff
}
最佳回答

我会做的是分裂他们。

   data    :
    {
      sort1:$( #sortable1 ).sortable( serialize ),
      sort2:$( #sortable2 ).sortable( serialize )
    }

那么,当你担任你职务时,我就希望你能够提出请求,并根据需要确定请求。

因此,我这样做了。

parse_str($_REQUEST[ sort1 ],$sort1); 

foreach($sort1 as $key=>$value){
    //do sutff;
}
问题回答

暂无回答




相关问题
SQL SubQuery getting particular column

I noticed that there were some threads with similar questions, and I did look through them but did not really get a convincing answer. Here s my question: The subquery below returns a Table with 3 ...

please can anyone check this while loop and if condition

<?php $con=mysql_connect("localhost","mts","mts"); if(!con) { die( unable to connect . mysql_error()); } mysql_select_db("mts",$con); /* date_default_timezone_set ("Asia/Calcutta"); $date = ...

php return a specific row from query

Is it possible in php to return a specific row of data from a mysql query? None of the fetch statements that I ve found return a 2 dimensional array to access specific rows. I want to be able to ...

Character Encodings in PHP and MySQL

Our website was developed with a meta tag set to... <meta http-equiv="Content-Type" content="text/html; charset=iso-8859-1" /> This works fine for M-dashes and special quotes, etc. However, I ...

Pagination Strategies for Complex (slow) Datasets

What are some of the strategies being used for pagination of data sets that involve complex queries? count(*) takes ~1.5 sec so we don t want to hit the DB for every page view. Currently there are ~...

Averaging a total in mySQL

My table looks like person_id | car_id | miles ------------------------------ 1 | 1 | 100 1 | 2 | 200 2 | 3 | 1000 2 | 4 | 500 I need to ...

热门标签