execute(); $count = $stmt->rowCount(); for ($i = 0; $i < $count; $i++) { $stmt->bindColumn("id", $itemId); $stmt->bindColumn("title", $itemTitle); $stmt->bindColumn("link", $itemLink); $stmt->bindColumn("date", $itemDate); $stmt->bindColumn("site", $site); $stmt->bindColumn("original_link", $orgLink); $stmt->bindColumn("img_url", $imgUrl); $stmt->fetch(); $siteTitle = getSiteName($site); $img = " "; $path = "/var/www/virtual/matome/img/resized/".$itemId.".jpg"; if (file_exists($path)) { $img = ""; } echo ""; } function getSiteName($siteId) { static $cache = array(); if (isset($cache[$siteId])) return $cache[$siteId]; $stmt2 = Database::prepare("select title from sites where id = :ID"); $stmt2->bindParam(":ID", $siteId); $stmt2->execute(); if ($stmt2->rowCount() == 1) { $stmt2->bindColumn("title", $title); $stmt2->fetch(); $cache[$siteId] = $title; return $cache[$siteId]; } $cache[$siteId] = ""; return $cache[$siteId]; } ?>

".$img."

".substr($itemDate,5,11)."

".$itemTitle."

".$siteTitle."