TP3.2 数据排序

数据库里有 gpx 的字段

视图代码

<a class="button button-small border-blue" href="JavaScript:vol()" onclick="gpx()">排序</a>

<tr class="list">
	<td>
	    <input type="checkbox" class="plsc" name="id" value="{$v.id}" />
	</td>						
	<td>

            <input size="3" type="text" name="gpx[]" value="{$v.gpx}">

        </td>

</tr>

<script>
//排序
	function gpx(){
		var order_list=[];
		var id_val=[];
		$(".list :text").each(function(){
			order_list.push($(this).val());
		})

		$(".list :checkbox").each(function(){
			id_val.push($(this).val());
		})

		url = "__URL__/goods_px";
		data = {gpx:order_list,id:id_val};
		
		$.post(url,data,function(res){
			if(res){ 
				layer.msg("更新成功！");window.location.href="__URL__/goods";
			}
		})
	}
</script>

控制器代码

//新闻排序 -- 排序  
    public function goods_px()
    {   //排序更新
        $db = M("goods");
        $data = array_combine($_POST["id"],$_POST["gpx"]);

        foreach($data as $key => $val){
            $_POST["id"] = $key;
            $_POST["gpx"] = $val;
            if($db -> create()){
                $db -> save();
            }
        }
        $this -> redirect("goods");
    }