Filter XML data (with a namespace) using XPath in PHP
hoping you can help out a PHP newbie (show me C# and I'm fine!).
I want to filter XML data based on a PHP variable. Here's a cut of my XML file:
<?xml version="1.0" encoding="ISO-8859-1" ?>
<rss version="2.0" xmlns:job="https://my/namespace/URL.dtd">
<channel>
<title>search form results</title>
<link></link>
<description></description>
<item>
<title>TEST - Funeral Administrator</title>
<link> https://itrent-web1.midlandsco-op.com/tlive_webrecruitment/wrd/run//ETREC107GF.open?VACANCY_ID%3d3416494H67&WVID=6405682s15</link>
<guid> https://itrent-web1.midlandsco-op.com/tlive_webrecruitment/wrd/run//ETREC107GF.open?VACANCY_ID%3d3416494H67&WVID=6405682s15</guid>
<description><![CDATA[<b>Reference:</b> REQ000072<br /><b>Description:</b> Applications are invited for a part time, 22.5 hours per week, Funeral Administratorwhich will be based at West Bromwich Funeral Home within the West Region. Working as part of a team, duties will include co-ordinating funeral arrangements according to the clients' wishes, compiling the required administration, offering advice on the full range of services available and liaising with all relevant authorities and internal contacts. You will also be expected to assist families who wish to pay their last respects.You will be required to administer petty cash, cheque reconciliation forms, banking and purchase ledger. Other general office duties include answering the telephones, basic computer input and filing will also be key duties of this role.Applicants will have good inter-personal skills, driving licence and must also have good keyboard skills and computer literate. A flexible approach to working hours is also required.<br /><b>Region:</b> Birmingham<br /><b>Location:</b> West Bromwich<br /><b>Salary:</b> from £7.31 per hour<br /><b>Package:</b> n/a ]]></description>
<job:description>Applications are invited for a part time, 22.5 hours per week, Funeral Administratorwhich will be based at West Bromwich Funeral Home within the West Region. Working as part of a team, duties will include co-ordinating funeral arrangements according to the clients' wishes, compiling the required administration, offering advice on the full range of services available and liaising with all relevant authorities and internal contacts. You will also be expected to assist families who wish to pay their last respects.You will be required to administer petty cash, cheque reconciliation forms, banking and purchase ledger. Other general office duties include answering the telephones, basic computer input and filing will also&am开发者_如何转开发p;#x20;be key duties of this role.Applicants will have good inter-personal skills, driving licence and must also have good keyboard skills and computer literate. A flexible approach to working hours is also required.</job:description>
<job:reference>REQ000072</job:reference>
<job:salary>from £7.31 per hour</job:salary>
<job:salaryval>14800</job:salaryval>
<job:minsalary>14000</job:minsalary>
<job:maxsalary>16000</job:maxsalary>
<job:category>Funeral</job:category>
<about>Mon, 8 Aug 2011 00:00:00 GMT</about>
<job:region>Birmingham</job:region>
<job:location>West Bromwich</job:location>
<job:package>n/a</job:package>
<pubDate>Mon, 25 Jul 2011 00:00:00 GMT</pubDate>
</item>
... etc - other <item> nodes follow
I get 2 PHP variables from
$category = $_POST['category'];
$region = $_POST['region'];
I want to be able to filter my XML based on these variables but can't figure out how to do it. Note that the region and category nodes in my XML are preceded with a namespace.
Here's my (very basic so don't laugh) PHP
<?php
$xml = simplexml_load_file("jobs-rss.xml");
if(isset($_POST['category']) && isset($_POST['region']))
{
$category = $_POST['category'];
$region = $_POST['region'];
$html = '';
if($category == "All" && $region == "All")
{
// Load all jobs
foreach($xml->channel->item as $item){
$ns = $item->children('https://itrent-web1.midlandsco-op.com/tlive_webrecruitment/wrd/run/../../webrecRSS.dtd');
$html .= "<h2>" . $item->title . "</h2>";
$html .= "<p><strong>Reference: </strong>" . $ns->reference . "</p>";
$html .= "<p>" . $ns->description . "</p>";
$html .= "<p><strong>Salary: </strong>" . $ns->salary . "</p>";
$html .= "<p><strong>Region: </strong>" . $ns->region . "</p>";
$html .= "<p><strong>Location: </strong>" . $ns->location . "</p>";
$html .= "<p><strong>Category: </strong>" . $ns->category . "</p>";
$html .= "<p><strong>Closing Date: </strong>" . $ns->closingdate . "</p>";
$html .= "<p><a href='" . $item->link . "'>Click here to apply for this job</a></p>";
}
}
else
{
// Filter my XML here based on a combination of the $category and $region varaibles
}
}
echo $html;
?>
Any help would be greatly appreciated.
Thanks, Brett
By filtering, did you mean this?
<?php
$xml = simplexml_load_file("jobs-rss.xml");
if(isset($_POST['category']) && isset($_POST['region']))
{
$category = $_POST['category'];
$region = $_POST['region'];
$html = '';
// Load all jobs
foreach($xml->channel->item as $item)
{
$ns = $item->children('https://itrent-web1.midlandsco-op.com/tlive_webrecruitment/wrd/run/../../webrecRSS.dtd');
if ($category != "All" && $category != $ns->category) continue;
if ($region != "All" && $region != $ns->region) continue;
$html .= "<h2>" . $item->title . "</h2>";
$html .= "<p><strong>Reference: </strong>" . $ns->reference . "</p>";
$html .= "<p>" . $ns->description . "</p>";
$html .= "<p><strong>Salary: </strong>" . $ns->salary . "</p>";
$html .= "<p><strong>Region: </strong>" . $ns->region . "</p>";
$html .= "<p><strong>Location: </strong>" . $ns->location . "</p>";
$html .= "<p><strong>Category: </strong>" . $ns->category . "</p>";
$html .= "<p><strong>Closing Date: </strong>" . $ns->closingdate . "</p>";
$html .= "<p><a href='" . $item->link . "'>Click here to apply for this job</a></p>";
}
}
echo $html;
?>
By the way, your namespace url " https://itrent-web1.midlandsco-op.com/tlive_webrecruitment/wrd/run/../../webrecRSS.dtd " looks a bit strange. I think it would be more clear if you remove the relative '..' stuff and make it like this: https://itrent-web1.midlandsco-op.com/tlive_webrecruitment/webrecRSS.dtd SimpleXML's child() method will only work with exactly the same URI that is provided in the RSS node's xmlns:job attribute.
加载中,请稍侯......
精彩评论