Hi, I posted to the beginner forum, but this may be to advanced for that forum...not sure...can anyone help me? I am having issues outputting my XML document into an HTML table...it works fine, but creates a blank entry for some reason and I cannot seem to get around it. Any help is GREATLY appreciated, the code is below. Thank you!
Below is the PHP code to produce the HTML table from the XML document:
Code:
<?php
function start_tag($parser, $name, $attrs){
global $table_string;
$table_string .= "<tr>
<td width=\"100\" align=left bgcolor=#e7eee8 height=\"120px\" valign=\"middle\">
<span class=\"listingpadding03\"><img src=\"../images/thumbs/$attrs[title].gif\" width=\"100\" height=\"100\" align=\"middle\" /></span>
</td>
<td width=\"90\" align=\"center\" bgcolor=#e7eee8 height=\"120px\">
<span class=\"listingpadding03\">$attrs[artist]</span>
</td>
<td width=\"170\" align=\"center\" bgcolor=#e7eee8 height=\"120px\">
$attrs[path]
</td>
<td width=\"120px\" align=\"center\" bgcolor=#e7eee8 height=\"120px\">
<span class=\"listingpadding03\">$attrs[squarefootage]</span>
</td>
<td width=\"120px\" align=\"center\" bgcolor=#e7eee8 height=\"120px\">
<span class=\"listingpadding03\"> $attrs[bedsbaths]</span>
</td>
<td width=\"90px\" align=\"right\" bgcolor=#e7eee8 height=\"120px\">
<span class=\"listingpadding03\">$attrs[price] </span>
</td>
</tr>
<tr>
<td colspan=\"6\" height=\"7\" bgcolor=\"#ffffff\"></td>
</tr>";
}
function end_tag($parser, $name){}
$parser = xml_parser_create();
xml_parser_set_option($parser, XML_OPTION_CASE_FOLDING, 0);
xml_set_element_handler($parser, "start_tag", "end_tag");
$table_string = "<table border=\"0\" cellpadding=\"0\" cellspacing=\"0\" bgcolor=\"#e7eee8\" width=\"816\" class=\"phptablefont\">
<tr><td colspan=\"6\" bgcolor=\"#f6f6f6\"><img src=\"../images/list-fo.gif\" alt=\"Buffington Available Homes\" width=\"750\" height=\"22\" /></td></tr><tr><td colspan=\"6\"><img src=\"../images/list-head.gif\" alt=\"Buffington Available Homes\" width=\"816\" height=\"22\" /></td></tr>";
xml_parse($parser, file_get_contents("playlist.xml")) or die("Error parsing XML file");
$table_string .= "</table>";
echo $table_string;
?>
Now below is the raw simple XML file exactly (that the PHP file is reading from - it is named playlist.xml)
Code:
<songs><song title="mckinleya" artist="testing" path="one" squarefootage="two" bedsbaths="three" price="four" /><song title="mckinleya" artist="testing" path="one" squarefootage="two" bedsbaths="three" price="four" /></songs>
Thank you in advance if you can help me!!! -
Ryan
Reply With Quote
C. Ryan McVinney
Using PHP to create HTML table from external XML
