Changeset 6479 for temp


Ignore:
Timestamp:
2006/10/24 13:08:12 (20 years ago)
Author:
kakinaka
Message:

* empty log message *

File:
1 edited

Legend:

Unmodified
Added
Removed
  • temp/trunk/html/rss/product.php

    r6478 r6479  
    2222$objSiteInfo = new SC_SiteInfo(); 
    2323 
    24 sfprintr($objSiteInfo); 
    25 exit(); 
    26  
    2724//¿·Ãå¾ðÊó¤ò¼èÆÀ 
    2825$arrProduct = lfGetProductsDetail($objQuery, 1); 
     
    3532 
    3633//¾¦ÉʾðÊó¤ò¥»¥Ã¥È 
    37 $objPage->$arrProduct = $arrProduct; 
     34$objPage->arrProduct = $arrProduct; 
    3835 
    3936//Ź̾¤ò¥»¥Ã¥È 
     
    5653 * °ú¿ô£²:$product_id   ¾¦ÉÊID 
    5754 * Ìá¤êÃÍ:$arrProduct   ¼èÆÀ·ë²Ì¤òÇÛÎó¤ÇÊÖ¤¹ 
    58  ***************************************************************************************************************/ 
     55 **************************************************************************************************************/ 
    5956function lfGetProductsDetail($objQuery, $product_id){ 
    6057    $sql = ""; 
     
    8380} 
    8481 
    85 /*************************************************************************************************************** 
    86  * ´Ø¿ô̾:lfGetNews 
    87  * ÀâÌÀ¡¡:¿·Ãå¾ðÊó¤ò¼èÆÀ¤¹¤ë 
    88  * °ú¿ô£±:$objQuery     DBÁàºî¥¯¥é¥¹ 
    89  * Ìá¤êÃÍ:$arrNews      ¼èÆÀ·ë²Ì¤òÇÛÎó¤ÇÊÖ¤¹ 
    90  ***************************************************************************************************************/ 
    91 function lfGetShopData($objQuery){ 
    92     $col = ""; 
    93     $col .= "     news_id ";                                //¿·Ãå¾ðÊóID 
    94     $col .= "     ,news_title ";                            //¿·Ãå¾ðÊ󥿥¤¥È¥ë 
    95     $col .= "     ,news_comment ";                          //¿·Ãå¾ðÊóËÜʸ 
    96     $col .= "     ,to_char(news_date, 'YYYY') AS YEAR ";    //ÆüÉÕ(ǯ) 
    97     $col .= "     ,to_char(news_date, 'MM') AS MONTH ";     //ÆüÉÕ(·î) 
    98     $col .= "     ,to_char(news_date, 'DD') AS DAY ";       //ÆüÉÕ(Æü) 
    99     $col .= "     ,to_char(news_date, 'HH24') AS HOUR ";    //ÆüÉÕ(»þ´Ö) 
    100     $col .= "     ,to_char(news_date, 'MI') AS MINUTE ";    //ÆüÉÕ(ʬ) 
    101     $col .= "     ,to_char(news_date, 'SS') AS SECOND ";    //ÆüÉÕ(ÉÃ) 
    102     $col .= "     ,news_url ";                              //¿·Ãå¾ðÊóURL 
    103     $col .= "     ,news_select ";                           //¿·Ãå¾ðÊó¤Î¶èʬ(1:URL¡¢2:ËÜʸ) 
    104     $col .= "     ,(SELECT shop_name FROM dtb_baseinfo limit 1) AS shop_name  ";    //Ź̾ 
    105     $col .= "     ,(SELECT email04 FROM dtb_baseinfo limit 1) AS email ";           //ÂåɽEmail¥¢¥É¥ì¥¹ 
    106     $from = "dtb_news"; 
    107     $where = "del_flg = '0'"; 
    108     $order = "rank DESC"; 
    109     $objQuery->setorder($order); 
    110     $arrNews = $objQuery->select($col,$from,$where); 
    111     return $arrNews; 
    112 } 
    113  
    114  
    11582?> 
Note: See TracChangeset for help on using the changeset viewer.