module_list.ihtml

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

<?php 
  search_header($module_list_lbl, "admin", "module_list"); 
?>

<?php 
  // Enable the multi-page search result display
  if (empty($offset))
 	$offset=0;
  if ($keyword) {
     $list  = "SELECT * FROM module WHERE ";
     $count = "SELECT count(*) as num_rows FROM module WHERE ";
     $q  = "(module_name LIKE '%$keyword%' OR ";
     $q .= "module_description LIKE '%$keyword%'";
     $q .= ") ";
     $q .= "ORDER BY list_order ASC ";
     $list .= $q . " LIMIT $offset, " . SEARCH_ROWS;
     $count .= $q;   
  }
  else 
  {
     $q = "";
     $list  = "SELECT * FROM module ORDER BY list_order ASC ";
     $count = "SELECT count(*) as num_rows FROM module ORDER BY list_order "; 
     $list .= $q . " LIMIT $offset, " . SEARCH_ROWS;
     $count .= $q;   
  }
  $db->query($count);
  $db->next_record();
  $num_rows = $db->f("num_rows");
  if ($num_rows == 0) {
     echo "你查找的结果为0.<BR>";
  }
  else {
?>
<TABLE WIDTH="100%" BORDER=0 CELLSPACING=0 CELLPADDING=5>
  <TR ALIGN=LEFT> 
    <TH NOWRAP><?php echo $module_list_name ?></TH>
    <TH><?php echo $module_list_perms ?></TH>
    <TH><?php echo $module_list_functions ?></TH>
    <TH><?php echo $module_list_order ?></TH>
  </TR>
<?php
$db->query($list);
$i = 0;
while ($db->next_record()) {
  if ($i++ % 2) 
     $bgcolor=SEARCH_COLOR_1;
  else
     $bgcolor=SEARCH_COLOR_2;
?> 
  <tr bgcolor=<?php echo $bgcolor ?>> 
    <td width="19%"> 
<?php
$url = SECUREURL . "?page=$modulename/module_form&module_id=" . $db->f("module_id");
echo "<A HREF=" . $sess->url($url) . ">";
echo $db->f("module_name");
echo "</A>"; 
?></td>
    <TD WIDTH="20%"><?php $db->p("module_perms") ?>&nbsp;</TD>
    <td width="20%"><A HREF="<?php $sess->purl(SECUREURL . "?page=$modulename/function_list&module_id=" . $db->f("module_id")); ?>">列表</A></td>
    <TD WIDTH="20%"><?php $db->p("list_order") ?></TD>
  </tr>
  <?php }  ?> 
</table>
<?php 
  search_footer($modulename, "module_list", $offset, $num_rows, $keyword); 
}
?>