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"> <!-- *{ margin:0; padding:0; } body { background-color: #F8F9FA; } --> </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="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="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="images/buttom_left2.gif" width="17" height="17" /></td> <td height="17" valign="top" background="images/buttom_bgs.gif"><img src="images/buttom_bgs.gif" width="17" height="17" /></td> <td background="images/mail_rightbg.gif"><img src="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(){ var ret = document.getElementById('return'); ret.onclick = function(){ history.back(-1); }; } </script> <style type="text/css"> <!-- *{ margin:0; padding:0;} body { background-color: #F8F9FA; } --> </style> <link href="images/skin.css" rel="stylesheet" type="text/css" /> </head> <body> <table width="100%" border="0" cellpadding="0" cellspacing="0"> <td width="17" height="29" valign="top" background="images/mail_leftbg.gif"><img src="images/left-top-right.gif" width="17" height="29" /></td> <td 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 width="16" valign="top" background="images/mail_rightbg.gif"><img src="images/nav-right-bg.gif" width="16" height="29" /></td> <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="10"></td></tr> <tr> <td><table width="100%" height="31" border="0" cellpadding="0" cellspacing="0" class="nowtable"> <form name="admin" id="admin" method="POST" action="?action=update&id=<?php echo $_GET['id']?>"> <tr bgcolor="#f2f2f2"> <td width="34%" align="right" class="left_txt2"> 账号名称：</td> <td width="16%" class="left_txt2"><?php echo $_html['regName']?></td> <td width="14%" align="right" class="left_txt2" >现金余额：</td> <td width="36%" class="left_txt2"><?php echo $_html['cash']?></td> </tr> <tr bgcolor="#f2f2f2"> <td align="right" class="left_txt2">账号邮箱：</td> <td class="left_txt2"><?php echo $_html['Email']?></td> <td align="right" class="left_txt2">真实名称：</td> <td class="left_txt2"><?php echo $_html['realName']?></td> </tr> <tr bgcolor="#f2f2f2"> <td align="right" class="left_txt2">密码：</td> <td class="left_txt2"><input type="password" name="regPwd" size="20" id="regPwd"value="<?php echo $_html['regPwd'] ?>" /></td> <td align="right" class="left_txt2">省：</td> <td class="left_txt2"><?php echo $_rowsProvince['areaName']?></td> </tr> <tr bgcolor="#f2f2f2"> <td align="right" class="left_txt2">交易密码：</td> <td class="left_txt2"><input type="password" name="tradingPwd" size="20" id="tradingPwd" value="<?php echo $_html['tradingPwd'] ?>"/></td> <td class="left_txt2" align="right" >市：</td> <td class="left_txt2"><?php echo $_rowsCity['areaName']?></td> </tr> <tr bgcolor="#f2f2f2"> <td class="left_txt2" align="right" >密码问题：</td> <td class="left_txt2"><?php echo $_html['encryptedQuestion']?></td> <td class="left_txt2" align="right" >县：</td> <td class="left_txt2"><?php echo $_rowsCounty['areaName']?></td> </tr> <tr bgcolor="#f2f2f2"> <td align="right" class="left_txt2">密保答案：</td> <td class="left_txt2"><?php echo $_html['encryptedAnswer']?></td> <td class="left_txt2" align="right">详细地址：</td> <td class="left_txt2"><?php echo $_html['address']?></td> </tr> <tr bgcolor="#f2f2f2"> <td class="left_txt2" align="right" >QQ：</td> <td class="left_txt2"><?php echo $_html['qq']?></td> <td align="right" class="left_txt2">用户等级：</td> <td class="left_txt2"><select name="level" id="level"> <option value="">--请选择用户等级--</option> <?php $_sql4 = "SELECT id,levelName FROM tb_level WHERE state = 0"; $_result4 = _query($_sql4); while( $_rows4 = _fetch_array($_result4) ){ ?> <option value="<?php echo $_rows4['id'] ?>" <?php if($_html['level'] == $_rows4['id']) echo "selected='selected'"; ?>><?php echo $_rows4['levelName'] ?></option> <?php } _free_result($_result4); ?> </select> </td> </tr> <tr bgcolor="#f2f2f2"> <td align="right" class="left_txt2">电话：</td> <td class="left_txt2"><?php echo $_html['phone']?></td> <td class="left_txt2" align="right" >会员有效期：</td> <td class="left_txt2"><?php echo $_html['levelDate']?></td> </tr> <tr bgcolor="#f2f2f2"> <td align="right" class="left_txt2">易币余额：</td> <td class="left_txt2"><?php echo $_html['totalSyJf']?></td> <td align="right" class="left_txt2">状态：</td> <td class="left_txt2"><select name="state" id="state"> <option value="0" <?php if($_html['state'] == 0) echo "selected='selected'"; ?>>正常</option> <option value="1" <?php if($_html['state'] == 1) echo "selected='selected'"; ?>>冻结</option> <option value="10" <?php if($_html['state'] == 10) echo "selected='selected'"; ?>>未激活</option> </select> </td> </tr> <tr bgcolor="#f2f2f2"> <td align="right" class="left_txt2">直接推广员：</td> <td class="left_txt2"><?php echo $_html['isfrom1']?></td> <td align="right" class="left_txt2">间接推广员：</td> <td class="left_txt2"><?php echo $_html['isfrom2']?></td> </tr> <tr bgcolor="#f2f2f2"> <td align="right" class="left_txt2">会员图像：</td> <td class="left_txt2" colspan="3"><img src="../<?php echo $_html['userimage']?>" /></td> </tr> <tr> <td colspan="4" align="center" bgcolor="#F2F2F2" class="left_txt2"><input type="submit" name="button" id="button" value="修改" /> <input type="button" value="返回" id="return" /> </td> </tr> </form> </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="images/buttom_left2.gif" width="17" height="17" /></td> <td height="17" valign="top" background="images/buttom_bgs.gif"><img src="images/buttom_bgs.gif" width="17" height="17" /></td> <td background="images/mail_rightbg.gif"><img src="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'); } $_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]); } } } function test() { if(document.admin.regName.value=='') { alert('请输入账号名称'); return false; } if(document.admin.Email.value=='') { alert('请输入账号邮箱'); return false; } if(document.admin.regPwd.value=='') { alert('请输入账号密码'); return false; } if(document.admin.tradingPwd.value=='') { alert('交易密码'); return false; } if(document.admin.encryptedQuestion.value=='') { alert('密码问题'); return false; } return true; } </script> </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="images/left-top-right.gif" width="17" height="29" /></td> <td 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 width="16" valign="top" background="images/mail_rightbg.gif"><img src="images/nav-right-bg.gif" width="16" height="29" /></td> <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="10"></td></tr> <tr> <td><table width="100%" border="0" cellpadding="0" cellspacing="0" class="nowtable"> <form name="admin" id="admin" method="POST" action="?action=add" onsubmit="return test();"> <tr bgcolor="#f2f2f2"> <td width="25%" align="right" class="left_txt2" > 账号名称：</td> <td width="21%" class="left_txt2"><input type="text" name="regName" size="30" id="regName" /></td> <td width="11%" align="right" class="left_txt2" >会员图像：</td> <td width="43%" class="left_txt2"><input type="text" name="userimage" id="userimage" style="width:152px" /> <input type="button" value="上传" onClick="window.open('../admin/upload.php?formname=admin&editname=userimage','','status=no,scrollbars=no,top=35,width=650,height=350')"/></td> </tr> <tr bgcolor="#f2f2f2"> <td align="right" class="left_txt2">账号邮箱：</td> <td class="left_txt2"><input type="text" name="Email" size="30" id="Email" /></td> <td align="right" class="left_txt2">真实名称：</td> <td class="left_txt2"><input type="text" name="realName" size="30" id="realName" /></td> </tr> <tr bgcolor="#f2f2f2"> <td align="right" class="left_txt2">密码：</td> <td class="left_txt2"><input type="password" name="regPwd" size="30" id="regPwd" /></td> <td class="left_txt2" align="right">省：</td> <td class="left_txt2"><select id="province" name="province" onchange="provinceChange(this.value) "> <option value="" >请选择省份</option> <?php $_sql = "SELECT id,areaName FROM tb_area WHERE areaType = 1 AND state = 0"; $_result = _query($_sql); while( $_rows = _fetch_array($_result) ){ $_html = array(); $_html['id'] = $_rows['id']; $_html['areaName'] = $_rows['areaName']; $_html = _html($_html); ?> <option value="<?php echo $_html['id'] ?>" <?php if($_html3['province'] == $_html['id']){?> selected="selected"<?php }?>><?php echo $_html['areaName'] ?></option> <?php } _free_result($_result); ?> </select> </td> </tr> <tr bgcolor="#f2f2f2"> <td align="right" class="left_txt2">交易密码：</td> <td class="left_txt2"><input type="password" name="tradingPwd" size="30" id="tradingPwd" /></td> <td class="left_txt2" align="right">市：</td> <td class="left_txt2"><select name="theCity" id="theCity" onchange="theCityChange(this.value)"> <option value="0">-- 请选择市--</option> <?php $_sql = "SELECT id,areaName FROM tb_area WHERE areaType = 2 AND state = 0"; $_result = _query($_sql); while( $_rows = _fetch_array($_result) ){ $_html = array(); $_html['id'] = $_rows['id']; $_html['areaName'] = $_rows['areaName']; $_html = _html($_html); ?> <option value="<?php echo $_html['id'] ?>" <?php if($_html3['theCity'] == $_html['id']){?> selected="selected"<?php }?>><?php echo $_html['areaName'] ?></option> <?php } _free_result($_result); ?> </select> </td> </tr> <tr bgcolor="#f2f2f2"> <td align="right" class="left_txt2">密码问题：</td> <td class="left_txt2"><input type="text" name="encryptedQuestion" size="30" id="encryptedQuestion" /></td> <td class="left_txt2" align="right">区县：</td> <td class="left_txt2"><select name="county" id="county" onChange="countyChange(this.value)" > <option value="0">--请选择区县--</option> <?php if( $_html3['theCity'] > 0 ){ $_sql2 = "SELECT id,areaName FROM tb_area WHERE areaType = 3 AND areaId = '{$_html3['theCity']}' AND state = 0"; $_result2 = _query($_sql2); while( $_rowsCounty = _fetch_array($_result2) ){ ?> <option value="<?php echo $_rowsCounty['id'] ?>" <?php if($_html3["county"] == $_rowsCounty['id']){?> selected="selected"<?php }?>><?php echo $_rowsCounty['areaName'] ?></option> <?php } _free_result($_result2); } ?> </select> </td> </tr> <tr bgcolor="#f2f2f2"> <td align="right" class="left_txt2">密保答案：</td> <td class="left_txt2"><input type="password" name="encryptedAnswer" size="30" id="encryptedAnswer" /></td> <td class="left_txt2" align="right" >详细地址：</td> <td class="left_txt2"><input name="address" type="text" id="address" size="30"/></td> </tr> <tr bgcolor="#f2f2f2" > <td align="right" class="left_txt2">QQ：</td> <td class="left_txt2"><input type="text" name="qq" size="30" id="qq" /></td> <td align="right" class="left_txt2">用户等级：</td> <td class="left_txt2"><select name="level" id="level"> <option value="">--请选择用户等级--</option> <?php $_sql4 = "SELECT id,levelName FROM tb_level WHERE state = 0"; $_result4 = _query($_sql4); while( $_rows4 = _fetch_array($_result4) ){ ?> <option value="<?php echo $_rows4['id'] ?>"><?php echo $_rows4['levelName'] ?></option> <?php } _free_result($_result4); ?> </select> </td> </tr> <tr bgcolor="#f2f2f2"> <td align="right" class="left_txt2">电话：</td> <td bgcolor="#f2f2f2"><input name="phone" type="text" id="phone" size="30" /></td> <td align="right" class="left_txt2">会员类型：</td> <td class="left_txt2"><select name="userType" id="userType"> <option value="">--请选择会员类型--</option> <option value="1">个人会员</option> <option value="2">商家会员</option> </select></td> </tr> <tr bgcolor="#f2f2f2"> <td class="left_txt2" align="right" >易币余额：</td> <td class="left_txt2" ><input name="totalSyJf" type="text" id="totalSyJf" size="30" /></td> <td class="left_txt2" align="right">会员有效期：</td> <td class="left_txt2"><input name="levelDate" type="text" id="levelDate" size="30" onclick="new Calendar().show(this);" readonly="readonly"/></td> </tr> <tr bgcolor="#f2f2f2"> <td class="left_txt2" align="right">现金余额：</td> <td class="left_txt2"><input type="text" name="cash" id="cash" size="30" /></td> <td align="right" class="left_txt2">直接推广人ID：</td> <td class="left_txt2"><input type="text" name="isfrom1" id="isfrom1" size="30" /></td> </tr> <tr> <td bgcolor="#f2f2f2" colspan="4" align="center" class="left_txt"><input type="submit" name="button" id="button" value="创建" /> <input type="reset" name="button2" id="button2" value="重置" /></td> </tr> </form> </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="images/buttom_left2.gif" width="17" height="17" /></td> <td height="17" valign="top" background="images/buttom_bgs.gif"><img src="images/buttom_bgs.gif" width="17" height="17" /></td> <td background="images/mail_rightbg.gif"><img src="images/buttom_right2.gif" width="16" height="17" /></td> </tr> </table> </body> </html>
帅选 搜索 批量删除
<?php require 'includes/common.inc.php'; session_start(); define('SCRIPT','advertising'); if ( !isset($_SESSION['username']) ) { _location('请先登录！','login.php'); } global $_pagesize,$_pagenum; if ( $_GET['advertisingType'] == '' && !isset($_GET['state']) ) { _page('SELECT id FROM tb_advertising',10); $_sql = "SELECT id,advertisingType,rewardType,title,linkPhone,state FROM tb_advertising LIMIT $_pagenum,$_pagesize"; $parameter = ''; } elseif ( $_GET['advertisingType'] == 1 && !isset($_GET['state']) ) { _page('SELECT id FROM tb_advertising WHERE advertisingType = 1',10); $_sql = "SELECT id,advertisingType,rewardType,title,linkPhone,state FROM tb_advertising WHERE advertisingType = 1 LIMIT $_pagenum,$_pagesize"; $parameter = "&advertisingType=1"; } elseif ( $_GET['advertisingType'] == 2 && !isset($_GET['state']) ) { _page('SELECT id FROM tb_advertising WHERE advertisingType = 2',10); $_sql = "SELECT id,advertisingType,rewardType,title,linkPhone,state FROM tb_advertising WHERE advertisingType = 2 LIMIT $_pagenum,$_pagesize"; $parameter = "&advertisingType=2"; } elseif ( $_GET['advertisingType'] == 3 && !isset($_GET['state']) ) { _page('SELECT id FROM tb_advertising WHERE advertisingType = 3',10); $_sql = "SELECT id,advertisingType,rewardType,title,linkPhone,state FROM tb_advertising WHERE advertisingType = 3 LIMIT $_pagenum,$_pagesize"; $parameter = "&advertisingType=3"; } elseif ( $_GET['advertisingType'] == 4 && !isset($_GET['state']) ) { _page('SELECT id FROM tb_advertising WHERE advertisingType = 4',10); $_sql = "SELECT id,advertisingType,rewardType,title,linkPhone,state FROM tb_advertising WHERE advertisingType = 4 LIMIT $_pagenum,$_pagesize"; $parameter = "&advertisingType=4"; } elseif ( $_GET['state'] == 0 && !isset($_GET['advertisingType']) ) { _page('SELECT id FROM tb_advertising WHERE state = 0',10); $_sql = "SELECT id,advertisingType,rewardType,title,linkPhone,state FROM tb_advertising WHERE state = 0 LIMIT $_pagenum,$_pagesize"; $parameter = "&state=0"; } elseif ( $_GET['state'] == 1 && !isset($_GET['advertisingType']) ) { _page('SELECT id FROM tb_advertising WHERE state = 1',10); $_sql = "SELECT id,advertisingType,rewardType,title,linkPhone,state FROM tb_advertising WHERE state = 1 LIMIT $_pagenum,$_pagesize"; $parameter = "&state=1"; } elseif ( $_GET['state'] == 2 && !isset($_GET['advertisingType']) ) { _page('SELECT id FROM tb_advertising WHERE state = 2',10); $_sql = "SELECT id,advertisingType,rewardType,title,linkPhone,state FROM tb_advertising WHERE state = 2 LIMIT $_pagenum,$_pagesize"; $parameter = "&state=2"; } elseif ( $_GET['state'] == 3 && !isset($_GET['advertisingType']) ) { _page('SELECT id FROM tb_advertising WHERE state = 3',10); $_sql = "SELECT id,advertisingType,rewardType,title,linkPhone,state FROM tb_advertising WHERE state = 3 LIMIT $_pagenum,$_pagesize"; $parameter = "&state=3"; } if ( $_GET['action'] == 'search' ) { $_clean = array(); $_clean['stype'] = _check($_POST['stype']); $_clean['key'] = _check($_POST['key']); if ( $_clean['stype'] == 'title' ) { _page("SELECT id FROM tb_advertising WHERE title = '{$_clean['key']}'",10); $_sql = "SELECT id,advertisingType,rewardType,title,linkPhone,state FROM tb_advertising WHERE title = '{$_clean['key']}' LIMIT $_pagenum,$_pagesize"; } elseif ( $_clean['stype'] == 'linkPhone' ) { _page("SELECT id FROM tb_advertising WHERE linkPhone = '{$_clean['key']}'",10); $_sql = "SELECT id,advertisingType,rewardType,title,linkPhone,state FROM tb_advertising WHERE linkPhone = '{$_clean['key']}' LIMIT $_pagenum,$_pagesize"; } } //$_result = _query($_sql); // // if ( isset($_GET['id']) ) { // $_sql1 = "DELETE FROM tb_advertising WHERE id = '{$_GET['id']}'"; // _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_advertising WHERE id IN ({$_clean['ids']})"; // _query($_sql2); // // if( _affected_rows() ){ // _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> <style type="text/css"> <!-- body { margin-left: 0px; margin-top: 0px; margin-right: 0px; margin-bottom: 0px; background-color: #F8F9FA; } --> </style> <script type="text/javascript"> window.onload = function(){ var form = document.getElementById('deleteAll')[0]; form.onsubmit = function(){ if(window.confirm("确定删除这批短信吗？")){ return true; } return false; } }; </script> <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="images/left-top-right.gif" width="17" height="29" /></td> <td 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="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="100%" border="0" align="center" cellpadding="0" cellspacing="0"> <tr> <td height="25" class="left_txt">查看： <a href='advertising.php'>全部 |</a> <a href="?advertisingType=1">广告浏览 |</a> <a href="?advertisingType=2">促销活动 |</a> <a href="?advertisingType=3">商家宣传 |</a> <a href="?advertisingType=4">宣传调研 |</a> <a href="?state=0">未审核 |</a> <a href="?state=1">审核通过 |</a> <a href="?state=2">未审核通过 |</a> <a href="?state=3">已删除</a> </td> </tr> <TR align="center"> <TD class="left_txt"> <form action="?action=search" method="post" onsubmit="return test();"> 关键字： <select name="stype" id="stype"> <option value="title">主题名称</option> <option value="linkPhone">联系电话</option> </select> <input name="key" type="text" id="key" /> <input name="" type="submit" value="搜索" /> </form> </td> </tr> <tr> <td><form action="?action=deleteAll" id='deleteAll' method="post" > <table width="100%" border="0" cellpadding="0" cellspacing="0" class="nowtable"> <tr align="center" bgcolor="#F2F2F2" > <td width="8%" class="left_txt2"></td> <td width="15%" class="left_txt2">模块类别</td> <td width="15%" class="left_txt2">模块类别</td> <td width="16%" class="left_txt2">奖励类型</td> <td width="16%" class="left_txt2">主题名称</td> <td width="15%" class="left_txt2">联系电话</td> <td width="15%" class="left_txt2">状态</td> <td width="15%" class="left_txt2">操作</td> </tr> <?php $_row = _num_rows($_result); if ( $_row > 0 ) { while ( $_rows = _fetch_array($_result) ) { $_html = array(); $_html['id'] = $_rows['id']; $_html['title'] = $_rows['title']; $_html['linkPhone'] = $_rows['linkPhone']; $_id = $_html['id']; switch( $_rows['advertisingType'] ) { case 1: $_html['advertisingType'] = '广告浏览'; break; case 2: $_html['advertisingType'] = '促销活动'; break; case 3: $_html['advertisingType'] = '商家宣传'; break; case 4: $_html['advertisingType'] = '宣传调研'; break; } switch( $_rows['rewardType'] ) { case 1: $_html['rewardType'] = '易币'; break; case 2: $_html['rewardType'] = '店铺积分'; break; } switch( $_rows['state'] ) { case 0: $_html['state'] = '未审核'; break; case 1: $_html['state'] = '审核通过'; break; case 2: $_html['state'] = '未审核通过'; break; case 3: $_html['state'] = '假删除'; break; } $_html = _html($_html); ?> <tr bgcolor="#F2F2F2" align="center"> <td class="left_txt2"><input name="ids[]" value="<?php echo $_html['id']?>" type="checkbox" /></td> <td class="left_txt2"><?php echo $_html['advertisingType'] ?></td> <td class="left_txt2"><?php echo $_html['rewardType'] ?></td> <td class="left_txt2"><?php echo $_html['title'] ?></td> <td class="left_txt2"><?php echo $_html['linkPhone'] ?></td> <td class="left_txt2"><?php echo $_html['state'] ?></td> <td class="left_txt2"> <a href='advertising.php?id=<?php echo $_html['id']?>'>删除</a> | <a href='advertising_edit.php?id=<?php echo $_html['id']?>'>修改</a> <?php if ( $_html['advertisingType'] == '宣传调研' ) { echo "<a href='question.php?id=$_id'>调研问题列表</a>"; } ?> </td> </tr> <?php } _free_result($_result); ?> <tr> <td height="21" colspan="7" bgcolor="#F2F2F2"><input type="submit" value="批量删除" /></td> </tr> <?php } else { echo "<tr><td colspan='7'><div style='text-align:center;color:red;font-size:16px;'>暂无点就赚信息</div></td></tr>"; } ?> </table> <?php _paging_parameter(2,$parameter); ?> </form></td> </tr> </table> </div></td> <td background="images/mail_rightbg.gif"> </td> </tr> <tr> <td valign="middle" background="images/mail_leftbg.gif"><img src="images/buttom_left2.gif" width="17" height="17" /></td> <td height="17" valign="top" background="images/buttom_bgs.gif"><img src="images/buttom_bgs.gif" width="17" height="17" /></td> <td background="images/mail_rightbg.gif"><img src="images/buttom_right2.gif" width="16" height="17" /></td> </tr> </table> </body> </html>
浙公网安备 33010602011771号