Re: XML dom encode

Hi, Friday, October 4, 2002, 10:14:31 PM, you wrote: DÖJ> <?php DÖJ> header("Content-Type: application/xml"); DÖJ> //query database records DÖJ> $connection = mysql_connect("localhost", "user", "pass") or die("can't connect"); DÖJ> mysql_select_db("webbish"); DÖJ> $query = "SELECT id, title, artist FROM xmldb"; DÖJ> $result = mysql_query($query); DÖJ> if(mysql_num_rows($result) > 0){ DÖJ> //Create DomDocument DÖJ> $doc = new_xmldoc("1.0"); DÖJ> //Add root note DÖJ> $root = $doc->add_root("cds"); DÖJ> //Iterate through result set DÖJ> while(list($id, $title, $artist) = mysql_fetch_row($result)){ DÖJ> //create item node DÖJ> $record = $root->new_child("cd", ""); DÖJ> $record->set_attribute("id", $id); DÖJ> //Attach title and artist as children of item node DÖJ> $record->new_child("title", $title); DÖJ> $record->new_child("artist", $artist); DÖJ> } DÖJ> echo $doc->dumpmem(); DÖJ> } DÖJ> ?> DÖJ> makes a xml doc that looks like this: DÖJ> <?xml version="1.0" ?> DÖJ> - <cds> DÖJ> - <cd id="1"> DÖJ> <title>sdfsdfsdf</title> DÖJ> <artist>ssdfsdf</artist> DÖJ> </cd> DÖJ> - <cd id="2"> DÖJ> <title>asdf</title> DÖJ> <artist>asdf</artist> DÖJ> </cd> DÖJ> - <cd id="3"> DÖJ> <title>sdfasdf</title> DÖJ> <artist>?</artist> DÖJ> </cd> DÖJ> </cds> DÖJ> But I need to modify this script so that I can set the encoding of the xml document to ISO-8859-1 so it would look like this: DÖJ> <?xml version="1.0" encoding=”iso-8859-1” ?> DÖJ> - <cds> DÖJ> - <cd id="1"> DÖJ> <title>sdfsdfsdf</title> DÖJ> <artist>ssdfsdf</artist> DÖJ> </cd> DÖJ> - <cd id="2"> DÖJ> <title>asdf</title> DÖJ> <artist>asdf</artist> DÖJ> </cd> DÖJ> - <cd id="3"> DÖJ> <title>sdfasdf</title> DÖJ> <artist>?</artist> DÖJ> </cd> DÖJ> </cds> DÖJ> Any Ideas how to do this? I’ve been searching the net for solutions without any results. DÖJ> Thanks David One way to force it: <? ob_start(); echo '<?xml version="1.0" encoding="iso-8859-1"?><cds/>'; $buffer = ob_get_contents(); ob_end_clean(); $dom = domxml_open_mem($buffer); echo '<pre>'; echo htmlentities($dom->dump_mem(true)); echo '</pre>'; ?> -- regards, Tom