PHP WebAdDao::incrementImpression Examples

Example #1

File: WebAdDao.php Project: ramielrowe/Web-Ads

 public static function getRandomAdBySizeAndDate($size, $date, $incrementImpression)
 {
     $query = "SELECT * FROM " . Database::addPrefix('webads') . " WHERE Size = '" . $size . "' AND StartingMonday = '" . DateUtil::findPreviousMonday($date) . "'";
     $result = Database::doQuery($query);
     $webads = array();
     while ($row = mysql_fetch_assoc($result)) {
         $webads[] = WebAdDao::makeAd($row);
     }
     if (mysql_num_rows($result) > 0) {
         $webad = $webads[array_rand($webads)];
         if ($incrementImpression) {
             WebAdDao::incrementImpression($webad);
         }
         return $webad;
     } else {
         return WebAd::getDefaultAd($size, $date);
     }
 }