📄 featuredprod.ihtml
字号:
<?php// ----------------------------------------------------------------------// Special Products Manager// ----------------------------------------------------------------------// Module designed by Mr PHP// W: www.mrphp.com.au// E: info@mrphp.com.au// P: +61 418 436 690// ----------------------------------------------------------------------// LICENSE//// This program is free software; you can redistribute it and/or// modify it under the terms of the GNU General Public License (GPL)// as published by the Free Software Foundation; either version 2// of the License, or (at your option) any later version.//// This program is distributed in the hope that it will be useful,// but WITHOUT ANY WARRANTY; without even the implied warranty of// MERCHANTABILITY or FITNESS FOR A PARTICULAR PURPOSE. See the// GNU General Public License for more details.//// To read the license please visit http://www.gnu.org/copyleft/gpl.html// ----------------------------------------------------------------------require_once('product/lib/ps_product.inc');$ps_product = new ps_product; $db=new ps_DB; $q = "SELECT * 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 .= "AND product.product_special='Y' "; $q .= "ORDER BY product_name DESC"; $db->query($q); if($db->num_rows()!=0){ ?> <table width="100%" border="0" cellspacing="0" cellpadding="2" class="RecordsTable"> <tr align="center"> <td class="RecordsTableHeader">Featured Items</td> </tr> <?php while($db->next_record()){ ?> <tr align="center" valign="top"> <td><br /> <?php $ps_product->show_snapshot($db->f("product_sku")); ?> </td> </tr> <?php }?> </table> <?php } ?>
⌨️ 快捷键说明
复制代码
Ctrl + C
搜索代码
Ctrl + F
全屏模式
F11
切换主题
Ctrl + Shift + D
显示快捷键
?
增大字号
Ctrl + =
减小字号
Ctrl + -