XML Parser - Show top 5

[lleemon]

I have the following code below that works and pulls the data from an xml file. My question now is how can I only display the top/first 10 or 5 results? Or last 10/5 results?

I also have part of the xml doc reading.

<div id="filmcalls_feed">
<?php

//set a max value of 5 listings if variable is empty
if (empty($xmlmaxcnt)){
	$xmlmaxcnt=5;
}

$file = "http://www.filmcalls.com/events.xml";

//echo $file;

$map_array = array(
   "BOLD"    => "B",
   "EMPHASIS" => "I",
   "LITERAL"  => "TT"
);

$current = "";
$sLink = "";
$sDescription = "";
$sTitle = "";
$iCnt = 0;
$GLOBALS['Counter'] = 0;


function startElement_filmcalls($parser, $name, $attrs)
{
   global $current;
   $current = $name;
   if ($name == "ITEM") { echo ""; }
   if ($name == "LINK") { echo ""; } 
   if ($name == "TITLE") { echo ""; }
   if ($name == "DESCRIPTION") { echo ""; }
}

function endElement_filmcalls($parser, $name)
{
	$iCnt = $GLOBALS['Counter'];
   if ($name == "LINK") { echo ""; }
   if ($name == "TITLE") { echo ""; }
   if ($name == "ITEM") { echo ""; } 
   //$iFound = strpos($GLOBALS['sDescription'], "FILM FESTIVAL CALENDAR");
   //if ($GLOBALS['Counter'] > 0 && $GLOBALS['Counter'] < 6) {
	   if ($name == "DESCRIPTION") {echo "<a href=\"" . urldecode($GLOBALS['sLink']) . "\" target='_blank'>" . $GLOBALS['sTitle'] . "</a><br>" . $GLOBALS['sDescription'] . "<br><br>"; $GLOBALS['sTitle'] = ""; $GLOBALS['sDescription'] = "";}
   //}


   $iCnt++;
   //echo $iCnt & " - " & $GLOBALS['sDescription'] & "<br>";
   $GLOBALS['Counter'] = $iCnt;

}

function characterData_filmcalls($parser, $data)
{
   global $current;
   if (!(ord($data) == 10)){
	   if ($current == "TITLE") { $GLOBALS['sTitle'] .= $data; }
	   if ($current == "DESCRIPTION") { $GLOBALS['sDescription'] .= $data; } 
	   if ($current == "LINK") { $GLOBALS['sLink'] = $data;}
   }
}

$xml_parser = xml_parser_create();
// use case-folding so we are sure to find the tag in $map_array
xml_parser_set_option($xml_parser, XML_OPTION_CASE_FOLDING, true);
xml_set_element_handler($xml_parser, "startElement_filmcalls", "endElement_filmcalls");
xml_set_character_data_handler($xml_parser, "characterData_filmcalls");
if (!($fp = fopen($file, "r"))) {
   die("could not open XML input");
}

while ($data = fread($fp, 4096)) {
   if (!xml_parse($xml_parser, $data, feof($fp))) {
       die(sprintf("XML error: %s at line %d",
                   xml_error_string(xml_get_error_code($xml_parser)),
                   xml_get_current_line_number($xml_parser)));
   }
}

xml_parser_free($xml_parser);



?>
</div>

<?xml version="1.0"?>
<rss version="2.0">

<channel>
 <title>FilmCalls</title>
 <link>http://www.filmcalls.com/</link>
 <description>FILM FESTIVAL CALENDAR powered by FilmCalls.com </description>

<image>
 <title>FilmCalls</title>
 <url>http://www.filmcalls.com/images/rss_logo.gif</url>
 <link>http://www.filmcalls.com</link>
</image>

<item>
<title>Vancouver Int'l Film Festival</title>
 <link>http://www.viff.org/</link>
 <description>Vancouver, Canada | Sep 25-Oct 10, 2008</description>
</item>

<item>
<title>Lyon Int'l Film Festival</title>
 <link>http://www.hors-ecran.com/</link>
 <description>Lyon, France | Sep 30-Oct 12, 2008</description>
</item>

</channel>
</rss>

[Weedpacket]

Keep a count of how many you've read. When you get to five or ten or whatever, stop.

If you want the last five or ten, you'll need to read the whole file before outputting the results. Put the elements into an array as you read them; if the array is full, shift out the first element and put the new one on the end. When you've finished reading the file, output the contents of the array.

[lleemon]

Thanks. You can see I started doing that but commented it out. The problem is where do you do the count. I thought in the endElement function but my variable doesn't seem to count right though.

[Weedpacket]

I'd've thought it would have worked out (so long as you counted only </item>s).

If these things are not going to be too vast (er, yeah, RSS....but still, given the subject matter) you might want to look at reading the entire document into a [man]DOM[/man] structure and querying that. Using XPath the first five <item> elements would be "//item[position()<6]", and the last five would be "//item[position()>last()-5]".

[lleemon]

Got it working.

<div id="filmcalls_feed">
<?php

//set a max value of 5 listings if variable is empty
if (empty($xmlmaxcnt)){
	$xmlmaxcnt=5;
}

$GLOBALS['MaxVal'] = $xmlmaxcnt + 2;


$file = "http://www.filmcalls.com/events.xml";

//echo $file;

$map_array = array(
   "BOLD"    => "B",
   "EMPHASIS" => "I",
   "LITERAL"  => "TT"
);

$current = "";
$sLink = "";
$sDescription = "";
$sTitle = "";
$iCnt = 0;
$GLOBALS['Counter'] = 0;

/*
<item>
<title>Vancouver Int'l Film Festival</title>
 <link>http://www.viff.org/</link>
 <description>Vancouver, Canada | Sep 25-Oct 10, 2008</description>
</item>
*/

function startElement_filmcalls($parser, $name, $attrs)
{
   global $current;
   $current = $name;
   if ($name == "ITEM") { echo ""; }
   if ($name == "LINK") { echo ""; } 
   if ($name == "TITLE") { echo ""; }
   if ($name == "DESCRIPTION") { echo ""; }
}

function endElement_filmcalls($parser, $name)
{
	$iCnt = $GLOBALS['Counter'];
   if ($name == "LINK") { echo ""; }
   if ($name == "TITLE") { echo ""; }
   if ($name == "ITEM") { echo ""; } 

   if ($name == "DESCRIPTION") {$vOutput = "<a href=\"" . urldecode($GLOBALS['sLink']) . "\" target='_blank'>" . $GLOBALS['sTitle'] . "</a><br>" . $GLOBALS['sDescription'] . "<br><br>"; $GLOBALS['sTitle'] = ""; $GLOBALS['sDescription'] = "";
	$iCnt++;   

   }

//only output results if between the second entry and the entries we want to show.  First entry is skipped because it is the header info.
if ($iCnt > 1 && $iCnt < $GLOBALS['MaxVal']) { 
	echo $vOutput;  
}

   $GLOBALS['Counter'] = $iCnt;

}

function characterData_filmcalls($parser, $data)
{
   global $current;
   if (!(ord($data) == 10)){
	   if ($current == "TITLE") { $GLOBALS['sTitle'] .= $data; }
	   if ($current == "DESCRIPTION") { $GLOBALS['sDescription'] .= $data; } 
	   if ($current == "LINK") { $GLOBALS['sLink'] = $data;}
   }
}

$xml_parser = xml_parser_create();
// use case-folding so we are sure to find the tag in $map_array
xml_parser_set_option($xml_parser, XML_OPTION_CASE_FOLDING, true);
xml_set_element_handler($xml_parser, "startElement_filmcalls", "endElement_filmcalls");
xml_set_character_data_handler($xml_parser, "characterData_filmcalls");
if (!($fp = fopen($file, "r"))) {
   die("could not open XML input");
}

while ($data = fread($fp, 4096)) {
   if (!xml_parse($xml_parser, $data, feof($fp))) {
       die(sprintf("XML error: %s at line %d",
                   xml_error_string(xml_get_error_code($xml_parser)),
                   xml_get_current_line_number($xml_parser)));
   }
}

xml_parser_free($xml_parser);

?>
</div>