shopper_by_group_list.ihtml

php做的网上商店系统。简单易懂

<H2>按不同的用户属性列出用户</h2> 
<?php $q = "SELECT * from auth_user_md5, user_info ";
$q .= "where auth_user_md5.user_id=user_info.user_id ";
$q .= "AND auth_user_md5.perms='$perms' ";
$q .= "AND user_info.address_type='BT'";
$q .= "order by auth_user_md5.username"; 
$db->query($q);  
?> 
<table width="100%" border="0" cellspacing="0" cellpadding="2">
  <tr > 
    <td width="23%">用户名</td>
    <td width="46%">真实姓名</td>
    <td width="31%">用户属性</td>
  </tr>
  <tr> 
    <td colspan="3"> 
      <hr>
    </td>
  </tr>
  <?php
while ($db->next_record()) { ?> 
  <tr nowrap > 
    <td width="23%"><?php
$url = SECUREURL . "?page=admin/shopper_form&user_id=";
$url .= $db->f("user_id");
echo "<A HREF=" . $sess->url($url) . ">";
echo $db->f("username"); 
echo "</A>"; ?></td>
    <td width="46%"><?php echo $db->f("bill_first_name") . " ";
echo $db->f("bill_middle_name") . " ";
echo $db->f("bill_last_name"); ?></td>
    <td width="31%"><?php echo $db->f("perms");  
?>&nbsp;</td>
  </tr>
  <?php } ?> 
</table>