payment_method_list.ihtml

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

<?php 
  search_header($payment_method_list_lbl, $modulename, "payment_method_list"); 
?>
<?php
  // Enable the multi-page search result display
  if (empty($offset))
 	$offset=0;
  if ($keyword) {
     $list  = "SELECT * FROM payment_method, shopper_group WHERE ";
     $count = "SELECT count(*) as num_rows FROM payment_method,shopper_group WHERE ";
     $q  = "(payment_method.payment_method_name LIKE '%$keyword%' ";
     $q .= "AND payment_method.vendor_id='$ps_vendor_id' ";
     $q .= "AND payment_method.shopper_group_id=shopper_group.shopper_group_id ";
     $q .= ") ";
     $q .= "ORDER BY payment_method.list_order ";
     $list .= $q . " LIMIT $offset, " . SEARCH_ROWS;
     $count .= $q;   
  }
  else 
  {
     $q = "";
     $list  = "SELECT * FROM payment_method,shopper_group WHERE ";
     $count = "SELECT count(*) as num_rows FROM payment_method,shopper_group WHERE ";
     $q .= "payment_method.vendor_id='$ps_vendor_id' ";
     $q .= "AND payment_method.shopper_group_id=shopper_group.shopper_group_id ";
     $list .= $q;
     $list .= "ORDER BY payment_method.list_order ";
     $list .= "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>
    <td><?php echo $payment_method_list_code ?></td>
    <td><?php echo $payment_method_list_name ?></td>
    <td><?php echo $payment_method_list_discount ?></td>
    <td><?php echo $payment_method_list_shopper_group ?></td>
    <td><?php echo $payment_method_list_enable_processor ?></td>
  </tr>
  <?php

$db->query($list);
 while ($db->next_record()) { 
   if ($i++ % 2) 
     $bgcolor=SEARCH_COLOR_1;
   else
     $bgcolor=SEARCH_COLOR_2;
?> 
  <tr bgcolor=<?php echo $bgcolor ?> nowrap>
    <td><?php
	$url = SECUREURL . "?page=$modulename/payment_method_form&payment_method_id=";
	$url .= $db->f("payment_method_id");
	echo "<A HREF=" . $sess->url($url) . ">";
	echo $db->f("payment_method_code");
	echo "</A>"; ?></td>
    <td><?php
	echo $db->f("payment_method_name");
?></td>
    <td><?php $db->p("payment_method_discount") ?></td>
    <td><?php $db->p("shopper_group_name") ?></td>
    <td><?php 
          if ($db->f("enable_processor")=="") { 
             echo "N";
          } 
          else { 
	     $db->p("enable_processor");
          }
          ?></td>
  </tr>
  <?php } ?> 
</table>
<?php 
  search_footer($modulename, "payment_method_list", $offset, $num_rows, $keyword); 
}
?>