Go4Expert

Go4Expert (http://www.go4expert.com/)
-   PHP (http://www.go4expert.com/forums/php/)
-   -   dynamically create sitemap xml using php (http://www.go4expert.com/forums/dynamically-create-sitemap-xml-using-php-t22423/)

rekha 15Jun2010 10:06

dynamically create sitemap xml using php
 
Hi,

I have created sitemap for my site using some reference code in the below link

http://stackoverflow.com/questions/2...temap-with-php

But I am getting error as

XML Parsing Error: undefined entity Location:

as my content is as follows

<< alt >> attribute and it says something like

< loc >http://www.example.com/700- & laquo;alt & raquo;-attributes-in-images.php< /loc >

Can anyone tell me how to get rid of this error.

venami 19Jun2010 10:03

Re: dynamically create sitemap xml using php
 
Could you please post your code here?

rekha 19Jun2010 10:19

Re: dynamically create sitemap xml using php
 
Hi,

I tried another code I have given below.It works fine but the encoding is the problem here.

I got the following error,

Code:

An invalid character was found in text content. Error processing resource
when I dynamically created xml file using php.The encoding I used was utf-8.I changed it to ISO-8859-1.The error resolved.But the issue is I am having tamil,hindi content So it is displayed as

Code:

ரா--
Code:

header('Content-Type: application/xml'); echo '<?xml version="1.0" encoding="UTF-8"?>'."\n"; ?> <urlset xmlns="http://www.google.com/schemas/sitemap/0.84"> <?php $sql = "SELECT * FROM table "; $result = mysql_query($sql) or die(mysql_error()); while($row = mysql_fetch_assoc($result)) { ?>  <url>  <loc>http://example.com/<?php echo $row[2]; ?></loc>  <lastmod><?php echo str_replace(' ', 'T', $row['dat']).substr(date("O"), 0, -2).':00'; ?></lastmod>  </url> <?php } ?></urlset>
How to solve this?


All times are GMT +5.5. The time now is 14:51.