Ejemplo n.º 1
0
 public function __construct(Lib_Db $db, array $bannerParams) {
     $where = '';
     foreach ($bannerParams as $key => $value) {
         $where .= $key .'=\'' . $db->escape($value) . '\' AND ';
     }
     $select = 'SELECT headers, code, rank, valid_from, valid_until FROM qu_pap_cachedbanners WHERE '.rtrim($where, 'AND ').' AND (valid_until > \''.date(self::DATETIME_FORMAT).'\' OR valid_until IS NULL) AND (valid_from < \''.date(self::DATETIME_FORMAT).'\' or valid_from IS NULL)';
     $this->res = $db->query($select);
     if($this->res){
         $this->count = mysql_num_rows($this->res);
     }
 }