public function loadMeta(Connection $conn, $tablename) { self::$conn = $conn; self::$tablename = $tablename; $metamanager = new MetaManager(); $data = self::$conn->fetchAll('select * from ' . self::$tablename . ';'); $donneeTraitee = array(); foreach ($data as $meta) { $donneeTraitee[$meta['name']] = $meta['value']; } $metamanager->setTitle($donneeTraitee['title']); $metamanager->setDescription($donneeTraitee['description']); $metamanager->setContentType($donneeTraitee['contentType']); $metamanager->setRobots($donneeTraitee['robots']); $metamanager->setOgTitle($donneeTraitee['ogTitle']); $metamanager->setOgUrl($donneeTraitee['ogUrl']); $metamanager->setOgSiteName($donneeTraitee['ogSiteName']); $metamanager->setOgDescription($donneeTraitee['ogDescription']); return $metamanager; }
/** * Registers services on the given app. * * This method should only be used to configure services and parameters. * It should not get services. * * @param Application $app An Application instance */ public function register(Application $app) { $app['fabricekabongoc.seomanager'] = $app->share(function ($app) { return MetaManager::loadMeta($app['db'], $app['fabricekabongoc.']['seooptions.meta.table']); }); }