<?php $DBHandler = parse_ini_file($root_dir . '/config/database.ini', true); $firstHost = $DBHandler["firstDB"]["host"]; $firstLogin = $DBHandler["firstDB"]["login"]; $firstPassword = $DBHandler["firstDB"]["password"]; $secondHost = $DBHandler["secondDB"]["host"]; $secondLogin = $DBHandler["secondDB"]["login"]; $secondPassword = $DBHandler["secondDB"]["password"]; require_once $root_dir . '/config/bootstrap.php'; $dbHandlerOgicom = new DBHandler($secondHost, $secondLogin, $secondPassword); $ogicomHandler = $dbHandlerOgicom->getDb(); $dbHandlerLinuxPl = new DBHandler($firstHost, $firstLogin, $firstPassword); $linuxPlHandler = $dbHandlerLinuxPl->getDb(); /* using Singleton $linuxPlDbHandler=bothDbHandler::getInstance('linuxPl', $firstHost, $firstLogin, $firstPassword); $ogicomDbHandler=bothDbHandler::getInstance('ogicom', $secondHost, $secondLogin, $secondPassword); */
<!DOCTYPE html> <html lang="pl"> <head> <meta http-equiv="Content-Type" content="text/html; charset=utf-8" /> <title>Generowanie strony sitemap</title> </head> <body> <?php $root_dir = $_SERVER['DOCUMENT_ROOT'] . '/Ad9bisCMS'; $DBHandler = parse_ini_file($root_dir . '/config/database.ini', true); $secondHost = $DBHandler["secondDB"]["host"]; $secondLogin = $DBHandler["secondDB"]["login"]; $secondPassword = $DBHandler["secondDB"]["password"]; require_once $root_dir . '/config/bootstrap.php'; $dbHandlerOgicom = new DBHandler($secondHost, $secondLogin, $secondPassword); $ogicomHandler = $dbHandlerOgicom->getDb(); $siteMap = new SitemapFacadeOgicom($ogicomHandler); $siteMapData = $siteMap->getProductsData(); foreach ($siteMapData as $siteCreator) { $siteCreator['date_upd'] = explode(" ", $siteCreator['date_upd']); $site[] = array('www' => $siteCreator['link'] . '/' . $siteCreator['id_product'] . '-', "link" => $siteCreator['link_rewrite'], "date_upd" => $siteCreator['date_upd'][0], 'id' => $siteCreator['id_product']); } $siteMapCategories = $siteMap->getCategoryData(); foreach ($siteMapCategories as $siteCreator) { $siteCreator['date_upd'] = explode(" ", $siteCreator['date_upd']); $siteCategory[] = array('catAdress' => 'http://modele-ad9bis.pl/' . $siteCreator['id_category'] . '-' . $siteCreator['link_rewrite'], "date_upd" => $siteCreator['date_upd'][0]); } //header('Content-type: text/xml; charset=utf-8'); $xml = '<?xml version="1.0" encoding="utf-8"?>'; $xml .= '<urlset xmlns="http://www.sitemaps.org/schemas/sitemap/0.9" xmlns:image="http://www.google.com/schemas/sitemap-image/1.1">'; $xml .= '<url><loc>http://modele-ad9bis.pl/</loc><priority>1.0</priority><lastmod>';