From c65053be5cb9e39714a5d10a652cb106d56d4884 Mon Sep 17 00:00:00 2001 From: Steve Sutton Date: Mon, 11 Nov 2013 21:52:56 +0000 Subject: [PATCH] Adding meta descrip for member profile pages Add meta_desc with title --- Toolkit/Template/PageControllerAbstract.php | 12 +++++++++--- 1 file changed, 9 insertions(+), 3 deletions(-) diff --git a/Toolkit/Template/PageControllerAbstract.php b/Toolkit/Template/PageControllerAbstract.php index 384f0b0..a9eebc4 100644 --- a/Toolkit/Template/PageControllerAbstract.php +++ b/Toolkit/Template/PageControllerAbstract.php @@ -78,12 +78,18 @@ abstract class Toolkit_Template_PageControllerAbstract if ($memberId = filter_var($_REQUEST['member_id'], FILTER_VALIDATE_INT)) { // get member name and put in title $sql = " - SELECT member_name + SELECT member_name,description FROM member WHERE member_id = {$memberId}"; - if ($memberName = $this->registry->dbh->query($sql)->fetchColumn()) { - $member_name = htmlentities(strip_tags($memberName)); + if ($member = $this->registry->dbh->query($sql)->fetch(PDO::FETCH_ASSOC)) { + $memberName = htmlentities(strip_tags($member['member_name'])); $glmPage->pageTitle = $member_name.' - '.$glmPage->pageTitle; + $glmPage->metaTags + = htmlentities( + substr( + trim(strip_tags($member['description'])), 0, 250 + ), ENT_QUOTES, 'UTF-8' + ); } } -- 2.17.1