📄 leibie.php
字号:
<?php
require("../mysql.inc.php");
?>
<?php
$action=$_REQUEST["action"];
$xclassid=$_REQUEST["xclassid"];
$xclassname=$_REQUEST["xclassname"];
$leibieid=$_REQUEST["leibieid"];
$xverity=$_REQUEST["xverity"];
$xclassid=$_REQUEST["xclassid"];
$deleteid=$_REQUEST["deleteid"];
$xtopclass=$_REQUEST["xtopclass"];
session_start();
$isadmin=$_SESSION["isadmin"];
if ($isadmin!=true) {
header("location:index.php?u=$admin");exit();
}
?>
<?php
$get_leibie=mysql_query("select classid,classname,level from wz_fenlei");
$yi=0;
while ($yy=mysql_fetch_array($get_leibie)) {
$leibie[$yi]["id"]=$yy["classid"];
$leibie[$yi]["name"]=$yy["classname"];
$leibie[$yi]["level"]=$yy["level"];
$yi++;
}
function get_substr($ss,$arrayy) {
global $leibie;
for ($j=0;$j<count($leibie);$j++) {
if ($leibie[$j]["id"]==$arrayy) {
$xss=$ss." -[".$leibie[$j]["name"]."]子类";
return $xss;
}
}
return $ss;
}
if ($action=="modify") {
//echo "$xclassid<br>$xclassname<br>$leibieid<br>$xverity";
if ($xclassid!="" && $xclassname!="" && $leibieid!="" && $xverity!="" && $xclassid!=$leibieid) {
$level=1;
for ($l=0;$l<count($leibie);$l++) {
if ($leibie[$l]["id"]==$leibieid) {
$level=$leibie[$l]["level"]+1;
}
}
mysql_query("update wz_fenlei set classname='$xclassname',topclass=$leibieid,verity=$xverity,level=$level where classid=$xclassid");
}
//exit();
$get_leibie=mysql_query("select classid,classname,level from wz_fenlei");
$yi=0;
while ($yy=mysql_fetch_array($get_leibie)) {
$leibie[$yi]["id"]=$yy["classid"];
$leibie[$yi]["name"]=$yy["classname"];
$leibie[$yi]["level"]=$yy["level"];
$yi++;
}
}
if ($action=="add") {
//echo "$xclassid<br>$xclassname<br>$leibieid<br>$xverity";
$count=$_REQUEST["count"];
if ($count!="") {
for ($n=0;$n<=$count;$n++) {
$xclassname="xclassname".$n;
$xtopclass="xleibieid".$n;
$xverity="xverity".$n;
if ($_REQUEST[$xclassname]!="" && $_REQUEST[$xtopclass]!="" && $_REQUEST[$xverity]!="") {
//echo "0000";
$level=1;
for ($m=0;$m<count($leibie);$m++) {
if ($leibie[$m]["id"]==$_REQUEST[$xtopclass]) {
$level=$leibie[$m]["level"]+1;
}
}
mysql_query("insert into wz_fenlei(classname,topclass,verity,level) values('".$_REQUEST[$xclassname]."',".$_REQUEST[$xtopclass].",".$_REQUEST[$xverity].",".$level.")");
//echo $$xclassname."<br>";
//echo $$xtopclass."<br>";
//echo $$xverity."<br>";
}
}
}
//exit();
$get_leibie=mysql_query("select classid,classname,level from wz_fenlei");
$yi=0;
while ($yy=mysql_fetch_array($get_leibie)) {
$leibie[$yi]["id"]=$yy["classid"];
$leibie[$yi]["name"]=$yy["classname"];
$leibie[$yi]["level"]=$yy["level"];
$yi++;
}
}
if ($action=="delete") {
if ($deleteid!="") {
mysql_query("delete from wz_fenlei where classid=".$deleteid);
}
//exit();
$get_leibie=mysql_query("select classid,classname,level from wz_fenlei");
$yi=0;
while ($yy=mysql_fetch_array($get_leibie)) {
$leibie[$yi]["id"]=$yy["classid"];
$leibie[$yi]["name"]=$yy["classname"];
$leibie[$yi]["level"]=$yy["level"];
$yi++;
}
}
$subselect="<option value=\"0\">没有选择类别</option>";
for ($i=0;$i<count($leibie);$i++) {
$leibiestr=$leibie[$i]["name"];
if ($leibie[$i]["level"]!=1) {
$temp2=mysql_query("select topclass from wz_fenlei where classid=".$leibie[$i]["id"]);
if ($temp2) {
$temp3=mysql_fetch_array($temp2);
if (is_array($temp3)) {
$leibiestr=get_substr($leibiestr,$temp3["topclass"]);
}
}
}
else {
$leibiestr=$leibiestr."（一级分类）";
}
$subselect.="<option value='".$leibie[$i]["id"]."'".$selected.">".$leibiestr."</option>";
}
$subselect.="</select>";
$allselect="<select name=\"leibieid\">".$subselect;
$allselect=addslashes($allselect);
$subselect=addslashes($subselect);
?>
<HTML>
<HEAD>
<TITLE>网址类别管理</TITLE>
<META NAME="Generator" CONTENT="EditPlus">
<META NAME="Author" CONTENT="">
<META NAME="Keywords" CONTENT="">
<META NAME="Description" CONTENT="">
<?php
echo "<Script Language='JavaScript'>allselect='$allselect';subselect='$subselect';</Script>"."\n";
?>
<style type="text/css">
body {font-size:13px}
td {font-size:13px;}
input {
COLOR: #000000; FONT-FAMILY: Verdana, Arial, Helvetica, sans-serif; FONT-SIZE: 12px
}
button {
COLOR: #000000; FONT-FAMILY: Verdana, Arial, Helvetica, sans-serif; FONT-SIZE: 12px
}
.fh {
BACKGROUND: #d0d0d0; COLOR: #000000; FONT-WEIGHT: bold
}
</style>
</HEAD>
<BODY>
<Script Language="JavaScript">
function editrow(tbid,row,classname,topclassid,verity,classid) {
var tbobj=document.all(tbid);
var old1=tbobj.rows[row].cells[1].innerHTML;
tbobj.rows[row].cells[1].innerHTML= "<input type='hidden' value='"+old1+"'><input style='width:95%' class=\"inputText\" name='xclassname' value=\"" + classname + "\">";
var old2=tbobj.rows[row].cells[2].innerHTML;
tbobj.rows[row].cells[2].innerHTML= "<input type='hidden' value='"+old2+"'>"+allselect;
tbobj.rows[row].cells[2].children[1].value=topclassid;
var old3=tbobj.rows[row].cells[3].innerHTML;
tbobj.rows[row].cells[3].innerHTML= "<input type='hidden' value='"+old3+"'>"+"<input type='radio' name='xverity' value='1' id='xverity1_"+classid+"'>1 <input type='radio' name='xverity' value='0' id='xverity0_"+classid+"'>0";
if (verity==1) document.all("xverity1_"+classid).click();
if (verity==0) document.all("xverity0_"+classid).click();
var old4=tbobj.rows[row].cells[4].innerHTML;
tbobj.rows[row].cells[4].innerHTML= "<input type='hidden' value=''><input type=\"submit\" value=\"提交\" class=\"inputText\"> <button onclick=\"rerow("+row+","+tbid+");return false\">取消</button>";
tbobj.rows[row].cells[4].children[0].value=old4;
//alert(tbobj.rows[row].cells[4].innerHTML);
return false;
}
function addrow(tbid,formx) {
var tbobj=document.all(tbid);
var form=document.all(formx);
form.sbt.disabled = false;
var ct = parseInt(form.count.value);
form.count.value = ct + 1;
var row = tbobj.insertRow(tbobj.rows.length-1);
row.Name="row"+ct;
var col = row.insertCell(0);
col.innerHTML = "(自动)";
col = row.insertCell(1);
col.innerHTML = "<input name='xclassname" + ct + "' style='width: 90%;' class=\"inputText\">";
col = row.insertCell(2);
col.innerHTML = "<select name='xleibieid" + ct + "'>"+subselect;
col = row.insertCell(3);
col.innerHTML = "<input type='radio' name='xverity"+ct+"' value='1'>1 <input type='radio' name='xverity"+ct+"' value='0' checked>0";
col = row.insertCell(4);
col.innerHTML = "<a href='#cancel' onclick=\"delrow('"+tbid+"','"+row.Name+"','"+formx+"');return false;\">取消添加此行</a>";
//alert(row.Name);
return false;
}
function delrow(tbid,xxx,f) {
var tbobj=document.all(tbid);
var fo=document.all(f);
deleterowcount=0;
for (var j=0;j<tbobj.rows.length;j++) {
if (tbobj.rows[j].Name==xxx) {
tbobj.deleteRow(j);deleterowcount++;
var ct = parseInt(fo.count.value);
fo.count.value = ct - 1;
if (parseInt(fo.count.value)<1) fo.sbt.disabled = true;
}
}
}
function rerow(row,tbobj) {
tbobj.rows[row].cells[1].innerHTML=tbobj.rows[row].cells[1].children[0].value;
tbobj.rows[row].cells[2].innerHTML=tbobj.rows[row].cells[2].children[0].value;
tbobj.rows[row].cells[3].innerHTML=tbobj.rows[row].cells[3].children[0].value;
tbobj.rows[row].cells[4].innerHTML=tbobj.rows[row].cells[4].children[0].value;
return false;
}
function check(isme) {
if (isme.xclassname=="") {
alert("类别名字不能为空！");return false;
}
return true;
}
</Script>
<table width="100%" id="listtb">
<tr>
<td class="fh">类别ID</td>
<td class="fh" width="150">类别名称</td>
<td class="fh">所属类别</td>
<td class="fh">审核*</td>
<td class="fh">操作</td>
</tr>
<?php
$s1=mysql_query("select classid,level,classname,topclass,verity from wz_fenlei order by level");
$ii=1;
while ($r1=mysql_fetch_array($s1)) {
list($classid,$level,$classname,$topclass,$verity)=$r1;
echo "<tr><form action='leibie.php' name='myform".$ii."' onsubmit='return check(this)'>";
echo "<td>$classid<input name='xclassid' value='$classid' type='hidden'></td>";
echo "<td>$classname</td>";
$topclassname="没有上级类别";
for ($k=0;$k<count($leibie);$k++) {
if ($leibie[$k]["id"]==$topclass) $topclassname=$leibie[$k]["name"];
}
echo "<td>$topclassname</td>";
echo "<td>$verity</td>";
echo "<td><A href='#' onclick=\"javascript:return editrow('listtb','".$ii."','".$classname."','".$topclass."','".$verity."','$classid'); return false;\">编辑</a> - <A href=\"leibie.php?action=delete&deleteid=".$classid."\" onclick='return confirm(\"确定删除？\")'>删除</A></td><input name='action' value='modify' type='hidden'></form></tr>";
$ii++;
}
?>
<FORM action="<?echo $PHP_SELF?>" method=POST name=formadd onsubmit=''>
<input name="count" type=hidden value=0>
<TR>
<TD class=formText colSpan=2><A
href="#add"
onclick="javascript:return addrow('listtb','formadd')">添加新的类别记录</A>
</TD>
<TD class=formText colSpan=3 align='center'><input type='hidden' name='action' value='add'><input type=submit disabled name=sbt class="inputText"> 注：只提交新加记录 </TD>
</TR>
</table>
<br><br>
*通过审核为1,未通过审核为0
<br>
注：未通过审核的类别不在前台显示（包括其下属分类及网站）
</BODY>
</HTML>
⌨️ 快捷键说明
复制代码
Ctrl + C
搜索代码
Ctrl + F
全屏模式
F11
切换主题
Ctrl + Shift + D
显示快捷键
?
增大字号
Ctrl + =
减小字号
Ctrl + -