Category

Development Platform
Home > SourceCode/Document > Internet-Socket-Network > WEB(ASP,PHP,...) > View Code
members1.php
Package: b2b.rar　[view]
Upload User: xuediybh
Upload Date: 2015-05-11
Package Size: 492k
Code Size: 22k
Category:

WEB(ASP,PHP,...)

Development Platform:

PHP

members1.php：Code Content
  1. <?
  2. include_once "logincheck.php"; 
  3. include_once "myconnect.php";
  4. if(count($_POST)>0)
  5. {
  6. if(isset($_POST["Update"]))
  7. {
  8. mysql_query("update b2b_members set sb_memtype=".$_REQUEST["memtype"]." where sb_id=".$_POST["id"]);
  9. //, sb_expiry_date=DATE_FORMAT(DATE_ADD(NOW(),INTERVAL 1 YEAR),'%Y%m%d%H%i%s')
  10. if(mysql_affected_rows()>0)
  11. {
  12. $msg=urlencode("Membership has been updated");
  13. header("Location:"."members.php?msg=$msg");
  14. die();
  15. }
  16. else
  17. {
  18. $msg=urlencode("No updation carried out. Please try again");
  19. header("Location:"."members.php?msg=$msg");
  20. die();
  21. }
  22. }
  23. if(isset($_POST["subscription"]))
  24. {
  25. mysql_query("update b2b_members set sb_expiry_date=DATE_FORMAT(DATE_ADD(NOW(),INTERVAL 1 YEAR),'%Y%m%d%H%i%s') where sb_id=".$_POST["id"]);
  26. //, sb_expiry_date=DATE_FORMAT(DATE_ADD(NOW(),INTERVAL 1 YEAR),'%Y%m%d%H%i%s')
  27. if(mysql_affected_rows()>0)
  28. {
  29. $msg=urlencode("Subscription has been updated");
  30. header("Location:"."members.php?msg=$msg");
  31. die();
  32. }
  33. else
  34. {
  35. $msg=urlencode("No updation carried out. Please try again");
  36. header("Location:"."members.php?msg=$msg");
  37. die();
  38. }
  39. }
  40. }
  41. function main()
  42. {
  44.  /////////////getting null char
  45. $null_char[0]="-";
  47. $strpass="";
  48. $label="All Members";
  49. $radio=1;
  51. $config=mysql_fetch_array(mysql_query("select * from b2b_config"));
  52. $recperpage=$config["sb_recperpage"];
  53. if(isset($_REQUEST["recperpage"]) && ($_REQUEST["recperpage"]<>""))
  54. {
  55. $recperpage=$_REQUEST["recperpage"];
  56. $strpass=$strpass . "&recperpage=".$_REQUEST["recperpage"] ;
  57. $strpass.="&keyword=".$_REQUEST["keyword"]."&radio=".$_REQUEST["radio"];
  58. $radio=$_REQUEST["radio"];
  59. }
  61. $sql0="select *,UNIX_TIMESTAMP(sb_ondate) as signup, UNIX_TIMESTAMP(sb_lastlogin) as lastlogin , UNIX_TIMESTAMP(sb_expiry_date) as expiry from b2b_members where 1  ";
  63. $keyword="";
  64. $searchkeyword="";
  66. if(isset($_REQUEST["keyword"]))
  67. {
  68. $keyword=$_REQUEST["keyword"];
  70. if (!get_magic_quotes_gpc()) 
  71. {
  72. $searchkeyword=str_replace('$', '$',addslashes($_REQUEST["keyword"]));
  73. }
  74. else
  75. {
  76. $searchkeyword=str_replace('$', '$',$_REQUEST["keyword"]);
  77. }
  78. $searchkeyword=trim($searchkeyword);
  79. }
  81. if(isset($_REQUEST["keyword"]) && ($_REQUEST["keyword"]<>"")&&($_REQUEST["radio"]==1))
  82. {
  83. $search_str="";
  84. $keyword_arr=explode(" ",$searchkeyword);
  85. foreach($keyword_arr as $key)
  86. {
  87. if($search_str=="")
  88. {
  89. $search_str="sb_lastname like '%$key%' or sb_firstname like '%$key%' or sb_email like '%$key%' or sb_username like '%$key%'";
  90. }
  91. else
  92. {
  93. $search_str.=" or sb_lastname like '%$key%' or sb_firstname like '%$key%' or sb_email like '%$key%' or sb_username like '%$key%'";
  94. }
  95. }
  96. $sql0.=" and ($search_str)";
  97. $label="Member Search Results for keyword <font color='#FFCC00'>".$keyword."</font>";
  98. }//end if
  100. if (isset($_REQUEST["keyword"]) && ($_REQUEST["keyword"]<>"")&&($_REQUEST["radio"]==2))
  101. {
  102. $search_str="";
  103. $keyword_arr=explode(" ",$searchkeyword);
  104. foreach($keyword_arr as $key)
  105. {
  106. if($search_str=="")
  107. {
  108. $search_str="sb_lastname like '%$key%' or sb_firstname like '%$key%' or sb_username like '%$key%'";
  109. }
  110. else
  111. {
  112. $search_str.=" or sb_lastname like '%$key%' or sb_firstname like '%$key%' or sb_username like '%$key%'";
  113. }
  114. }
  115. $sql0.=" and ($search_str)";
  116. $label="Member Search Results for Name/Username <font color='#FFCC00'>".$keyword."</font>";
  117. }//end if
  119. if (isset($_REQUEST["keyword"]) && ($_REQUEST["keyword"]<>"")&&($_REQUEST["radio"]==3))
  120. {
  121. $keyword=$_REQUEST["keyword"];
  122. $sql0=$sql0." and ( sb_id= ".(int)$searchkeyword.")";
  123. $label="Member Search Results for Member # <font color='#FFCC00'>".$keyword."</font>";
  124. }//end if
  126. $sql0=$sql0." order by sb_id desc";
  127. //echo $sql0;
  128. $query=mysql_query($sql0);
  130. $rs_query=mysql_fetch_array($query);
  131. ///////////////////////////////////PAGINATION /////////
  132. if(!isset($_REQUEST["pg"]))
  133. {
  134. $pg=1;
  135. }
  136. else 
  137. {
  138. $pg=$_REQUEST["pg"];
  139. }
  141. $rcount=mysql_num_rows($query);
  143. if ($rcount==0 )
  144. { 
  145. $pages=0;
  146. }
  147. else
  148. {
  149. $pages=floor($rcount / $recperpage);
  150. if  (($rcount%$recperpage) > 0 )
  151. {
  152. $pages=$pages+1;
  153. }
  154. }
  155. $jmpcnt=1;
  156. while ( $jmpcnt<=($pg-1)*$recperpage  && $rs_query = mysql_fetch_array($query) )
  157.     {
  158. $jmpcnt = $jmpcnt + 1;
  159. }
  161. ////////////////////////////////////////////////////////////////////////
  162. ?><script language="JavaScript">
  163. //<!--
  164. function validate(form)
  165. {
  166. if(isNaN(form.keyword.value)&&(form.radio[2].checked==true))
  167. {
  168. alert('Please Enter a valid numeric value for Member #');
  169. form.keyword.select();
  170. form.keyword.focus();
  171. return false;
  172. }
  173. return true;
  174. }
  175. //-->
  176. </script>
  177. <? $return_str=$_SERVER['PHP_SELF'];?>
  178. <table width="90%" border="0" align="center" cellpadding="0" cellspacing="0">
  179.   <tr> 
  180.     <td valign="top"> <table width="100%" border="0" align="center" cellpadding="2" cellspacing="10">
  181.         <tr> 
  182.           <td height="25" colspan="2" bgcolor="#004080"><font color="#FFFFFF" size="2" face="Arial, Helvetica, sans-serif"><strong>&nbsp;Search 
  183.             Members</strong></font></td>
  184.         </tr>
  185.         <form name="search_form" action="members.php" method="post" onSubmit="return validate(this);">
  186.           <tr> 
  187.             <td width="50%" bgcolor="#F5F5F5"><div align="right"><strong><font size="2" face="Arial, Helvetica, sans-serif">Keyword:</font></strong></div></td>
  188.             <td><input name="keyword" type="text" id="keyword" value="<?php echo $keyword;?>"></td>
  189.           </tr>
  190.           <tr align="left" valign="top"> 
  191.             <td bgcolor="#F5F5F5"><div align="right"><font color="#006699">&nbsp;</font><font size="2" face="Arial, Helvetica, sans-serif"><strong>&nbsp;Search 
  192.                 in:</strong></font></div></td>
  193.             <td><font face="Arial, Helvetica, sans-serif"> <font size="2"> 
  194.               <input name="radio" type="radio" value="1" <? if($radio==1) { echo "checked";}?>>
  195.               All</font></font><font size="2" face="Arial, Helvetica, sans-serif"> 
  196.               <input type="radio" name="radio" value="2" <? if($radio==2) { echo "checked";}?> >
  197.               Name/Username 
  198.               <input type="radio" name="radio" value="3" <? if($radio==3) { echo "checked";}?> >
  199.               Member #</font></td>
  200.           </tr>
  201.           <tr> 
  202.             <td bgcolor="#F5F5F5"><div align="right"><strong><font size="2" face="Arial, Helvetica, sans-serif">Record 
  203.                 Per Page:</font></strong></div></td>
  204.             <td><select name="recperpage">
  205.                 <option value="10" <? if($recperpage==10) { echo "selected";}?>>10</option>
  206.                 <option value="20" <? if($recperpage==20) { echo "selected";}?>>20</option>
  207.                 <option value="30" <? if($recperpage==30) { echo "selected";}?>>30</option>
  208.                 <option value="50" <? if($recperpage==50) { echo "selected";}?>>50</option>
  209.                 <option value="100" <? if($recperpage==100) { echo "selected";}?>>100</option>
  210.               </select></td>
  211.           </tr>
  212.           <tr> 
  213.             <td bgcolor="#F5F5F5">&nbsp;</td>
  214.             <td><input type="submit" name="Submit2" value="Search">
  215.             </td>
  216.           </tr>
  217.         </form>
  218.       </table></td>
  219.   </tr>
  220.   <tr> 
  221.     <td valign="top">
  222. <table width="100%" border="0" align="center" cellpadding="2" cellspacing="10">
  223.         <tr> 
  224.           <td><div align="center"> 
  225.               <table width="100%" border="0" cellspacing="0" cellpadding="1">
  226.                 <tr> 
  227.                   <td height="25" bgcolor="#004080"> <strong><font color="#FFFFFF" size="2" face="Arial, Helvetica, sans-serif"> 
  228.                     &nbsp; 
  229.                     <? echo $label;?>
  230.                     </font></strong></td>
  231.                 </tr>
  232.               </table>
  233.             </div></td>
  234.         </tr>
  235.         <tr> 
  236.           <td> <div align="center"> 
  237.               <?
  238. if (!$rs_query)
  239. {
  240. ?>
  241.               <br>
  242.               <table width="65%" border="1" align="center" cellpadding="5" bordercolor="#333333" bgcolor="#FEFCFC" >
  243.                 <tr> 
  244.                   <td align="center"><font color="#666666"><b><font face="verdana, arial" size="1"> 
  245.                     No Member satisfies the criteria you specified. </font></b></font></td>
  246.                 </tr>
  247.               </table>
  248.               <br>
  249.               <?
  250. }//end if 
  251. ?>
  252.             </div></td>
  253.         </tr>
  254.         <tr> 
  255.           <td valign="top">
  256. <div align="center"> 
  257.               <table width="100%" border="0" align="center" cellpadding="1" cellspacing="0">
  258.                 <?
  259.   $cnt=1;
  260.   while ( ($rs_query) && ($cnt<=$recperpage))
  261.     {
  262.  if($cnt%2<>0)
  263.  $bgcolor="#F5F5F5"; 
  264.  else
  265.  $bgcolor="#FFFFFF";
  266. ?>
  267.                 <tr valign="top"> 
  268.                   <td width="188" bgcolor="<? echo $bgcolor?>"> <table width="100%" border="0" cellspacing="0" cellpadding="0">
  269.                       <tr> 
  270.                         <td><font size="1"><strong><font color="#333333" size="1" face="Verdana, Arial, Helvetica, sans-serif"><a href="email.php?id=<? echo $rs_query["sb_email"];?>&return_str=<? echo $return_str;?>"><? echo $rs_query["sb_email"]; ?></a></font></strong></font></td>
  271.                       </tr>
  272.                       <tr> 
  273.                         <td><font color="#333333" size="1" face="Verdana, Arial, Helvetica, sans-serif"># 
  274.                           <? echo "      ".$rs_query["sb_id"]; ?></font></td>
  275.                       </tr>
  276.                       <tr> 
  277.                         <td><font size="1" face="Arial, Helvetica, sans-serif">&nbsp;</font></td>
  278.                       </tr>
  279.                       <tr> 
  280.                         <td><strong><font color="#333333" size="1" face="Arial, Helvetica, sans-serif"><B>Registered 
  281.                           on:</B><br>
  282.                           <? 
  283.   echo sb_date($rs_query["signup"]);
  284.   
  285.    ?>
  286.                           </font></strong></td>
  287.                       </tr>
  288.                       <tr> 
  289.                         <td><strong><font color="#333333" size="1" face="Arial, Helvetica, sans-serif">Last 
  290.                           Login:<br>
  291.                           <? 
  292.   if($rs_query["lastlogin"]<>0)
  293.   { echo sb_date($rs_query["lastlogin"]);}
  294.   else
  295.   { echo $config["sb_null_char"]; }
  296.   
  297.    ?>
  298.                           </font></strong></td>
  299.                       </tr>
  300.                     </table></td>
  301.                   <td width="136" bgcolor="<? echo $bgcolor?>"> <table width="100%" border="0" cellspacing="0" cellpadding="0">
  302.                       <tr> 
  303.                         <td><strong><font color="#333333" size="1" face="Verdana, Arial, Helvetica, sans-serif"><? echo $rs_query["sb_username"]; ?></font></strong></td>
  304.                       </tr>
  305.                       <tr> 
  306.                         <td><strong><font color="#333333" size="1" face="Arial, Helvetica, sans-serif"> 
  307.                           <? 
  308.   echo $rs_query["sb_firstname"]." ".$rs_query["sb_lastname"];
  309.   
  310.    ?>
  311.                           </font></strong></td>
  312.                       </tr>
  313.                       <tr> 
  314.                         <td><strong><font color="#333333" size="1" face="Arial, Helvetica, sans-serif"> 
  315.                           <? 
  316.   echo $rs_query["sb_street"];
  317.   
  318.    ?>
  319.                           </font></strong></td>
  320.                       </tr>
  321.                       <tr> 
  322.                         <td><strong><font color="#333333" size="1" face="Arial, Helvetica, sans-serif"> 
  323.                           <? 
  324.   
  325.   echo  $rs_query["sb_zip"].", ".$rs_query["sb_city"];
  326.    ?>
  327.                           </font></strong></td>
  328.                       </tr>
  329.                       <tr> 
  330.                         <td><strong><font color="#333333" size="1" face="Arial, Helvetica, sans-serif"> 
  331.                           <? 
  332.   
  333.   echo $rs_query["sb_state"].", ";
  334.   $country=mysql_fetch_array(mysql_query("select * from b2b_country where id=".$rs_query["sb_country"]));
  335.   if($country)
  336.   {
  337.   echo " ".$country["country"];
  338.   }
  339.    ?>
  340.                           </font></strong></td>
  341.                       </tr>
  342.                     </table></td>
  343.                   <td align="left" bgcolor="<? echo $bgcolor?>"> 
  344.                     <table width="100%" border="0" cellspacing="0" cellpadding="0">
  345.                       <tr> 
  346.                         <td><strong><font color="#333333" size="1" face="Verdana, Arial, Helvetica, sans-serif">Currently 
  347.                           <font color="#FF0000"> 
  348.                           <?php 
  349. $mem_type=mysql_fetch_array(mysql_query("select * from b2b_levels where sb_id=".$rs_query["sb_memtype"]));
  350. echo $mem_type["sb_levelname"];
  352. ?>
  353.                           </font> </font></strong></td>
  354.                       </tr>
  355.                       <tr> 
  356.                         <td><strong><font color="#333333" size="1" face="Arial, Helvetica, sans-serif"><B>Expired 
  357.                           on:</B><br>
  358.                           <? 
  359.   if($rs_query["expiry"]<>0)
  360.   { echo sb_date($rs_query["expiry"]);}
  361.   else
  362.   { echo $config["sb_null_char"]; }
  363.   
  364.    ?>
  365.                           </font></strong></td>
  366.                       </tr>
  367.                       <tr> 
  368.                         <form name="form2" method="post" action="members.php">
  369.                           <td> 
  370.                             <input name="id" type="hidden" id="id" value="<? echo $rs_query["sb_id"];?>">
  371.                             <input type="submit" name="subscription" value="Update Subscription" onClick="javascript: return confirm('Do you really want to update subscription of this Member?');">
  372.                           </td></form>
  373.                       </tr>
  374.                       <tr> 
  375.                         <form name="form1" method="post" action="members.php" ><td>
  376.                             <select name="memtype"><?php
  377. $level_q=mysql_query("select * from b2b_levels order by sb_levelid");
  378. while($level=mysql_fetch_array($level_q))
  379. {   ?><option value="<?php echo $level["sb_levelid"]; ?>" <?php
  380. if($rs_query["sb_memtype"]==$level["sb_levelid"]) {echo "selected";}
  381. ?>><?php
  382. echo $level["sb_levelname"];
  383. ?></option><?php
  384. }
  385. ?></select>
  386.                             <input name="id" type="hidden" id="id" value="<? echo $rs_query["sb_id"];?>">
  387.                             <input type="submit" name="Update" value="Update" onClick="javascript: return confirm('Do you really want to update Membership?');">
  388.                           </td></form>
  389.                       </tr>
  390.                       <tr> 
  391.                         <td>&nbsp;</td>
  392.                       </tr>
  393.                     </table></td>
  394.                   <td width="169" align="right" bgcolor="<? echo $bgcolor?>"> <table width="100%" border="0" cellspacing="0" cellpadding="0">
  395.                       <tr> 
  396.                         <td colspan="2" align="left"><font size="2" face="Arial, Helvetica, sans-serif"><strong><font color="#333333" size="1" face="Verdana, Arial, Helvetica, sans-serif">Offers 
  397.                           Posted </font></strong></font><font size="2" face="Arial, Helvetica, sans-serif"><font size="2" face="Arial, Helvetica, sans-serif">&nbsp;</font></font></td>
  398.                       </tr>
  399.                       <tr> 
  400.                         <td align="left"><font size="2" face="Arial, Helvetica, sans-serif"><strong><font color="#333333" size="1" face="Verdana, Arial, Helvetica, sans-serif">Sell 
  401.                           Offers</font></strong></font></td>
  402.                       <td align="left">
  403. <a href="selloffers.php?sb_uid=<?php echo $rs_query["sb_id"];?>">   
  404. <font size="1" face="Arial, Helvetica, sans-serif"><?
  405. $num=mysql_query("select * from b2b_offers where sb_uid=".$rs_query["sb_id"]);
  406. $num=mysql_num_rows($num);
  407. echo $num;
  408. ?></font></a></td>
  409.                       </tr>
  410.                       <tr> 
  411.                         <td align="left"><font size="2" face="Arial, Helvetica, sans-serif"><strong><font color="#333333" size="1" face="Verdana, Arial, Helvetica, sans-serif">Buy 
  412.                           Offers</font></strong></font></td>
  413.                         <td align="left"><a href="buyoffers.php?sb_uid=<?php echo $rs_query["sb_id"];?>">   
  414. <font size="1" face="Arial, Helvetica, sans-serif">
  415.                           <?
  416. $num=mysql_query("select * from b2b_offers_buy where sb_uid=".$rs_query["sb_id"]);
  417. $num=mysql_num_rows($num);
  418. echo $num;
  419. ?>
  420.                           </font></a></td>
  421.                       </tr>
  422.                       <tr> 
  423.                         <td align="left"><font size="2" face="Arial, Helvetica, sans-serif"><strong><font color="#333333" size="1" face="Verdana, Arial, Helvetica, sans-serif">Product 
  424.                           Catalogs </font></strong></font></td>
  425.                         <td align="left"><a href="products.php?sb_uid=<?php echo $rs_query["sb_id"];?>">   
  426. <font size="1" face="Arial, Helvetica, sans-serif">
  427.                           <?
  428. $num=mysql_query("select * from b2b_products where sb_uid=".$rs_query["sb_id"]);
  429. $num=mysql_num_rows($num);
  430. echo $num;
  431. ?>
  432.                           </font></a></td>
  433.                       </tr>
  434.                       <tr valign="top"> 
  435.                         <td align="left"><font size="2" face="Arial, Helvetica, sans-serif"><strong><font color="#333333" size="1" face="Verdana, Arial, Helvetica, sans-serif"> 
  436.                           Company Profile</font></strong></font></td>
  437.                         <td align="left"> <font size="1" face="Arial, Helvetica, sans-serif"> 
  438.                           <?
  439. $num=mysql_query("select * from b2b_companyprofiles where sb_uid=".$rs_query["sb_id"]);
  440. $num=mysql_num_rows($num);
  441. if($num>0)
  442. {
  443. ?>
  444.                           <a href="profiles.php?sb_uid=<?php echo $rs_query["sb_id"];?>"> <font size="1" face="Arial, Helvetica, sans-serif"> 
  445.                           Yes</a> 
  446.                           <?
  447. }
  448. else
  449. echo "No"; 
  451. ?>
  452.                           </font></td>
  453.                       </tr>
  454.                     </table></td>
  455.                 </tr>
  456.                 <tr valign="top"> 
  457.                   <td height="25" colspan="4" bgcolor="<? echo $bgcolor?>"><font size="2" face="Arial, Helvetica, sans-serif"><font size="1">[<a href="editmember.php?id=<? echo $rs_query["sb_id"];?>" >Edit 
  458.                     Profile</a>]&nbsp;&nbsp;</font><font size="2" face="Arial, Helvetica, sans-serif"><font size="1">[<a href="delete_member.php?id=<? echo $rs_query["sb_id"];?>" onClick="javascript: return confirm('All the Offers and other information related to the Member will be deleted.nnDo you really want to delete the Member?');">Delete</a>] 
  459.                     &nbsp; </font><font size="2" face="Arial, Helvetica, sans-serif"><font size="1">[<a href="messages.php?both_m=<? echo $rs_query["sb_id"];?>">Mailbox</a>]&nbsp;&nbsp;</font><font size="2" face="Arial, Helvetica, sans-serif"><font size="1">[<a href="messages.php?from_m=<? echo $rs_query["sb_id"];?>">Messages 
  460.                     Sent</a>]&nbsp;&nbsp;&nbsp;</font><font size="2" face="Arial, Helvetica, sans-serif"><font size="1">[<a href="messages.php?to_m=<? echo $rs_query["sb_id"];?>">Messages 
  461.                     Recieved</a>]</font><font size="2" face="Arial, Helvetica, sans-serif"><font size="2" face="Arial, Helvetica, sans-serif"><font size="2" face="Arial, Helvetica, sans-serif"><font size="2" face="Arial, Helvetica, sans-serif"><font size="1">&nbsp;&nbsp;&nbsp;</font><font size="2" face="Arial, Helvetica, sans-serif"><font size="1">[<a href="suspend_member.php?sb_id=<? echo $rs_query["sb_id"];?>"><?php
  462. if($rs_query["sb_suspended"]=="no")
  463. { echo "Suspend";}
  464. else
  465. { echo "Unsuspend";}
  466. ?></a>]&nbsp;&nbsp;[<a href="upgrade_member.php?id=<? echo $rs_query["sb_id"];?>">
  467. Upgrade Membership</a>]</font></font></font></font></font></font></font></font></font></font></font></td>
  468.                 </tr>
  469.                 <?
  470.   $cnt=$cnt+1;
  471.   $jmpcnt=$jmpcnt+1;
  472.   $rs_query=mysql_fetch_array($query);
  473.   }//  wend
  474. ?>
  475.               </table>
  476.               <br>
  477.               <table width="100%" border="0" cellspacing="0" cellpadding="0">
  478.                 <tr> 
  479.                   <td height="25" bgcolor="#004080"> <p> <strong><font color="#FFFFFF" size="2" face="Arial, Helvetica, sans-serif"> 
  480.                       &nbsp;Pages: &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 
  481.                       <?
  483. if ($pg>1) 
  484. {
  485.       echo "&nbsp;<a href='".$_SERVER['PHP_SELF']."?pg=".($pg-1).$strpass."' class='pagelink'><font color='#FFCC00'>"; 
  486.     
  487. }//end if
  488. if ($pages<>1)
  489. echo "Previous";
  490. if ($pg>1)
  491. {
  492. echo "</font></a>&nbsp;";
  493. }//end if
  494. echo " ";
  495. for ($i=1; $i<=$pages; $i++)
  496. {
  497. if ($pg<>$i)
  498. {
  499. echo "&nbsp;<a href='".$_SERVER['PHP_SELF']."?pg=".$i.$strpass."' class='pagelink'><font color='#FFCC00'>"; 
  500. echo $i; 
  501.     echo "</font></a>&nbsp;";
  502. }
  503. else
  504. {
  505. echo "&nbsp;".$i."&nbsp;";
  506. }
  507. }//for
  508. echo " ";
  509. if ($pg<$pages )
  510. {
  511. echo "&nbsp;<a href='".$_SERVER['PHP_SELF']."?pg=".($pg+1).$strpass."' class='pagelink'><font color='#FFCC00'>"; 
  512. }//end if
  513. if ($pages<>1)
  514. {
  515. echo "Next";
  516. }//end if
  517. if ($pg<>($pages))
  518. {
  519.     echo "</font></a>&nbsp;"; 
  520. }//end if
  521. ?>
  522.                       </font></strong></p></td>
  523.                 </tr>
  524.               </table>
  525.             </div></td>
  526.         </tr>
  527.         <tr> 
  528.           <td><div align="center"> </div></td>
  529.         </tr>
  530.       </table></td>
  531.   </tr>
  532. </table>
  533. <?
  534. }//main()
  535. include "template.php";
  536. ?>