con = $con; } public function getNumResults($term) { $query = $this->con->prepare("SELECT COUNT(*) as total FROM sites WHERE title LIKE :term OR url LIKE :term OR keywords LIKE :term OR description LIKE :term"); $searchTerm = "%". $term . "%"; $query->bindParam(":term", $searchTerm); $query->execute(); $row = $query->fetch(PDO::FETCH_ASSOC); return $row["total"]; } public function getResultsHtml($page, $pageSize, $term) { /* Pagination system logic ($fromLimit) page1: (1 - 1) * 20 = 0 page2: (2 - 1) * 20 = 20 page3: (3 - 1) * 20 = 40 ... */ $fromLimit = ($page - 1) * $pageSize; $query = $this->con->prepare("SELECT * FROM sites WHERE title LIKE :term OR url LIKE :term OR keywords LIKE :term OR description LIKE :term ORDER BY clicks DESC LIMIT :fromLimit, :pageSize"); $searchTerm = "%". $term . "%"; $query->bindParam(":term", $searchTerm); $query->bindParam(":fromLimit", $fromLimit, PDO::PARAM_INT); $query->bindParam(":pageSize", $pageSize, PDO::PARAM_INT); $query->execute(); $resultsHtml = "

"; while($row = $query->fetch(PDO::FETCH_ASSOC)) { $id = $row["id"]; $url = $row["url"]; $title = $row["title"]; $description = $row["description"]; $title = $this->trimField($title, 55); $description = $this->trimField($description, 230); $resultsHtml .= "

$title

$url $description

"; } $resultsHtml .= "

"; return $resultsHtml; } private function trimField($string, $characterLimit) { $dots = strlen($string) > $characterLimit ? "..." : ""; return substr($string, 0, $characterLimit) . $dots; } } ?>