PHP文件如下: <?php /*
*/ require("../../class/connect.php"); require("../../class/db_sql.php"); require("../../data/dbcache/class.php"); $link=db_connect(); $empire=new mysqlquery(); $return=array();
if($_GET['title']!=strip_tags($_GET['title'])){ $return['msg']=0; $return['text']="<span style='color:#f00'>非法字符已被清空!</span>"; echo json_encode($return); exit; }; $title=RepPostVar($_GET['title']); $classid=intval($_GET['classid']); $id=intval($_GET['id']); $tbname=$class_r[$classid][tbname]; if(strlen($title)<1||strlen($title)>100){ $return['msg']=1; $return['text']=""; echo json_encode($return); exit; }else{ $w=$empire->gettotal("select count(*) as total from {$dbtbpre}ecms_$tbname where title='$title' and id<>$id limit 1"); if(!$w){ $return['msg']=2; $return['text']="<span style='color:#808080'><b>^_^没重复<b></span>"; echo json_encode($return); exit; }else{ $return['msg']=7; $return['text']="<span style='color:#f00'><b>标题重复!<b></span>"; echo json_encode($return); exit; } } db_close(); $empire=null;
另: $w=$empire->gettotal("select count(*) as total from {$dbtbpre}ecms_$tbname where title='$title' and id<>$id limit 1"); 这哥语句后插入:
$w+=$empire->gettotal("select count(*) as total from {$dbtbpre}ecms_$tbname_check where title='$title' and id<>$id limit 1");
即可 chcek.js的内容如下:
$(function(){ if(!$('#msg_title').length){ $('input[name="title"]').parent('td').append('<span id="msg_title"><\/span>'); } $('input[name="title"]').blur(function(){ var $user_val=$(this).val(); this.value=this.value.replace(/[!!¥……*——+、#$%&'"\/\\=??。,《》<>·^`{|}~“”]|\s|\-|\(|\)|[\uff00-\uffff]/g,''); $.ajax({ type:"get", url:"/e/extend/oneTitle/index.php?classid="+$('input[name="classid"]').val()+"&id="+$('input[name="id"]').val()+"&title="+$('input[name="title"]').val()+"&sid="+Math.random(), async:true, dataType:"json", success:function(data){ $('#msg_title').html(data['text']); return false; }, error:function(jqXHR){ alert('检测标题重复时出现错误,请检查相关文件路径'.url); return false; } }); }); }) 也不知道怎么做相应的修改.
|