global $pdo_dbh;
$q = 'select * from sand.ads where active = "1" order by id desc';
$sth = $pdo_dbh->prepare($q);
$sth->execute();
$count = $sth->rowCount();
if ($count > 0) {
$res = array();
for ($i = 0; $i < $count; $i++) {
$result = $sth->fetch(PDO::FETCH_ASSOC);
$obj = new ads($result["id"], $result["title"], $result["description"], $result["register_datetime"], $result["total_clicks"], $result["url"], $result["user_id"], $result["file_name"]);
$res[] = $obj;
}
return $res;
} else {
return false;
}
}
}
$q = 'update sand.total_web_clicks
set total_clicks = total_clicks + 1
where id = 1';
$sth = $pdo_dbh->prepare($q);
$sth->execute();
$objs = AdsFactory::fetchAllAds();
$q = 'SELECT * FROM sand.total_web_clicks';
$sth = $pdo_dbh->prepare($q);
$sth->execute();
$result = $sth->fetch(PDO::FETCH_ASSOC);
ads::totalVisitingtime($result["total_clicks"]);
$totalclicks = ads::getTotalClick() + $result["total_clicks"];
