📄 detail.php
字号:
<?php
require("../mysql.inc.php");
?>
<?
$action=$_REQUEST["action"];
$title=$_REQUEST["title"];
$url=$_REQUEST["url"];
$leibieid=$_REQUEST["leibieid"];
$pn=$_REQUEST["pn"];
$by=$_REQUEST["by"];
$word=$_REQUEST["word"];
$deleteid=$_REQUEST["deleteid"];
$id=$_REQUEST["id"];
session_start();
$isadmin=$_SESSION["isadmin"];
if ($isadmin!=true) {
header("location:index.php?u=$admin");exit();
}
if ($action=="delete") {
mysql_query("delete from wz_detail where id=$deleteid");
header("location:".getenv("HTTP_REFERER"));exit();
}
if ($action=="add") {
if ($title!="" && $url!="" && $leibieid!="") {
$thetime=date("Y-n-d H:i:s");
mysql_query("insert into wz_detail(title,url,classid,verity,time) values('$title','$url',$leibieid,1,'$thetime')");
header("location:detail.php?pn=".$pn);exit();
}
}
if ($action=="modify") {
if ($id!="" && $title!="" && $url!="" && $leibieid!="") {
mysql_query("update wz_detail set title='$title',url='$url',classid=$leibieid where id=$id");
header("location:".getenv("HTTP_REFERER"));exit();
}
}
?>
<HTML>
<HEAD>
<TITLE>网址添加修改</TITLE>
<META NAME="Generator" CONTENT="EditPlus">
<meta http-equiv="Content-Type" content="text/html; charset=gb2312">
<META NAME="Keywords" CONTENT="">
<META NAME="Description" CONTENT="">
<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
}
.formHeader {
BACKGROUND: #d0d0d0; COLOR: #000000; FONT-WEIGHT: bold
}
</style>
<?php
$rs=array("one","two","three","four","five");
$s=array("one","tow","three","four","five");
$get_leibie=mysql_query("select classid,classname,level from wz_fenlei where verity=1");
$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;
}
$select="<select name=\"leibieid\">";
$select.="<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."（一级分类）";
}
$select.="<option value='".$leibie[$i]["id"]."'".$selected.">".$leibiestr."</option>";
}
$select.="</select>";
$select=addslashes($select);
echo "<Script Language='JavaScript'>select_str='$select';</Script>"."\n";
?>
<Script Language="JavaScript">
function editrow(tbid,row,id,title,url,leibie) {
tbobj=document.all(tbid);
old1=tbobj.rows[row].cells[1].innerHTML;
tbobj.rows[row].cells[1].innerHTML= "<input type='hidden' value='"+old1+"'><input style='width:100%' class=\"inputText\" name='title' value=\"" + title + "\">";
old2=tbobj.rows[row].cells[2].innerHTML;
tbobj.rows[row].cells[2].innerHTML= "<input type='hidden' value='"+old2+"'><input style='width:300px' class=\"inputText\" name='url' value=\"" + url + "\">";
old3=tbobj.rows[row].cells[3].innerHTML;
tbobj.rows[row].cells[3].innerHTML= "<input type='hidden' value='"+old3+"'>"+select_str;
tbobj.rows[row].cells[3].children[1].value=leibie;
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 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;
}
</Script>
</HEAD>
<BODY>
<br>
<Script Language="JavaScript">
function check(xx) {
if (xx.title.value=="") {
alert("网站标题不能为空！");
return false;
}
if (xx.url.value=="") {
alert("网站url不能为空！");
return false;
}
if (xx.leibieid.value=="0") {
alert("网站类别不能为空！");
return false;
}
return true;
}
</Script>
<big>添加新网址</big>
<table width="100%" bordercolor="black" cellspacing="2" id="addtb">
<tr>
<form action="detail.php" method="get" onsubmit="return check(this)" name="form_add">
<td width="150" class='formHeader'>网站标题：</td><td class='formHeader'>网站url：</td><td width="150" class='formHeader'>类别名称：</td><td width="150" class='formHeader' nowrap>其他信息：</td><td width="100" class='formHeader'>操作</td>
</tr>
<tr>
<td>
<input name="title" style="width:150px"></td><td>
<input name="url" style="width:200px"></td>
<td>
<Script>document.write(select_str);</Script>
</td><td>
<input name="memo" style="width:100%"><br>
<input type="hidden" name="action" value="add">
</td><td nowrap>
<input type="submit" value="提交">
<input type="reset" value="重置"></td>
</form>
</tr>
<table>
<br>
<table border="0" width="100%" style="border:none">
<tr><td style="border:none">
<?php
if ($action=="search" && $by!="" && $word!="") echo "<big>搜索结果</big> [<a href='detail.php'>显示全部列表</a>]";
else echo "<big>网站列表</big>";
?>
</td>
<td style="border:none">
<table border="0" bordercolor="black" cellspacing="0" id="se" width='100%' style="border:none"><tr>
<form action="detail.php" method="get">
<td style="border:none">
网址记录搜索：<input name="word">
<select name="by">
根据：<option value='title'>网站名称</option>
<option value='url'>网站url</option>
</select>
<input type="hidden" name="action" value="search">
<input type="submit" value="搜索"></td>
</form>
</tr></table>
</td>
</table>
<table bordercolor="black" cellspacing="4" id="listtb" width='100%'>
<tr>
<td nowrap class='formHeader'>编号</td>
<td width='150' class='formHeader'>网站名称</td>
<td class='formHeader' width="300">网站url</td>
<td nowrap class='formHeader'>所属分类</td>
<td nowrap class='formHeader'>操作</td>
</tr>
<?php
if ($pn=="") $pn=1;
if ($pn<1) $pn=1;
if ($action=="search" && $by!="" && $word!="") {
if ($by=="url")
$sql="select * from wz_detail where verity=1 and url like '%".$word."%' order by id desc";
elseif ($by=="title")
$sql="select * from wz_detail where verity=1 and title like '%".$word."%' order by id desc";
else
$sql="select * from wz_detail where verity=1 and classid=".$word." order by id desc";
}
else $sql="select * from wz_detail where verity=1 order by id desc";
echo " SQL语句：".$sql;
$result=mysql_query($sql);
$rstotal=mysql_num_rows($result);
$pagetotal=ceil($rstotal/100);
if ($pn>$pagetotal) $pn=$pagetotal;
$pagesize=100;
$ii=1;
$rsstart=$pagesize*($pn-1)+1;
$rscount=1;
while (($r=mysql_fetch_array($result)) && ($ii<=100)) {
$result1=mysql_query("select * from wz_fenlei where classid=".$r["classid"]);
if ($result1) {
$rr=mysql_fetch_array($result1);
$classname=$rr["classname"];
}
else $classname="";
$classid=0;
for ($i=0;$i<=count($leibie);$i++) {
if ($leibie[$i]["name"]==$classname) {
$classid=$leibie[$i]["id"];
}
}
if ($rscount>=$rsstart) {
echo "<tr><FORM action=detail.php method=get onsubmit='return check(this)' name='form".$r["id"]."'><td nowrap>".$r["id"]."<input name='id' type='hidden' value='".$r["id"]."'></td><input name='action' type='hidden' value='modify'>";
echo "<td width='150'><a href='".$r["url"]."' target='_blank'>".$r["title"]."</a></td>";
echo "<td><input readonly='yes' style='border-width:0px 0px 1px 0px;border-color:black;width:300px' value='".htmlspecialchars($r["url"])."'></td>";
echo "<td nowrap width=\"150\"><a href='detail.php?action=search&by=fenlei&word=".$classid."&pn='>".$classname."</a></td>";
echo "<td nowrap width=\"100\"><A href='#' onclick=\"javascript:return editrow('listtb',$ii,'".$r["id"]."','".$r["title"]."','".$r["url"]."','".$classid."'); return false;\">编辑</a> - <A href=\"detail.php?action=delete&deleteid=".$r["id"]."\" onclick='return confirm(\"确定删除？\")'>删除</A></td></FORM></tr>";
$ii++;
}
$rscount++;
}
if ($rstotal<1) echo "<tr><td colspan='10'><b>没有发现记录</b></td></tr>";
?>
</tr>
</table>
<br>
<?php
echo "共".$rstotal."个网址,分".$pagetotal."页显示,当前第".$pn."页 ";
$np=$pn+1;
$pp=$pn-1;
if ($pn==1 && $pagetotal>1) {
echo "<a href='detail.php?action=$action&by=$by&word=$word&pn=".$np."'>下页</a> <a href='detail.php?action=$action&by=$by&word=$word&pn=".$pagetotal."'>末页</a>";
echo "<Script Language='JavaScript'>\n";
echo "function gonewpn(x) {\n";
echo "window.location.href='detail.php?action=$action&by=$by&word=$word&pn='+x;\n";
echo "}\n";
echo "</Script>\n";
echo " 转到<select id='newpn' onchange='gonewpn(this.value)'>";
for ($m=1;$m<=$pagetotal;$m++) {
if ($m==$pn)
echo "<option value='$m' selected>$m</option>\n";
else
echo "<option value='$m'>$m</option>\n";
}
echo "</select>页\n";
}
elseif ($pn==$pagetotal && $pagetotal>1) {
echo "<a href='detail.php?action=$action&by=$by&word=$word&pn=1'>首页</a> <a href='detail.php?action=$action&by=$by&word=$word&pn=".$pp."'>上页</a>";
echo "<Script Language='JavaScript'>\n";
echo "function gonewpn(x) {\n";
echo "window.location.href='detail.php?action=$action&by=$by&word=$word&pn='+x;\n";
echo "}\n";
echo "</Script>\n";
echo " 转到<select id='newpn' onchange='gonewpn(this.value)'>";
for ($m=1;$m<=$pagetotal;$m++) {
if ($m==$pn)
echo "<option value='$m' selected>$m</option>\n";
else
echo "<option value='$m'>$m</option>\n";
}
echo "</select>页\n";
}
elseif ($pn!=$pagetotal && $pagetotal>1) {
echo "<a href='detail.php?action=$action&by=$by&word=$word&pn=1'>首页</a> <a href='detail.php?action=$action&by=$by&word=$word&pn=".$pp."'>上页</a>";
echo " <a href='detail.php?action=$action&by=$by&word=$word&pn=".$np."'>下页</a> <a href='detail.php?action=$action&by=$by&word=$word&pn=".$pagetotal."'>末页</a>";
echo "<Script Language='JavaScript'>\n";
echo "function gonewpn(x) {\n";
echo "window.location.href='detail.php?action=$action&by=$by&word=$word&pn='+x;\n";
echo "}\n";
echo "</Script>\n";
echo " 转到<select id='newpn' onchange='gonewpn(this.value)'>";
for ($m=1;$m<=$pagetotal;$m++) {
if ($m==$pn)
echo "<option value='$m' selected>$m</option>\n";
else
echo "<option value='$m'>$m</option>\n";
}
echo "</select>页\n";
}
?>
</BODY>
</HTML>
⌨️ 快捷键说明
复制代码
Ctrl + C
搜索代码
Ctrl + F
全屏模式
F11
切换主题
Ctrl + Shift + D
显示快捷键
?
增大字号
Ctrl + =
减小字号
Ctrl + -