php杂乱

//
//   if ( $_GET['action'] == 'search' ) {
//       $_clean = array();
//       $_clean['stype'] = _check($_POST['stype']);
//       $_clean['key'] = _check($_POST['key']);
//
//       if ( $_clean['stype'] == 'companyId' ) {
//           _page("SELECT goodsId FROM tb_goods WHERE companyId = '{$_clean['key']}'",10);
//
//           $_sql = "SELECT * FROM tb_goods WHERE companyId = '{$_clean['key']}' LIMIT $_pagenum,$_pagesize";
//       } elseif ( $_clean['stype'] == 'goodsName' ) {
//           _page("SELECT goodsId FROM tb_goods WHERE goodsName = '{$_clean['key']}'",10);
//
//           $_sql = "SELECT * FROM tb_goods WHERE goodsName = '{$_clean['key']}' LIMIT $_pagenum,$_pagesize";
//       } elseif ( $_clean['stype'] == 'goodsDeliveryArea' ) {
//           _page("SELECT goodsId FROM tb_goods WHERE goodsDeliveryArea = '{$_clean['key']}'",10);
//
//           $_sql = "SELECT * FROM tb_goods WHERE goodsDeliveryArea = '{$_clean['key']}' LIMIT $_pagenum,$_pagesize";
//       }
//   }
//
//   $_result = _query($_sql);

   if ( isset($_GET['goodsId']) && $_GET['action'] = 'delete' ) {
       $_sql1 = "DELETE FROM tb_goods WHERE goodsId = '{$_GET['goodsId']}'";
       _query($_sql1);

if ( _affected_rows() == 1 ) {
           _close();
           _alert_back('删除成功！');
       } else {
           _close();
           _alert_back('删除失败！');
       }
   }

   if ( $_GET['action'] == 'deleteAll' && isset($_POST['ids']) ) {
       $_clean['ids'] = _mysql_string(implode(',',$_POST['ids']));

$_sql2 = "DELETE FROM tb_goods WHERE goodsId IN ({$_clean['ids']})";
_query($_sql2);

if( _affected_rows() ){
           _close();
           _alert_back('删除成功！');
       }else{
           _close();
           _alert_back('删除失败！');
       }
   }

//if($_POST["countyId"]>0){
//       $_clean['areaId'] = _check($_POST['countyId']);
//       $rs=_query("select * from tb_area where id='{$_POST['countyId']}'");
//       $row = _fetch_array($rs);
//       $areaName=$row["areaName"];
//       _free_result($rs);
//       $_clean['goodsDeliveryArea'] = "仅".$areaName;
//   }else{
//       $_clean['areaId'] = _check($_POST['cityId']);
//       $rs=_query("select * from tb_area where id='{$_POST['cityId']}'");
//       $row = _fetch_array($rs);
//       $areaName=$row["areaName"];
//       _free_result($rs);
//       $_clean['goodsDeliveryArea'] = "全".$areaName;
//   }

$_clean['code'] = _check($_POST['code']);
       if ($_clean['code'] !=$_SESSION["code"])
       {
       echo "<script>alert('验证码不正确,请重新登陆');location.href='login.php';</script>";
       exit;
       }

require 'includes/common.inc.php';
   session_start();
   if ( $_GET['action'] == 'login' ) {
       $_clean = array();
       $_clean['username'] = _check($_POST['username']);
       $_clean['password'] =md5(_check($_POST['password']));
       $_sql = "SELECT * FROM tb_easyadmin WHERE username = '{$_clean['username']}' AND password = '{$_clean['password']}' LIMIT 1";
       $_result = _query($_sql);
       $_rows = _fetch_array($_result);
       if ( !!$_rows ) {
           _close();
           $_SESSION['id'] = $$_rows['id'];
           $_SESSION['password'] = $_clean['password'];
           _location(null,'index.php');
       } else {
           _close();
           _location('用户名密码不正确','login.php');
       }
   }

<?php
                       if( $_html3['county'] > 0 ){
                           $_sql3 = "SELECT id,areaName FROM tb_earea WHERE areaType = 4 AND areaId = '{$_html3['county']}' AND state = 0";
                           $_result3 = _query($_sql3);
                           while( $_rowsRegion = _fetch_array($_result3) ){
                   ?>
                        <option value="<?php echo $_rowsRegion['id'] ?>" <?php if($_html3["region"]==$_rowsRegion['id']){?> selected="selected"<?php }?>><?php echo $_rowsRegion['areaName'] ?></option>
                        <?php
                           }
                           _free_result($_result3);
                       }
                   ?>

$(function() {

$advertisingType = $('#advertisingType');

   $advertisingType.click(function() {

       value = $advertisingType.val();

       if ( value == 4 ) {
           $('.tr').hide();
       }

       if ( value != 4 ) {
           $('.tr').show();
       }

   });

});

<select name="smallClassId" id="smallClassId" >
                        <option value="0">请选择小类</option>
                        <?php
                           if( $_html3['bigClassId'] > 0 ){
                               $_sql5 = "SELECT id,categoryName FROM tb_ecategory WHERE grade = 1 AND categoryId = '{$_html3['bigClassId']}' AND state = 0";
                               $_result5 = _query($_sql5);
                               while( $_rows5 = _fetch_array($_result5) ){
                       ?>
                        <option value="<?php echo $_rows5['id']?>" <?php if($_html3['smallClassId'] == $_rows5['id']){?> selected="selected"<?php }?>><?php echo $_rows5['categoryName']?></option>
                        <?php
                               }
                               _free_result($_result5);
                           }
                       ?>
                      </select>

user

<?php
   require 'includes/common.inc.php';
   session_start();
   if ( !isset($_SESSION['username']) ) {
       _location('请先登录！','login.php');
   }
?>
<!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN" "http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd">
<html xmlns="http://www.w3.org/1999/xhtml">
<head>
<meta http-equiv="Content-Type" content="text/html; charset=utf-8" />
<title>后台管理--会员管理</title>
<style type="text/css">

</style>
<link href="images/skin.css" rel="stylesheet" type="text/css" />
</head>
<body>
<table width="100%" border="0" cellpadding="0" cellspacing="0">
<tr>
    <td width="17" height="29" valign="top" background="images/mail_leftbg.gif"><img src="data:images/left-top-right.gif" width="17" height="29" /></td>
    <td height="29" valign="top" background="images/content-bg.gif"><table width="100%" height="31" border="0" cellpadding="0" cellspacing="0" class="left_topbg" id="table2">
        <tr>
          <td height="31"><div class="titlebt">会员管理</div></td>
        </tr>
      </table></td>
    <td width="16" valign="top" background="images/mail_rightbg.gif"><img src="data:images/nav-right-bg.gif" width="16" height="29" /></td>
</tr>
<tr>
    <td height="71" valign="middle" background="images/mail_leftbg.gif"> </td>
    <td valign="top" bgcolor="#F7F8F9"><div>
        <table width="98%" border="0" align="center" cellpadding="0" cellspacing="0">
          <tr>
            <td height="20"><div style="font-size:12px;line-height:25px;">查看： <a href='user.php'>全部</a> <a href="?userType=1">个人会员</a> <a href="?userType=2">企业会员</a></div>
              <div align="center" style="margin-top:-10px;">
                <form action="?action=search" method="post" name="user" id='user' onsubmit="return test();">
                  <label for="stype"></label>
                  <select name="stype" id="stype">
                    <option value="regName">账号名称</option>
                  </select>
                  <input name="key" type="text" id="key" />
                  <input id='btn' type="submit" value="搜素" />
                </form>
              </div>
              <table width="100%" height="1" border="0" cellpadding="0" cellspacing="0" >
              </table></td>
          </tr>
          <tr><td height="10"></td></tr>
          <tr>
            <td>
                <table width="100%" height="74" border="0" cellpadding="0" cellspacing="0" class="nowtable">
                  <tr align="center" bgcolor="#F2F2F2">
                    <td class="left_txt2">账号名称</td>
                    <td class="left_txt2">会员类型</td>
                    <td class="left_txt2">会员等级</td>
                    <td class="left_txt2">易币数</td>
                    <td class="left_txt2">现金数</td>
                    <td class="left_txt2">真实姓名</td>
                    <td class="left_txt2">状态</td>
                   <td class="left_txt2"></td>
                  </tr>
                  <?php
                   define('SCRIPT','user');
                   global $_pagesize,$_pagenum;
                   if ($_GET['userType']=="") {
                       _page('SELECT id FROM tb_user',10);
                       $_sql = "SELECT * FROM tb_user LIMIT $_pagenum,$_pagesize";
                   }else{
                       _page("SELECT id FROM tb_user WHERE identity = '{$_GET['identity']}' && state = '{$_GET['state']}'",10);
                       $_sql = "SELECT * FROM tb_user WHERE identity = '{$_GET['identity']}' && state = '{$_GET['state']}' LIMIT $_pagenum,$_pagesize";
                   }
                   if ( $_GET['action'] == 'search' ) {
                       $_clean = array();
                       $_clean['stype'] = _check($_POST['stype']);
                       $_clean['key'] = _check($_POST['key']);

                   if ( $_clean['stype'] == 'regName' ) {
                       $_sql = "SELECT * FROM tb_user WHERE regName = '{$_clean['key']}'";
                       }
                       }
                   $_result = _query($_sql);
                   $_row = _num_rows($_result);
                   if ( $_row > 0 ) {
                       while ( $_rows = _fetch_array($_result) ) {
                           $_html = array();
                           $_html['id'] = $_rows['id'];
                           $_html['regName'] = $_rows['regName'];
                           $_html['totalSyJf'] = $_rows['totalSyJf'];
                           $_html['cash'] = $_rows['cash'];
                           $_html['realName'] = $_rows['realName'];
                           switch ( $_rows['state'] ) {
                               case 0:
                                   $_html['state'] = '正常';
                                   break;
                               case 1:
                                   $_html['state'] = '冻结';
                                   break;
                               case 10:
                                   $_html['state'] = '未激活';
                                   break;
                           }
                           $_sql1 = "SELECT levelName FROM tb_level WHERE id = '{$_rows['level']}'";
                           $_result1 = _query($_sql1);
                           $_rows1 = _fetch_array($_result1);
                           $_html['level'] = $_rows1['levelName'];

                           switch ( $_rows['identity'] ) {
                               case 1:
                                   $_html['identity'] = '个人会员';
                                   break;
                               case 2:
                                   $_html['identity'] = '企业会员';
                                   break;
                           }
                           $_html = _html($_html);
                      ?>
                  <tr align="center" bgcolor="#F2F2F2">
                    <td class="left_txt2"><?php echo $_html['regName']?></td>
                    <td class="left_txt2"><?php echo $_html['identity']?></td>
                    <td class="left_txt2"><?php echo $_html['level']?></td>
                    <td class="left_txt2"><?php echo $_html['totalSyJf']?></td>
                    <td class="left_txt2"><?php echo $_html['cash']?></td>
                    <td class="left_txt2"><?php echo $_html['realName']?></td>
                    <td class="left_txt2"><?php echo $_html['state']?></td>
                    <td width="13%" class="left_txt2">
                       <a href='user_edit.php?id=<?php echo $_html['id']?>'>修改</a>
                   </td>
                  </tr>
                   <?php
                   }
                   ?>
                <?php
                   } else {
                   ?>
                <tr bgcolor="#F2F2F2" class="left_txt2" align="center" >
                  <td colspan="9">暂无信息</td>
                </tr>
               <?php
                   }
                   _free_result($_result);
                   _close();
                   ?>
                <tr bgcolor="#F2F2F2" class="left_txt2" align="center" >
                  <td colspan="9">
               <?php
                   _paging(2);
                   ?>
              </table></td>
          </tr>
        </table>
      </div></td>
    <td background="images/mail_rightbg.gif"> </td>
</tr>
<tr>
    <td valign="middle" background="images/mail_leftbg.gif"><img src="data:images/buttom_left2.gif" width="17" height="17" /></td>
    <td height="17" valign="top" background="images/buttom_bgs.gif"><img src="data:images/buttom_bgs.gif" width="17" height="17" /></td>
    <td background="images/mail_rightbg.gif"><img src="data:images/buttom_right2.gif" width="16" height="17" /></td>
</tr>
</table>
</body>
</html>

修改会员
<?php

require 'includes/common.inc.php';

   session_start();

   if ( !isset($_SESSION['username']) ) {
       _location('请先登录','login.php');
   }

   if ( isset($_GET['id']) ) {
       $_sql = "SELECT * FROM tb_user WHERE id = '{$_GET['id']}'";
       $_result = _query($_sql);
       $_rows = _fetch_array($_result);
       $_html = array();
       $_html['regName'] = $_rows['regName'];
       $_html['Email'] = $_rows['Email'];
       $_html['regPwd'] = $_rows['regPwd'];
       $_html['tradingPwd'] = $_rows['tradingPwd'];
       $_html['encryptedQuestion'] = $_rows['encryptedQuestion'];
       $_html['encryptedAnswer'] = $_rows['encryptedAnswer'];
       $_html['userimage'] = $_rows['userimage'];
       $_html['realName'] = $_rows['realName'];
       $_html['province'] = $_rows['province'];
       $_html['theCity'] = $_rows['theCity'];
       $_html['county'] = $_rows['county'];
       $_html['address'] = $_rows['address'];
       $_html['qq'] = $_rows['qq'];
       $_html['phone'] = $_rows['phone'];
       $_html['totalSyJf'] = $_rows['totalSyJf'];
       $_html['cash'] = $_rows['cash'];
       $_html['level'] = $_rows['level'];
       $_html['levelDate'] = $_rows['levelDate'];
       $_html['userType'] = $_rows['userType'];
       $_html['state'] = $_rows['state'];

       $_sql2 = "SELECT regName FROM tb_user WHERE id = '{$_rows['isfrom1']}'";
       $_result2 = _query($_sql2);
       $_rows2 = _fetch_array($_result2);
       $_html['isfrom1'] = $_rows2['regName'];

       $_sql3 = "SELECT regName FROM tb_user WHERE id = '{$_rows['isfrom2']}'";
       $_result3 = _query($_sql3);
       $_rows3 = _fetch_array($_result3);
       $_html['isfrom2'] = $_rows3['regName'];

       $_sqlProvince = "SELECT areaName FROM tb_area WHERE id = '{$_html['province']}'";
       $_resultProvince = _query($_sqlProvince);
       $_rowsProvince = _fetch_array($_resultProvince);

       $_sqlCity = "SELECT areaName FROM tb_area WHERE id = '{$_html['theCity']}'";
       $_resultCity = _query($_sqlCity);
       $_rowsCity = _fetch_array($_resultCity);

       $_sqlCounty = "SELECT areaName FROM tb_area WHERE id = '{$_html['county']}'";
       $_resultCounty = _query($_sqlCounty);
       $_rowsCounty = _fetch_array($_resultCounty);

       $_html = _html($_html);
   }
   if ( isset($_GET['id']) && $_GET['action'] == 'update' ){
       $_clean = array();
       $_clean['regPwd'] = _check($_POST['regPwd']);
       $_clean['tradingPwd'] = _check($_POST['tradingPwd']);
       $_clean['level'] = _check($_POST['level']);
       $_clean['state'] = _check($_POST['state']);
       $_sql1 = "UPDATE
                       tb_user
                   SET
                      regPwd = '{$_clean['regPwd']}',
                       tradingPwd = '{$_clean['tradingPwd']}',
                       level = '{$_clean['level']}',
                       state = '{$_clean['state']}'
                   WHERE
                          id = '{$_GET['id']}'";
       _query($_sql1);

       if ( _affected_rows() == 1 ) {
           _close();
           _alert_back('修改成功！');
       } else {
           _close();
           _alert_back('修改失败！');
       }
   }

?>
<!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN" "http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd">
<html xmlns="http://www.w3.org/1999/xhtml">
<head>
<meta http-equiv="Content-Type" content="text/html; charset=utf-8" />
<title>后台管理--修改会员信息</title>
<script src="../js/setday.js" type="text/javascript"></script>
<script type="text/javascript">
window.onload = function(){

添加会员

<?php

require 'includes/common.inc.php';
   session_start();
   if ( !isset($_SESSION['username']) ) {
       _location('请先登录！','login.php');
   }



   $_now = date('Y-m-d H:i:s',time());

   if ( $_GET['action'] == 'add' ) {
       $_clean = array();
       $_clean['regIP'] = $_SERVER["REMOTE_ADDR"];
       $_clean['regName'] = _check($_POST['regName']);
       $_clean['Email'] = _check($_POST['Email']);
       $_clean['regPwd'] = md5(($_POST['regPwd']));
       $_clean['tradingPwd'] = md5(($_POST['tradingPwd']));
       $_clean['encryptedQuestion'] = _check($_POST['encryptedQuestion']);
       $_clean['encryptedAnswer'] = md5(($_POST['encryptedAnswer']));
       $_clean['userimage'] = $_POST['userimage'];
       $_clean['realName'] = _check($_POST['realName']);
       $_clean['province'] = _check($_POST['province']);
       $_clean['theCity'] = _check($_POST['theCity']);
       $_clean['county'] = _check($_POST['county']);
       $_clean['address'] = _check($_POST['address']);
       $_clean['qq'] = _check($_POST['qq']);
       $_clean['phone'] = _check($_POST['phone']);
       $_clean['totalSyJf'] = _check($_POST['totalSyJf']);
       $_clean['cash'] = _check($_POST['cash']);
       $_clean['level'] = _check($_POST['level']);
       $_clean['levelDate'] = _check($_POST['levelDate']);
       $_clean['userType'] = _check($_POST['userType']);
       $_clean['isfrom1'] = _check($_POST['isfrom1']);
       $_clean['lotteryNumber'] = _check($_POST['lotteryNumber']);

       $_sql = "SELECT isfrom1 FROM tb_user WHERE id = '{$_clean['isfrom1']}'";
       $_result = _query($_sql);
       $_rows = _fetch_array($_result);
       $_sqlAdd = "INSERT INTO tb_user VALUES (NULL,'{$_clean['regIP']}','$_now','{$_clean['regName']}','{$_clean['Email']}','{$_clean['regPwd']}','{$_clean['tradingPwd']}','{$_clean['encryptedQuestion']}','{$_clean['encryptedAnswer']}','{$_clean['userimage']}','{$_clean['realName']}','{$_clean['province']}','{$_clean['theCity']}','{$_clean['county']}','{$_clean['address']}','{$_clean['qq']}','{$_clean['phone']}','{$_clean['totalSyJf']}','{$_clean['cash']}','{$_clean['level']}',0,1,'{$_clean['isfrom1']}','{$_rows['isfrom1']}',0,'{$_rows['lotteryNumber']}')";
       _query($_sqlAdd);

       if ( _affected_rows() == 1 ) {
           _close();
           _location('添加成功！','user.php');
       } else {
           _close();
           _location('添加失败！','user_add.php');
       }
   }
?>
<!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN" "http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd">
<html xmlns="http://www.w3.org/1999/xhtml">
<head>
<meta http-equiv="Content-Type" content="text/html; charset=utf-8" />
<script src="../js/setday.js" type="text/javascript"></script>
<title>后台管理--添加会员</title>
<style type="text/css">
*{
   margin:0;
   padding:0;
}
body {
   background-color: #F8F9FA;
}
</style>
<link href="images/skin.css" rel="stylesheet" type="text/css" />
<script type="text/javascript">
//市数据保存到数组
var subvalCity = new Array();
<?php
$rs = _query("select * from tb_area where areaType=2 and state=0 order by sort asc");
$counts = 0;
while( $row = _fetch_array($rs) ){
?>
subvalCity[<?php echo $counts?>] = new Array('<?php echo $row["areaId"]?>','<?php echo $row["id"]?>','<?php echo $row["areaName"]?>')
<?php
$counts = $counts + 1;
}
_free_result($rs);
?>
function provinceChange(locationid)
{
    document.admin.theCity.length = 0;
    document.admin.theCity.options[0] = new Option('--请选择市--','0');
   document.admin.county.length = 0;
    document.admin.county.options[0] = new Option('--请选择区县--','0');
    for (i=0; i<subvalCity.length; i++)
    {
        if (subvalCity[i][0] == locationid) {
           document.admin.theCity.options[document.admin.theCity.length] = new Option(subvalCity[i][2],subvalCity[i][1]);
       }
    }
}

//区数据保存到数组
var subvalCounty = new Array();
<?php
$rs1 = _query("select * from tb_area where areaType=3 and state=0 order by sort asc");
$counts1 = 0;
while( $row1 = _fetch_array($rs1) ){
?>
subvalCounty[<?php echo $counts1?>] = new Array('<?php echo $row1["areaId"]?>','<?php echo $row1["id"]?>','<?php echo $row1["areaName"]?>')
<?php
$counts1 = $counts1 + 1;
}
_free_result($rs1);
?>
function theCityChange(locationid)
{
    document.admin.county.length = 0;
    document.admin.county.options[0] = new Option('--请选择区县--','0');
    for (i=0; i<subvalCounty.length; i++)
    {
        if (subvalCounty[i][0] == locationid) {
           document.admin.county.options[document.admin.county.length] = new Option(subvalCounty[i][2],subvalCounty[i][1]);
       }
    }
}

相关文章