browse.ihtml

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

<table width="560" border="0" cellspacing="0" cellpadding="0" align="center">
  <tr> 
    <td>
      <table width="560" border="0" cellspacing="0" cellpadding="0" bgcolor="#E8DCB8" align="CENTER">
        <tr> 
          <td background="/phpshop/images/ec-m2.gif" valign="TOP"><img src="/phpshop/images/ec-m1.gif" height="27" width="600"><br>
            <br>
            <table width="95%" border="0" align="CENTER">
              <tr> 
                <td class="unnamed11">
<?php 
  eval(load_class("product", "ps_product"));
  $ps_product = new ps_product;
  eval(load_class("product", "ps_product_attribute"));
  $ps_product_attribute = new ps_product_attribute;
  eval(load_class("product", "ps_product_category"));
  $ps_product_category = new ps_product_category;

  eval(load_class("product", "ps_product_category"));
  $ps_product_category = new ps_product_category;


  // Enable the multi-page search result display
  if (empty($offset))
 	$offset=0;

  // Check to see if this is a search or a browse by category
  // Default is to show all products
  if ($category_id) {
  ?>
   <H3><?php echo $browse_lbl ?></H3>
   <TABLE WIDTH="100%" ALIGN=CENTER CELLSPACING=0 CELLPADDING=0 BORDER=0>
   <TR VALIGN=TOP><TD ALIGN=LEFT><B>
   <?php
     $ps_product_category->navigation_list($category_id);
   ?></B><BR>
   <?php
     $ps_product_category->print_child_list($category_id);
   ?><BR>
   </TD></TR></TABLE>
   <?php
     $list  = "SELECT * FROM product, category, product_category_xref WHERE ";
     $count  = "SELECT count(*) as num_rows FROM product, 
		product_category_xref, category WHERE ";
     $q  = "product_category_xref.category_id='$category_id' "; 
     $q .= "AND category.category_id=product_category_xref.category_id ";
     $q .= "AND product.product_id=product_category_xref.product_id ";
     $q .= "AND product.product_parent_id='' ";
     $q .= "AND product.product_publish='Y' ";
     $q .= "ORDER BY category.category_name ASC";
     $list .= $q . " LIMIT $offset, " . SEARCH_ROWS;
     $count .= $q;
  }
  elseif ($keyword) {
     echo "<H2>$search_lbl</H2>";
     $list  = "SELECT * FROM product, product_category_xref, category WHERE ";
     $count = "SELECT count(*) as num_rows FROM product, 
	       product_category_xref, category WHERE ";
     $q  = "(product.product_name LIKE '%$keyword%' OR ";
     $q .= "product.product_sku LIKE '%$keyword%' OR ";
     $q .= "product.product_s_desc LIKE '%$keyword%' OR ";
     $q .= "category.category_name LIKE '%$keyword%' OR ";
     $q .= "product.product_desc LIKE '%$keyword%'";
     $q .= ") ";
     $q .= "AND product.product_parent_id='' ";
     $q .= "AND product.product_id=product_category_xref.product_id ";
     $q .= "AND category.category_id=product_category_xref.category_id ";
     $q .= "AND product.product_publish='Y' ";
     $q .= "ORDER BY category.category_name ASC";
     $list .= $q . " LIMIT $offset, " . SEARCH_ROWS;
     $count .= $q;   
  }
  else 
  {
     echo "<H3>$browse_lbl</H3>";
     $list  = "SELECT * FROM product, product_category_xref, category WHERE ";
     $count = "SELECT count(*) as num_rows FROM product, 
              product_category_xref, category WHERE ";
     $q = "product_parent_id=''";
     $q .= "AND product.product_id=product_category_xref.product_id ";
     $q .= "AND category.category_id=product_category_xref.category_id ";
     $q .= "AND product.product_publish='Y' ";
     $q .= "ORDER BY category.category_name ASC";
     $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 "Your search returned 0 results.<BR>";
  }
  else {
?>
<TABLE BORDER=1 CELLPADDING=5 CELLSPACING=0 WIDTH="95%" ALIGN="CENTER" BORDERCOLORLIGHT="#D8BC90" BORDERCOLORDARK="#F0E8D0">
  <TBODY> 
    <TR ALIGN=left BGCOLOR="#D8BC90"> 
    <TH WIDTH="18%" CLASS="unnamed11"><?php echo $product_name_title ?></TH>
    <TH WIDTH="19%" CLASS="unnamed11"><?php echo $product_category_title ?></TH>
    <TH WIDTH="63%" CLASS="unnamed11"><?php echo $product_desc_title ?></TH>
</TR>
<?php

  $db->query($list);
  while ($db->next_record()) {
?>
  <TR VALIGN=TOP>
  <?php 
  // Set the flypage for this product based on the category.
  // If no flypage is set then use the default as set in phpshop.cfg.
  $flypage = $ps_product->get_flypage($db->f("product_id"));
  ?>
    <TD NOWRAP WIDTH="18%" CLASS="unnamed11-2" BGCOLOR="#F0E8D0"><A HREF=<?php $sess->purl(URL . "?page=$flypage&product_id=" . 
              $db->f("product_id") . "&category_id=" . $db->f("category_id")); ?>
      >∷<?php $db->p("product_name"); ?></A></TD>
    <TD NOWRAP WIDTH="19%" BGCOLOR="#E3D0B3">[<?php $db->p("category_name"); ?>]</TD>
    <TD WIDTH="63%" BGCOLOR="#F0E8D0"><?php $db->p("product_s_desc"); ?></TD>
  </TR>
<?php
  }
?>
<TR ALIGN=CENTER><TD COLSPAN=3>
<!-- Build previous/next navigation links -->
<?php
   // Check to see if we need to have previous button
   if ($offset >= SEARCH_ROWS) {
     $prevoffset=$offset-SEARCH_ROWS;
     echo "<A HREF=";
     $sess->purl(URL . "?page=$modulename/browse&category_id=$category_id&keyword=$keyword&offset=$prevoffset");
     echo ">PREV</A>&nbsp;";
   }

   // Get total pages
   $num_pages = intval($num_rows / SEARCH_ROWS);
   if ($num_rows % SEARCH_ROWS) {
      $num_pages++;
   }
   if ($num_pages != 1)
     for ($i=1;$i<=$num_pages;$i++) {
        if (($offset < $i*SEARCH_ROWS) && ($offset >= ($i-1)*SEARCH_ROWS)) {
           $pagenumber = "<FONT SIZE=+2>$i</FONT>";
        }
        else
           $pagenumber = $i;

        $newoffset = SEARCH_ROWS * ($i-1);
        echo "<A HREF=";
        $sess->purl(URL . "?page=$modulename/browse&offset=$newoffset&category_id=$category_id&keyword=$keyword");
        echo ">$pagenumber</A>&nbsp;";
     }
   
   if (($offset+SEARCH_ROWS < $num_rows) && $num_pages != 1) {
      $newoffset = $offset + SEARCH_ROWS;
      echo "<A HREF=";
      $sess->purl(URL . "?page=$modulename/browse&offset=$newoffset&category_id=$category_id&keyword=$keyword");
      echo ">NEXT</A>\n";
   }

?>
</TD></TR></TABLE>
<!-- Body ends here -->

<?php 
}
?>
</td>
              </tr>
            </table>
          </td>
        </tr>
      </table>
      <img src="/phpshop/images/ec-m3.gif" height="27" width="600"></td>
  </tr>
</table>