isship_list.ihtml

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

<?php
  search_header($ship_list_lbl, $modulename, "ISship_list");
  // Enable the multi-page search result display
  if (empty($offset))
 	$offset=0;

  // Check to see if this is a search
  if ($keyword) {
     $list  = "SELECT * FROM ISshipping ";
     $count  = "SELECT COUNT(*) AS num_rows FROM ISshipping ";
     $q  = "WHERE vendor_id='$ps_vendor_id' ";
     $q .= "AND ship_publish='Y' ";
     $q .= "AND (ship_carrier_name LIKE '%$keyword%' OR ";
     $q .= "ship_carrier_code LIKE '%$keyword%' OR ";
     $q .= "ship_method_name LIKE '%$keyword%' OR ";
     $q .= "ship_method_code LIKE '%$keyword%'";
     $q .= ") ";
     $q .= "ORDER BY ship_carrier_name DESC ";
     $list  .= $q . "LIMIT $offset, " . SEARCH_ROWS;
     $count .= $q;
  }
  else 
  {
     $list  = "SELECT * FROM ISshipping ";
     $count = "SELECT COUNT(*) AS num_rows FROM ISshipping ";
     $q  = "WHERE vendor_id='$ps_vendor_id' ";
     $q .= "AND ship_publish='Y' ";
     $q .= "ORDER BY ship_carrier_name DESC ";
     $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="2">
  <tr>
    <td colspan="2">
      <H2><?php
  echo $ISship_list_lbl; ?>
      </H2>
    </TD>
    <TD colspan="3"></TD>
  </TR><?php
  $db->query($list);
  $cur_name="";
  $i=0;
  while ($db->next_record()) {
    $new_name=$db->f("ship_carrier_name");
    if ($new_name != $cur_name) {
      $cur_name=$db->f("ship_carrier_name");
      $bgcolor=SEARCH_COLOR_2; ?> 
  <TR bgcolor="<?php echo $bgcolor ?>"> 
    <TD width="35%" colspan="2"><B><?php $db->sp("ship_carrier_name") ?></B></TD>
    <TD align=center width="5%"><?php echo $ISship_list_publish_lbl ?></TD>
    <TD align=center width="30%"><?php echo $ISship_list_rate_lbl ?></TD>
    <TD align=center width="30%"><?php echo $ISship_list_lead_lbl ?></TD>
  </TR>
  <?php
    }
    $bgcolor="#FFFFFF";
?> 
  <tr nowrap bgcolor="<?php echo $bgcolor; ?>"> 
    <td width="35%"><?php
       $url = SECUREURL . "?page=$modulename/ISship_form&ship_method_id=" . $db->f("ship_method_id");
       echo "<A HREF=\"" . $sess->url($url) . "\">";
       echo $db->f("ship_method_name"); 
       echo "</A>"; ?></td><?php
    if ($db->f("ship_heavy") == "Y") { ?>
      <TD><font color="#FF0000"><b><?php echo $ISship_list_heavy_lbl ?></b></font></TD><?php
    } else { ?>
      <TD>&nbsp;</TD><?php } ?>
    <td align=center width="5%"><?php echo $db->f("ship_publish"); ?></td>
    <td align=center width="30%"><?php echo $db->f("ship_handling_charge");  if ($db->f("ship_handling_type")=="F") { echo "  $ISship_list_charge_F_lbl"; } else { echo "  $ISship_list_charge_P_lbl"; } ?></td>
    <td align=center width="30%"><?php echo $db->f("ship_lead_time") . "  $ISship_list_days_lbl"; ?></td>
  </tr>
  <?php
    } 
  }
?> 
</TABLE>
<?php
  search_footer($modulename, "ISship_list", $offset, $num_rows, $keyword);
?>