'; foreach ($tipus as $tip) { foreach ($jelleg as $jel) { for ($i=1;$i<$limit;$i++) { $temp = 'Budapest '.$i.' kerület'; $kerulet = str_replace($arab,$roman,$temp); $xml.= ' '.$prefix.$tip.'/'.$jel.'/'.$kerulet.' '.date('Y-m-d').' '; } } } $conn = mysqli_connect($config['db_host'],$config['db_username'],$config['db_password'],$config['db_name']); mysqli_query($conn,"SET NAMES utf8"); mysqli_query($conn,"SET CHARACTER utf8"); mysqli_select_db($conn,'rockhome_backend'); $res = mysqli_query($conn,"SELECT * FROM hiper_ingatlan WHERE telepules NOT LIKE '%Budapest%' AND telepules<>'' GROUP BY telepules;"); while ($row = mysqli_fetch_array($res)) { foreach ($tipus as $tip) { foreach ($jelleg as $jel) { $varos = strtolower($row['telepules']); $varos = str_replace(" ","-",$varos); $varos = str_replace(".","",$varos); $accented = array( "á", "é", "í", "ó", "ö", "ő", "ú", "ü", "ű" ); $mask = array( "a", "e", "i", "o", "o", "o", "u", "u", "u" ); $varos = str_replace($accented,$mask,$varos); $xml.= ' '.$prefix.$tip.'/'.$jel.'/'.$varos.' '.date('Y-m-d').' '; } } } mysqli_select_db($conn,$config['db_name']); $res = mysqli_query($conn,"SELECT * FROM azonics_pages WHERE page_slug LIKE '%/%' AND page_status='1';"); while ($row = mysqli_fetch_array($res)) { $xml.= ' '.$prefix.$row['page_slug'].' '.date('Y-m-d').' '; } $xml.= ' '; file_put_contents("sitemap.xml",$xml); echo 'XML sitemap generated...'.PHP_EOL;