📄 changefield.php

📁 不错的一个网站管理系统
💻 PHP
字号:
<?php
require("../../class/connect.php");
include("../../class/db_sql.php");
include("../../class/config.php");
include("../../class/functions.php");
include "../".LoadLang("pub/fun.php");
$link=db_connect();
$empire=new mysqlquery();
$logininid=getcvar('loginuserid');
$loginin=getcvar('loginusername');
$loginrnd=getcvar('loginrnd');
$loginlevel=getcvar('loginlevel');
$editor=1;
is_login($logininid,$loginin,$loginrnd);
$tid=(int)$_GET['tid'];
if($tid)
{
	$tbwhere="tid='$tid'";
	$search="&tid=$tid";
}
else
{
	$tbname=RepPostVar($_GET['tbname']);
	$tbwhere="tbname='$tbname'";
	$search="&tbname=$tbname";
}
$viewf=RepPostVar($_GET['viewf']);
$changef=RepPostVar($_GET['changef']);
if(!$viewf||!$changef){
	printerror('ErrorUrl','');
}
//取得表名
$tbr=$empire->fetch1("select tbname from {$dbtbpre}enewstable where ".$tbwhere);
if(!$tbr['tbname'])
{
	printerror('ErrorUrl','');
}
//字段
$viewfr=$empire->fetch1("select f,fname from {$dbtbpre}enewsf where ".$tbwhere." and f='$viewf' limit 1");
$changefr=$empire->fetch1("select f,fname from {$dbtbpre}enewsf where ".$tbwhere." and f='$changef' limit 1");
/*
if(!$viewfr[f]||!$changefr[f])
{
	printerror('ErrorUrl','');
}
*/
$form=$_GET['form'];
if(empty($form))
{
	$form='add';
}
$field=$_GET['field'];
$add='';
//关键字
$keyboard=RepPostVar2($_GET['keyboard']);
if(!empty($keyboard))
{
	$show=RepPostVar($_GET['show']);
	if($show==$viewf||$show==$changef)
	{
		$add=" where ".$show." like '%".$keyboard."%'";
	}
	if($show==$changef)
	{
		$searchoptionselect=' selected';
	}
}
$changeline=(int)$_GET['changeline'];
if(empty($changeline))
{
	$changeline=2;
}
$search.="&viewf=$viewf&changef=$changef&form=$form&field=$field&show=$show&keyboard=$keyboard&changeline=$changeline";
if($viewf==$changef)
{
	$searchoption="<option value='$viewf'>$viewfr[fname]</option>";
}
else
{
	$searchoption="<option value='$viewf'>$viewfr[fname]</option><option value='$changef'".$searchoptionselect.">$changefr[fname]</option>";
}
//分页
$page=(int)$_GET['page'];
$start=(int)$_GET['start'];
$line=50;//每页显示条数
$page_line=12;//每页显示链接数
$offset=$start+$page*$line;//总偏移量
$query="select ".$viewf.",".$changef." from {$dbtbpre}ecms_".$tbname.$add;
$totalquery="select count(*) as total from {$dbtbpre}ecms_".$tbname.$add;
$num=$empire->gettotal($totalquery);//取得总条数
$query=$query." order by id desc limit $offset,$line";
$sql=$empire->query($query);
$returnpage=page1($num,$line,$page_line,$start,$page,$search);
//风格
$loginadminstyleid=(int)getcvar('loginadminstyleid');
?>
<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.01 Transitional//EN">
<html>
<head>
<meta http-equiv="Content-Type" content="text/html; charset=gb2312">
<title>选择</title>
<link href="edit.css" rel="stylesheet" type="text/css">
<link href="../adminstyle/<?=$loginadminstyleid?>/adminstyle.css" rel="stylesheet" type="text/css">
<script>
function ChangeFieldVal(val){
	opener.document.<?=$form?>.<?=$field?>.value=val;
	window.close();
}
</script>
</head>
<body>
<form name="form1" method="get" action="ChangeField.php">
  <table width="100%" border="0" align="center" cellpadding="3" cellspacing="1">
    <tr> 
      <td width="70%"><div align="center">搜索： 
          <input name="keyboard" type="text" value="<?=$keyboard?>">
          <select name="show">
            <?=$searchoption?>
          </select>
          <input type="submit" name="Submit" value="搜索">
          <input type=hidden name="form" value="<?=$form?>">
          <input type=hidden name="field" value="<?=$field?>">
          <input name="tid" type="hidden" id="tid" value="<?=$tid?>">
          <input name="tbname" type="hidden" value="<?=$tbname?>">
          <input name="viewf" type="hidden" id="viewf" value="<?=$viewf?>">
          <input name="changef" type="hidden" id="changef" value="<?=$changef?>">
          <input name="changeline" type="hidden" value="<?=$changeline?>">
        </div></td>
      <td width="30%">
	  <span id="showaddclassnav"></span>
      <input type="button" name="Submit" value="增加信息" onclick="if(document.form1.addclassid.value!=0){window.open('../AddNews.php?enews=AddNews&classid='+document.form1.addclassid.value,'','');}else{alert('请选择要增加信息的栏目');document.form1.addclassid.focus();}">
	  </td>
    </tr>
  </table>
</form>
<table width="100%" border="0" align="center" cellpadding="3" cellspacing="1" class="tableborder">
  <tr> 
    <td height="25" bgcolor="#FFFFFF"> <div align="center"> 
    <?php
	//输出
	$i=0;
	$class_text="";
	while($r=$empire->fetch($sql))
	{
		$i++;
        if(($i-1)%$changeline==0||$i==1)
		{
			$class_text.="<tr>";
		}
		$class_text.="<td align=center height=25><a href='#ecms' onclick=\"ChangeFieldVal('".addslashes(stripSlashes($r[$changef]))."');\" title='选择'>".stripSlashes($r[$viewf])."</a></td>";
		//分割
        if($i%$changeline==0)
		{
			$class_text.="</tr>";
		}
	}
	if($i<>0)
	{
		 $table="<table width=100% border=0 cellpadding=3 cellspacing=0>";$table1="</table>";
         $ys=$changeline-$i%$changeline;
		 $p=0;
         for($j=0;$j<$ys&&$ys!=$changeline;$j++)
		 {
			  $p=1;
              $class_text.="<td></td>";
         }
		 if($p==1)
		 {
			  $class_text.="</tr>";
		 }
	 }
     $text=$table.$class_text.$table1;
     echo"$text";
	?>
      </div></td>
  </tr>
  <tr> 
    <td height="25" bgcolor="#FFFFFF" align=center> 
      <?=$returnpage?>
    </td>
  </tr>
</table>
<div align="center"> <br>
  [<a href="#empirecms" onclick="window.close();">关闭</a>]</div>
<IFRAME frameBorder="0" id="showclassnav" name="showclassnav" scrolling="no" src="../ShowClassNav.php?ecms=2" style="HEIGHT:0;VISIBILITY:inherit;WIDTH:0;Z-INDEX:1"></IFRAME>
</body>
</html>
<?
db_close();
$empire=null;
?>
⌨️ 快捷键说明

复制代码 Ctrl + C
搜索代码 Ctrl + F
全屏模式 F11
切换主题 Ctrl + Shift + D
显示快捷键 ?
增大字号 Ctrl + =
减小字号 Ctrl + -