PHP output to XML with a while loop error

Question

I Get the error: error on line 1 at column 390: Opening and ending tag mismatch: genre line 0 and songs.

<?php
header("Content-type: text/xml");
echo "<?xml version='1.0' encoding='ISO-8859-1'?>";
echo "<songs>";
$sr = $_GET["sr"];
$conn = new PDO("mysql:host=localhost;dbname=xxxxx;","xxxxx","xxxxx");
$songresults = $conn->query("SELECT * FROM `smashhits` WHERE artist LIKE'%$sr%'");
while($row=$songresults->fetch())
{
echo "<id> ID: $row[ID] </id>";
echo "<song> Song: $row[song] </song>";
echo "<artist> Artist: $row[artist] </artist>";
echo "<year> Year: $row[year] </year>";
echo "<genre> Genre: $row[genre] <genre>";
echo "<quantity> Quantity: $row[quantity] </quantity>";
}
echo "</songs>"
?>

I would be thankful for anyone who knows what's going wrong with the code above.

Typo in your code. Your second <genre> should be </genre> — Crackertastic
– Crackertastic, Commented Sep 30, 2014 at 19:58

i alarmed alien · Accepted Answer · 2014-09-30 19:57:14Z

2

Simple error:

echo "<genre> Genre: $row[genre] <genre>";

You've opened two genre tags. I'm sure you don't need me to tell you that it should be

echo "<genre> Genre: $row[genre] </genre>";

answered Sep 30, 2014 at 19:57

i alarmed alien

9,5403 gold badges30 silver badges40 bronze badges

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

Collectives™ on Stack Overflow

PHP output to XML with a while loop error

1 Answer 1

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

Comments

Your Answer

Sign up or log in

Post as a guest

Related