tp5ajax即点即改,TP5中即点即改，json分页，单删

HTML页面：

content="width=device-width, user-scalable=no, initial-scale=1.0, maximum-scale=1.0, minimum-scale=1.0">

Document

位置

房源

房源面积

计租面积

户型

建筑结构

租赁性质

状态

{switch name="$list.u_name"}

{case value="root"}

操作{/case}

{case value="admin"}{/case}

{/switch}

{volist name="list.data" id="v"}

{$v.f_wei}

{switch name="$list.u_name"}

{case value="root"}

{$v.f_name}{/case}

{case value="admin"}

{$v.f_name}{/case}

{/switch}

{$v.f_mian}{$v.f_ji}{$v.f_hu}{$v.f_jian}{$v.f_zu}{$v.f_static}

{switch name="$list.u_name"}

{case value="root"}

删除{/case}

{case value="admin"}{/case}

{/switch}

{/volist}

首页

上一页

下一页

尾页

//即点即改

$(document).on("dblclick",".ww",function () {

var fd_val=$(this).attr("fd");

var html_val=$(this).text();

var id=$(this).parents("tr").attr("id");

//替换

$(this).html('')

$("#"+fd_val+html_val).blur(function () {

var new_val=$(this).val();

$(this).parents("td").text(new_val);

//请求

$.post(

"{:url('access/ji_gai')}",

{

id:id,

new_val:new_val,

fd_val:fd_val

},

function (data) {

}

)

})

})

//分页

$(document).on("click",".pre",function () {

var pre=$(this).text();

var shou_page=$(".shou_page").val();

var wei_page=$(".wei_page").val();

var p="";

if(pre=="首页")

{

p=1;

}else if(pre=="上一页")

{

p=parseInt(shou_page)-1<1?1:parseInt(shou_page)-1;

}else if(pre=="下一页")

{

p=parseInt(shou_page)+1>wei_page?wei_page:parseInt(shou_page)+1;

}else if(pre=="尾页")

{

p=wei_page;

}

//请求

$.post(

"{:url('access/show_json')}",

{

page:p

},

function (data) {

var res=JSON.parse(data)

var res_list=res.data

var name=res.u_name

if(name=="root")

{

var aa='

删除';

var bb='class="ww" fd="f_name"';

}

var str="";

$.each(res_list,function (k, v) {

str+='

';

str+='

'

str+='

'+v.f_wei+''

str+='

'+v.f_name+''

str+='

'+v.f_mian+''

str+='

'+v.f_ji+''

str+='

'+v.f_hu+''

str+='

'+v.f_jian+''

str+='

'+v.f_zu+''

str+='

'+v.f_static+''

str+=''+aa+'';

str+='

';

})

$(".tby").html(str)

$(".shou_page").val(p)

}

)

})

//删除

$(document).on("click",".shan",function () {

var id=$(this).parents("tr").attr("id");

//请求

$.post(

"{:url('access/dan_del')}",

{

id:id

},

function (data) {

var re=JSON.parse(data)

if(re==1)

{

alert("单删成功")

document.getElementById(id).remove();

}else if(re==2)

{

alert("单删失败")

}

}

)

})

PHP页面：

namespace app\index\controller;

use think\Controller;

use think\Db;

use think\Request;

use think\Session;

use app\index\model\Fang_yuan;

use app\index\controller\Commen;

class Access extends Commen

{

//页面分页展示

public function fang_list()

{

$user=Session::get("user",'think');

$u_name=$user['u_name'];

$p=Request::instance()->param("page");

$page=empty($p)?1:$p;

$count=Db::table("fang_yuan")->count();

$tiao=3;

$zong_page=ceil($count/$tiao);

$limit=($page-1)*$tiao;

$data=Db::table("fang_yuan")->limit($limit,$tiao)->select();

$list=['data'=>$data,'zong_page'=>$zong_page,'u_name'=>$u_name];

return view("show",['list'=>$list]);

}

//分页的json格式

public function show_json()

{

$user=Session::get("user",'think');

$u_name=$user['u_name'];

$p=Request::instance()->param("page");

$page=empty($p)?1:$p;

$count=Db::table("fang_yuan")->count();

$tiao=3;

$zong_page=ceil($count/$tiao);

$limit=($page-1)*$tiao;

$data=Db::table("fang_yuan")->limit($limit,$tiao)->select();

$list=['data'=>$data,'zong_page'=>$zong_page,'u_name'=>$u_name];

echo json_encode($list);

}

//单删

public function dan_del()

{

$id=Request::instance()->param("id");

$aa=new Fang_yuan();

$a=$aa->del($id);

if($a)

{

echo json_encode(1);

}else{

echo json_encode(2);

}

}

//即点即改

public function ji_gai()

{

$id=Request::instance()->param("id");

$new_val=Request::instance()->param("new_val");

$fd_val=Request::instance()->param("fd_val");

$a=Db::table("fang_yuan")->where("f_id='$id'")->update(["$fd_val"=>"$new_val"]);

if($a)

{

return 1;

}else{

return 2;

}

}

}