[pallabmondal123]

hi

i am trying to create an xml file with help of and the code:

PHP Code:

$query="Select * from ynfx_mis_news WHERE visibility='1' AND status ='a' order by id desc limit 20";

$result=mysql_db_query($DATABASE,$query);

$num = mysql_num_rows($result);

if ($num != 0)

{

    $file= fopen("polyester.xml", "wb");

    $_xml .="<?xml version='1.0' encoding='ISO-8859-1'?>\r\n";

    $_xml .="<rss version='1.0'>\r\n";

    $_xml .="<channel>\r\n";

    $_xml .="<title>YarnsandFibers Textile News</title>\r\n";

    $_xml .="<link>http://www.yarnsandfibers.com</link>\r\n";

    $_xml .="<description>YarnsandFibers Textile News</description>\r\n";



    $_xml .="<language>en</language>\r\n";

    $_xml .="<webMaster>bharati@yarnsandfibers.com</webMaster>\r\n";

    $_xml .="<copyright>YarnsandFibers</copyright>\r\n";

    $_xml .="<pubDate>".date("r")."</pubDate>\r\n";

    $_xml .="<lastBuildDate>".date("r")."</lastBuildDate>\r\n";



    $_xml .="<image>\r\n";

    $_xml .="<title>YarnsandFibers Textile News</title>\r\n";

    $_xml .="<url>http://www.yarnsandfibers.com/images/topbanner_logonew.gif</url>\r\n";

    $_xml .="<link>http://www.yarnsandfibers.com/news/</link>\r\n";

    $_xml .="</image>\r\n";



    for($i=0; $i<$num; $i++)

    {

        $id = mysql_result($result,$i,"id");

        $title = mysql_result($result,$i,"header");

        $description =substr(mysql_result($result,$i,"body"),0,200);

        $tag = array("<br>","<p>");

        $description = strip_tags($description,$tag);

        $date_news = mysql_result($result,$i,"date_display_from");





        $product  = mysql_result($result,$i,"product");

        //echo "$i : $product <br>";

        if($product != "N;")

        {

            $PROD_news = unserialize($product);

            $sql="select name from ynfx_mis_product where id = '$PROD_news[0]' and enable='1'";

            $result3=mysql_db_query($DATABASE,$sql);

            if(mysql_error()) error("Unexpected ERROR");

            $product = mysql_result($result3,0,"name");

        }

        $_xml .="<item>\r\n";

        $_xml .="<title>".str_replace($remove,"",$title)."</title>\r\n";

        $_xml .="<link>http://www.yarnsandfibers.com/news/index_fullstory.php3?id=$id</link>\r\n";

        $_xml .="<category>".$product."</category>\r\n";

        $_xml .="<pubDate>".date("r",$date_news)."</pubDate>\r\n";

        $remove = array("\x92", "\x96","\x97");

        $_xml .="<description>".str_replace($remove,"",$description)."...</description>\r\n";

        $_xml .="</item>\r\n";

    }

    $_xml .="</channel>\r\n";

    $_xml .="</rss>\r\n";

    fwrite($file, $_xml);

    fclose($file);

}

header("location:polyester.xml");

?>

but when i want to see the polyester.xml file that time showing me following error:


The XML page cannot be displayed
Cannot view XML input using style sheet. Please correct the error and then click the Refresh button, or try again later.


--------------------------------------------------------------------------------

XML document must have a top level element. Error processing resource 'http://yarnsandfibers.dev/rss/polyester.xml'.

[UnrealEd]

what webbrowser are you using?
not all webbrowsers support xml

try opening the xml-doc in windows, instead of through your webbrowser, and check if anything is written in it. It could be that your script works just perfectly

I also recommend you to use the php-xml functions, and not just create a xml-based string. read this

if you have any questions about it, just ask, i've written some xml-parsers before

Greetz
UnrealEd

[FiRe]

Make sure you use htmlspecialchars() on all text output to the xml file!

PHP Code:

$_xml .="<description>".htmlspecialchars($description, ENT_QUOTES)."...</description>\r\n";

//etc