setAttribute(PDO::ATTR_ERRMODE, PDO::ERRMODE_EXCEPTION);
} catch(PDOException $e) {
}
function getTotalQuotes($conn) {
$stmt = $conn->prepare("SELECT COUNT(id) As 'Count' FROM quotes;");
$stmt->execute();
$c = 0;
while ($row = $stmt->fetch()) {
$c = $row['Count'];
}
return $c;
}
function getQuoteCountByAuthor($conn) {
$stmt = $conn->prepare("SELECT author, COUNT(id) as Count FROM `quotes` GROUP BY author ORDER BY Count DESC, author ASC");
$stmt->execute();
return $stmt;
}
function getQuoteCountByTopic($conn) {
$stmt = $conn->prepare("SELECT category, COUNT(id) as Count FROM `quotes` GROUP BY category ORDER BY Count DESC, author ASC");
$stmt->execute();
return $stmt;
}
function getRandomQuote($conn) {
$stmt = $conn->prepare("SELECT author, quote FROM quotes ORDER BY RAND() LIMIT 1;");
$stmt->execute();
return $stmt;
}
function getQuoteByQuoteId($conn,$id) {
$stmt = $conn->prepare("SELECT author, quote FROM quotes WHERE id = '".$id."' LIMIT 1;");
$stmt->execute();
return $stmt;
}
function getAuthorAttributesByAuthor($conn,$author) {
$stmt = $conn->prepare("SELECT link, link_name FROM author_attributes WHERE author = :author LIMIT 1;");
$stmt->execute(['author' => $author]);
return $stmt;
}
function getRelatedQuotesByQuote($conn,$quote) {
$stmt = $conn->prepare("SELECT id, author, category, quote FROM quotes WHERE MATCH (quote) AGAINST (:keywords IN NATURAL LANGUAGE MODE) ORDER BY author ASC, quote ASC LIMIT 1,10");
$stmt->execute(['keywords' => $quote]);
return $stmt;
}
function getBestQuoteBySlug($conn,$slug) {
$stmt = $conn->prepare("SELECT * FROM best WHERE slug = :slug");
$stmt->execute(['slug' => $slug]);
return $stmt;
}
function runBestQueryBySlug($conn,$query) {
$stmt = $conn->prepare($query);
$stmt->execute();
return $stmt;
}
function displayQuoteRow($row) {
echo '