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"];