public function getNews() { $sql = "SELECT \n\t\t\t\tCONCAT(:url,:seo,'/',N.idnews,'/',NT.seo) as loc,\n\t\t\t\tDATE_FORMAT(N.adddate,'%Y-%m-%d') as lastmod\n\t\t\t\tFROM news N\n\t\t\t\tLEFT JOIN newstranslation NT ON N.idnews = NT.newsid AND NT.languageid = :languageid\n\t\t\t\tWHERE N.publish = 1\n\t\t\t\tGROUP BY N.idnews"; $stmt = Db::getInstance()->prepare($sql); $stmt->bindValue('url', URL); $stmt->bindValue('languageid', Helper::getLanguageId()); $stmt->bindValue('seo', Seo::getSeo('news')); $stmt->execute(); $Data = array(); while ($rs = $stmt->fetch()) { $Data[] = array('loc' => $rs['loc'], 'lastmod' => $rs['lastmod']); } return $Data; }
public function staticcontent($id) { $sql = "SELECT\n\t\t\t\tCONCAT(:seo,'/',CC.idcontentcategory) AS link,\n\t\t\t\tCCT.name AS title\n\t\t\t\tFROM contentcategory CC\n\t\t\t\tLEFT JOIN contentcategorytranslation CCT ON CCT.contentcategoryid = CC.idcontentcategory AND CCT.languageid = :languageid\n\t\t\t\tWHERE CC.idcontentcategory = :id OR CC.idcontentcategory = (SELECT contentcategoryid FROM contentcategory WHERE idcontentcategory = :id)"; $stmt = Db::getInstance()->prepare($sql); $stmt->bindValue('seo', Seo::getSeo('staticcontent')); $stmt->bindValue('id', $id); $stmt->bindValue('languageid', Helper::getLanguageId()); $stmt->execute(); while ($rs = $stmt->fetch()) { $Data[] = array('link' => $rs['link'], 'title' => $rs['title']); } return $Data; }
public function getProductSeo($seo) { return App::getURLAdress() . Seo::getSeo('productcart') . '/' . $seo; }
<!DOCTYPE html> <html> <head> <meta http-equiv="Content-Type" content="text/html; charset=utf-8"> <title><?php echo Seo::getSeo('title'); ?> </title> <meta name="descrition" content="<?php echo Seo::getSeo('description'); ?> "> <meta name="keywords" content="<?php echo Seo::getSeo('keywords'); ?> "> <link href="<?php echo Assets::$path; ?> css/template.css" rel="stylesheet" media="all"> <script src="<?php echo Assets::$path; ?> js/jquery.js" type="text/javascript" async=""></script> <script src="<?php echo Assets::$path; ?> js/main.js" type="text/javascript" async=""></script> <script src="<?php echo Assets::$pathUtilites; ?>