StackOverflow2013

Note that there are some explanatory texts on larger screens.

plurals

POGetting XML Numbered Entities with PHP 5 DOM
primarykey
Id
2854235
data
AcceptedAnswerId
3859878
AnswerCount
2
ClosedDate
CommentCount
0
CommunityOwnedDate
CreationDate
2010-05-18T02:31:51.883
FavoriteCount
0
LastActivityDate
2010-10-04T23:25:13.357
LastEditDate
LastEditorUserId
0
OwnerUserId
343607
ParentId
0
PostTypeId
1
Score
1
ViewCount
133
LastEditorDisplayName
text
Body
I am new here and got a question that is tricking me all day long. I've made a PHP script, that reads a website source code through cURL, then works with DOMDocument class in order to generate a sitemap file. It is working like a charm in almost every aspect. The problem is with special characters. For compatibility reasons, sitemap files needs to have all special chars encoded as numbered entities. And I am not achieving that. For example, one of my entries - automatically read from site URLs, and wrote to sitemap file - is: <a href="http://www.somesite.com/servi%C3%A7os/redesign/" rel="nofollow noreferrer">http://www.somesite.com/serviços/redesign/</a> On the source code it should looks like: *<a href="http://www.somesite.com/servi" rel="nofollow noreferrer">http://www.somesite.com/servi</a>**ç**os/redesign/* Just this. But unfortunately, I am really not figuring it out how to do it. Source code file, server headers, etc... everything is encoded as UTF-8. I'm using DOMDocument and related extensions to build the XML. (Basically, DOMDocument, $obj->createElement, $obj->appendChild). htmlentities gives ç instead of ç str_replace does not work. It makes the character just vanish in the output. I was using $obj->createElement("loc", $url); on my code, and just now I read in PHP manual that I should use $document->createTextNode($page), in order to have entities encoding support. Well, it is not working either. Any idea on how to get unstuck of this? Thanks.
Tags
<php><utf-8><special-characters><domdocument><entities>
Title
Getting XML Numbered Entities with PHP 5 DOM
singulars
PostAcceptedAnswerId
1. PO
 singulars
 PostTypePostTypeId
 PTAnswer
PostParentId
1. This table or related slice is empty.
PostTypePostTypeId
1. PTQuestion
UserLastEditorUserId
1. This table or related slice is empty.
UserOwnerUserId
1. USDave
plurals
PostLinksPostIdRelatedPostId
1. This table or related slice is empty.
PostLinksRelatedPostIdPostId
1. This table or related slice is empty.
PostsAcceptedAnswerId
1. This table or related slice is empty.
PostsParentIdCreationDate
1. PO
 singulars
 PostTypePostTypeId
 PTAnswer
2. PO
 singulars
 PostTypePostTypeId
 PTAnswer
VotesPostIdCreationDate
1. VO
 singulars
 PostPostId
 POGetting XML Numbered Entities with PHP 5 DOM
 UserUserId
 This table or related slice is empty.
 VoteTypeVoteTypeId
 VTUndeletion
2. VO
 singulars
 PostPostId
 POGetting XML Numbered Entities with PHP 5 DOM
 UserUserId
 This table or related slice is empty.
 VoteTypeVoteTypeId
 VTUpMod
CommentsPostId
1. This table or related slice is empty.

Querying!

Guidance

A row detail

Detail views are divided into sections. All the information in the data section comes from columns in the selected row. The other sections display data from other, related rows.

Related data can be related in a to-one or a to-many fashion. Captions of data related in a to-many fashion link to a list view showing a filtered view of the table.

Try moving around until you find a non-empty to-many entry and click on the label to get to one. You can move back to the root by clicking on the database name in the header.