📄 members1.php
字号:
<?
include_once "logincheck.php";
include_once "myconnect.php";
if(count($_POST)>0)
{
if(isset($_POST["Update"]))
{
mysql_query("update sbbleads_members set sb_memtype=".$_REQUEST["memtype"]." where sb_id=".$_POST["id"]);
//, sb_expiry_date=DATE_FORMAT(DATE_ADD(NOW(),INTERVAL 1 YEAR),'%Y%m%d%H%i%s')
if(mysql_affected_rows()>0)
{
$msg=urlencode("Membership has been updated");
header("Location:"."members.php?msg=$msg");
die();
}
else
{
$msg=urlencode("No updation carried out. Please try again");
header("Location:"."members.php?msg=$msg");
die();
}
}
if(isset($_POST["subscription"]))
{
mysql_query("update sbbleads_members set sb_expiry_date=DATE_FORMAT(DATE_ADD(NOW(),INTERVAL 1 YEAR),'%Y%m%d%H%i%s') where sb_id=".$_POST["id"]);
//, sb_expiry_date=DATE_FORMAT(DATE_ADD(NOW(),INTERVAL 1 YEAR),'%Y%m%d%H%i%s')
if(mysql_affected_rows()>0)
{
$msg=urlencode("Subscription has been updated");
header("Location:"."members.php?msg=$msg");
die();
}
else
{
$msg=urlencode("No updation carried out. Please try again");
header("Location:"."members.php?msg=$msg");
die();
}
}
}
function main()
{
/////////////getting null char
$null_char[0]="-";
$strpass="";
$label="All Members";
$radio=1;
$config=mysql_fetch_array(mysql_query("select * from sbbleads_config"));
$recperpage=$config["sb_recperpage"];
if(isset($_REQUEST["recperpage"]) && ($_REQUEST["recperpage"]<>""))
{
$recperpage=$_REQUEST["recperpage"];
$strpass=$strpass . "&recperpage=".$_REQUEST["recperpage"] ;
$strpass.="&keyword=".$_REQUEST["keyword"]."&radio=".$_REQUEST["radio"];
$radio=$_REQUEST["radio"];
}
$sql0="select *,UNIX_TIMESTAMP(sb_ondate) as signup, UNIX_TIMESTAMP(sb_lastlogin) as lastlogin , UNIX_TIMESTAMP(sb_expiry_date) as expiry from sbbleads_members where 1 ";
$keyword="";
$searchkeyword="";
if(isset($_REQUEST["keyword"]))
{
$keyword=$_REQUEST["keyword"];
if (!get_magic_quotes_gpc())
{
$searchkeyword=str_replace('$', '\$',addslashes($_REQUEST["keyword"]));
}
else
{
$searchkeyword=str_replace('$', '\$',$_REQUEST["keyword"]);
}
$searchkeyword=trim($searchkeyword);
}
if(isset($_REQUEST["keyword"]) && ($_REQUEST["keyword"]<>"")&&($_REQUEST["radio"]==1))
{
$search_str="";
$keyword_arr=explode(" ",$searchkeyword);
foreach($keyword_arr as $key)
{
if($search_str=="")
{
$search_str="sb_lastname like '%$key%' or sb_firstname like '%$key%' or sb_email like '%$key%' or sb_username like '%$key%'";
}
else
{
$search_str.=" or sb_lastname like '%$key%' or sb_firstname like '%$key%' or sb_email like '%$key%' or sb_username like '%$key%'";
}
}
$sql0.=" and ($search_str)";
$label="Member Search Results for keyword <font color='#FFCC00'>".$keyword."</font>";
}//end if
if (isset($_REQUEST["keyword"]) && ($_REQUEST["keyword"]<>"")&&($_REQUEST["radio"]==2))
{
$search_str="";
$keyword_arr=explode(" ",$searchkeyword);
foreach($keyword_arr as $key)
{
if($search_str=="")
{
$search_str="sb_lastname like '%$key%' or sb_firstname like '%$key%' or sb_username like '%$key%'";
}
else
{
$search_str.=" or sb_lastname like '%$key%' or sb_firstname like '%$key%' or sb_username like '%$key%'";
}
}
$sql0.=" and ($search_str)";
$label="Member Search Results for Name/Username <font color='#FFCC00'>".$keyword."</font>";
}//end if
if (isset($_REQUEST["keyword"]) && ($_REQUEST["keyword"]<>"")&&($_REQUEST["radio"]==3))
{
$keyword=$_REQUEST["keyword"];
$sql0=$sql0." and ( sb_id= ".(int)$searchkeyword.")";
$label="Member Search Results for Member # <font color='#FFCC00'>".$keyword."</font>";
}//end if
$sql0=$sql0." order by sb_id desc";
//echo $sql0;
$query=mysql_query($sql0);
$rs_query=mysql_fetch_array($query);
///////////////////////////////////PAGINATION /////////
if(!isset($_REQUEST["pg"]))
{
$pg=1;
}
else
{
$pg=$_REQUEST["pg"];
}
$rcount=mysql_num_rows($query);
if ($rcount==0 )
{
$pages=0;
}
else
{
$pages=floor($rcount / $recperpage);
if (($rcount%$recperpage) > 0 )
{
$pages=$pages+1;
}
}
$jmpcnt=1;
while ( $jmpcnt<=($pg-1)*$recperpage && $rs_query = mysql_fetch_array($query) )
{
$jmpcnt = $jmpcnt + 1;
}
////////////////////////////////////////////////////////////////////////
?><script language="JavaScript">
//<!--
function validate(form)
{
if(isNaN(form.keyword.value)&&(form.radio[2].checked==true))
{
alert('Please Enter a valid numeric value for Member #');
form.keyword.select();
form.keyword.focus();
return false;
}
return true;
}
//-->
</script>
<? $return_str=$_SERVER['PHP_SELF'];?>
<table width="90%" border="0" align="center" cellpadding="0" cellspacing="0">
<tr>
<td valign="top"> <table width="100%" border="0" align="center" cellpadding="2" cellspacing="10">
<tr>
<td height="25" colspan="2" bgcolor="#004080"><font color="#FFFFFF" size="2" face="Arial, Helvetica, sans-serif"><strong> Search
Members</strong></font></td>
</tr>
<form name="search_form" action="members.php" method="post" onSubmit="return validate(this);">
<tr>
<td width="50%" bgcolor="#F5F5F5"><div align="right"><strong><font size="2" face="Arial, Helvetica, sans-serif">Keyword:</font></strong></div></td>
<td><input name="keyword" type="text" id="keyword" value="<?php echo $keyword;?>"></td>
</tr>
<tr align="left" valign="top">
<td bgcolor="#F5F5F5"><div align="right"><font color="#006699"> </font><font size="2" face="Arial, Helvetica, sans-serif"><strong> Search
in:</strong></font></div></td>
<td><font face="Arial, Helvetica, sans-serif"> <font size="2">
<input name="radio" type="radio" value="1" <? if($radio==1) { echo "checked";}?>>
All</font></font><font size="2" face="Arial, Helvetica, sans-serif">
<input type="radio" name="radio" value="2" <? if($radio==2) { echo "checked";}?> >
Name/Username
<input type="radio" name="radio" value="3" <? if($radio==3) { echo "checked";}?> >
Member #</font></td>
</tr>
<tr>
<td bgcolor="#F5F5F5"><div align="right"><strong><font size="2" face="Arial, Helvetica, sans-serif">Record
Per Page:</font></strong></div></td>
<td><select name="recperpage">
<option value="10" <? if($recperpage==10) { echo "selected";}?>>10</option>
<option value="20" <? if($recperpage==20) { echo "selected";}?>>20</option>
<option value="30" <? if($recperpage==30) { echo "selected";}?>>30</option>
<option value="50" <? if($recperpage==50) { echo "selected";}?>>50</option>
<option value="100" <? if($recperpage==100) { echo "selected";}?>>100</option>
</select></td>
</tr>
<tr>
<td bgcolor="#F5F5F5"> </td>
<td><input type="submit" name="Submit2" value="Search">
</td>
</tr>
</form>
</table></td>
</tr>
<tr>
<td valign="top">
<table width="100%" border="0" align="center" cellpadding="2" cellspacing="10">
<tr>
<td><div align="center">
<table width="100%" border="0" cellspacing="0" cellpadding="1">
<tr>
<td height="25" bgcolor="#004080"> <strong><font color="#FFFFFF" size="2" face="Arial, Helvetica, sans-serif">
<? echo $label;?>
</font></strong></td>
</tr>
</table>
</div></td>
</tr>
<tr>
<td> <div align="center">
<?
if (!$rs_query)
{
?>
<br>
<table width="65%" border="1" align="center" cellpadding="5" bordercolor="#333333" bgcolor="#FEFCFC" >
<tr>
<td align="center"><font color="#666666"><b><font face="verdana, arial" size="1">
No Member satisfies the criteria you specified. </font></b></font></td>
</tr>
</table>
<br>
<?
}//end if
?>
</div></td>
</tr>
<tr>
<td valign="top">
<div align="center">
<table width="100%" border="0" align="center" cellpadding="1" cellspacing="0">
<?
$cnt=1;
while ( ($rs_query) && ($cnt<=$recperpage))
{
if($cnt%2<>0)
$bgcolor="#F5F5F5";
else
$bgcolor="#FFFFFF";
?>
<tr valign="top">
<td width="188" bgcolor="<? echo $bgcolor?>"> <table width="100%" border="0" cellspacing="0" cellpadding="0">
<tr>
⌨️ 快捷键说明
复制代码
Ctrl + C
搜索代码
Ctrl + F
全屏模式
F11
切换主题
Ctrl + Shift + D
显示快捷键
?
增大字号
Ctrl + =
减小字号
Ctrl + -