PHP error in doing xml parsing?

Question

i am working in php. I want to create xml of resul of query.

I my query result i am getting a number of URLs. When i want to create xml file of these urls a problem has occured due to spaces and some special characters in url.

If i try same thing for a url which does not has any space in url than no problem is occured.

This is my php program:-

$rs = mysql_query("SELECT urlofsong FROM music ORDER BY date DESC LIMIT 0,10")  or die ("invalid query");

//count the no. of  columns in the table 
$fcount = mysql_num_fields($rs); 

//you can choose any name for the starting tag 
//echo "$pass";
echo ("<result>"); 
while($row = mysql_fetch_array( $rs ) ) 
{ 
echo ("<tablerow>"); 
for($i=0; $i< $fcount; $i++) 
{ 
$tag = mysql_field_name( $rs, $i ); 
echo ("<$tag>". $row[$i]. "</$tag>"); 
} 
echo ("</tablerow>"); 
} 
echo ("</result>");

These type of entries in url creating problem :-"http://192.168.1.214/MusicApplication/Songs/RUFF BEAT - Baby_Justin Bieber_DJs Sunny & Puneet(VT).mp3"

Note:-please see the file name.

Please suggest me what should i do to solve this type of problem.

(related) A simple program to CRUD node and node values of xml file — Gordon
– Gordon, Commented Sep 13, 2011 at 10:34
PHP has a good bunch of built-in libraries to create XML. There's not need to handle manually all the subtleties of the XML syntax. You can use, for instance, XMLWriter. — Álvaro González
– Álvaro González, Commented Sep 13, 2011 at 10:40

Victor Vasiliev · Accepted Answer · 2011-09-13 10:34:04Z

1

You should probably escape the file name by replacing spaces with %20. Or just use urlencode() on the file name.

Also, please escape row contents with htmlspecialchars or you may end up with invalid XML.

answered Sep 13, 2011 at 10:34

Victor Vasiliev

4622 silver badges12 bronze badges

Sign up to request clarification or add additional context in comments.

1 Comment

Pushpendra Kuntal Over a year ago

then please help me by telling the procedure to convert this space %20 etc using code.

Pushpendra Kuntal · Accepted Answer · 2011-09-13 13:18:16Z

0

This is the solution for my problem... echo ("".htmlentities($row[$i]). "");

means we should pass data from htmlentities() . by using this function we can convert special characters into html characters.

Thank you all.

answered Sep 13, 2011 at 13:18

Pushpendra Kuntal

6,19620 gold badges72 silver badges120 bronze badges

Collectives™ on Stack Overflow

PHP error in doing xml parsing?

2 Answers 2

1 Comment

Comments

Your Answer

Linked

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

1 Comment

Comments

Your Answer

Sign up or log in

Post as a guest

Linked

Related