json 增删改查 php,jQuery+json是否可以实现增删改查

notemanagestyle.css"rel="stylesheet"type="text/css"/>jquery-1.5.2.min.js">public.js">lhgdialog/lhgdialog.min.js">vartypes=newArray()

types[0]="推荐"types[1]="最新"types[2]="公告"types[3]="活动"vardialogtitle;vardlg;

$(document).ready(function(){

getdata();//页面载入时调用该方法，来获取JSON数据并插入到HTML中});functiongetdata(){

$("#td_totals").html("loading.gif\" style=\"position: relative;top: 8px;\" />数据载入中...");varajaxurl1="<?php echo url::site('operat/notemanage'); ?>?cmd=null&r="+Math.random();//这里是我的获取JSON数据的地址，获取到的格式如：[{"title":"我是第一个标题","type":"0","link":"xxxxxxxxx","date":"2011-04-29 14:17:14"},{"title":"我是第二个标题","type":"1","link":"xxxxxxxxxx","date":"2011-05-03 10:58:32"}]$.getJSON(ajaxurl1,function(data){if(data.length>0){varstr="

str+="

";

str+="

"+data[i]['title']+"";

str+="

"+types[data[i]['type']]+"";

str+="

"+data[i]['link']+"";

str+="

"+data[i]["date"]+"";

str+="

";

str+="编辑   ";

str+="删除";

str+="

";

str+="

";

}

str+="

";

$("#td_totals").html(str);//JS拼凑成HTML串，并插入到页面当中}else{

$("#td_totals").html("暂无数据！");

}

});

}//准备创建弹出窗口functioncreatpop(obj, cmd){switch(cmd){case"add":

dialogtitle="公告管理--->添加";

showpop(obj, cmd);break;case"edit":

dialogtitle="公告管理--->编辑";

showpop(obj, cmd);break;case"del":if(confirm("是否确定删除该公告？")){varparams=$.param({"id":obj,"cmd":cmd});

isajax(params);

}break;default:break;

}

}//弹出窗口functionshowpop(obj, cmd){

dlg=new$.dialog({

id:"notepop_"+obj,

title: dialogtitle,

width:500,

height:230,

resize:false,

cover:true,

btnBar:false,

html: creathtml(obj, cmd),//这里是生成弹出窗口中HTML的内容rang:true,

dgOnLoad:function(){if(cmd=="edit"){//这里，如果是编辑，就用刚JS生成的隐藏的文本域的值给弹出页面中文本框赋值$("#tbox_title_"+obj,dlg.topDoc).val($("#hid_title_"+obj).val());

$("#sel_type_"+obj,dlg.topDoc).val($("#hid_type_"+obj).val());

$("#tbox_link_"+obj,dlg.topDoc).val($("#hid_link_"+obj).val());

}

$("#dosubmit",dlg.topDoc).click(function(){//这个是弹出窗口中的确定按钮的触发事件varstitle=$("#tbox_title_"+obj,dlg.topDoc).val();varstype=$("#sel_type_"+obj,dlg.topDoc).val();varslink=$("#tbox_link_"+obj,dlg.topDoc).val();if(!val_empty(stitle)||!val_empty(slink)){

alert("有未填项！");returnfalse;

}varparams=$.param({"id":obj,"stitle":stitle,"stype":stype,"slink":slink,"cmd":cmd});//这里的id就是JSON中索引ID，从0开始，cmd就是告诉后台要执行的操作，其它值就是要生成JSON的值isajax(params);

});

}

});

dlg.ShowDialog();

}functioncreathtml(obj, cmd){varstr="

str+="

";

str+="

公告标题：";

str+="

";

str+="

";

str+="

";

str+="

公告类型：";

str+="

";

str+=""+types[0]+""+types[1]+""+types[2]+""+types[3]+"";

str+="

    ";

str+="

";

str+="

";

str+="

";

str+="

公告链接：";

str+="

";

str+="

";

str+="";

str+="

";

str+="

";

str+="

";

str+="

";returnstr;

}functionisajax(params){varajaxurl1="<?php echo url::site('operat/notemanage'); ?>?"+params+"&r="+Math.random();//用AJAX再次提交给后台进行操作$.get(ajaxurl1,function(data){if(data=="1"){

alert("操作成功！");

getdata();

}else{

alert("操作失败！");

}

dlg.cancel();

});

}

游戏内公告管理 公告标题公告类型公告链接发布时间操作