Solved

Need to access an XML file from PHP

Posted on 2014-03-25
4
438 Views
Last Modified: 2014-03-25
I've been trying to access an XML file using PHP's XML Reader but I am finding it very difficult.

An example of the XML file is below... (also attached)

What I need to know is how to access for example "EMAILADDRESS" or "LOCATIONDESC" field from the <Jobs> section

Any help would be much appreciated!


<?xml version="1.0" encoding="UTF-8"?>
<JobShopExport xmlns="http://tempuri.org/JSExport.xsd">
   <Jobs>
      <Job SysKey="0" DBID="79" RefNo="J142" Con="13" CONSULTANTNAME="USER8 " EMAILADDRESS="test@gp.vu" Sector="47" SECTORNAME="Main Sector" Title="Sales Consultant" Loc="204" LOCATIONDESC="Dudley,West Midlands" Term="4" EMPTYPEDESC="Perm" MinBsc="18000" MaxBsc="20000" MinPkg="0" MaxPkg="0" HoursPW="0" Cat="65" PUBCATDESC="Sales" LOCATIONCODE="SP10 4AE" GRIDREFX="43490" GRIDREFY="14670" SDate="" EDate="" LTDRATE="" PAYERATE="" Currency="0" CURRENCYSYMBOL="" Area="11" AREADESCRIPTION="S" CreatedOn="21/December/2005" UpdatedOn="19/May/2006" PubJobDesc="" PosID="106" POSITIONDESC="Sales Consultant" Company="Test Company Ltd" ChuntID="" ChargeUnitDesc="">
         <Atts>
            <Att AttID="162" Grade="0" />
            <Att AttID="105" Grade="0" />
            <Att AttID="106" Grade="0" />
         </Atts>
      </Job>
   </Jobs>
   <SysKeys>
      <Itm DBID="0" Desc="admin  " />
   </SysKeys>
   <Master_Atts>
      <Itm DBID="405" Desc="Position" />
      <Itm DBID="411" Desc="Qualifications" />
   </Master_Atts>
   <Att_Grades>
      <Itm DBID="0" Desc="" />
   </Att_Grades>
   <Sectors>
      <Itm DBID="47" Desc="Main Sector" />
   </Sectors>
   <EmpTerms>
      <Itm DBID="4" Desc="Perm" />
   </EmpTerms>
   <Categories>
      <Itm DBID="65" Desc="Sales" />
   </Categories>
   <Job_Areas>
      <Itm DBID="11" Desc="S" />
   </Job_Areas>
   <Position_Types>
      <Itm DBID="106" Desc="Sales Consultant" />
   </Position_Types>
   <Currencies>
      <Itm DBID="0" Desc="" />
   </Currencies>
   <Charge_Units>
      <Itm DBID="0" Desc="" />
   </Charge_Units>
   <Job_Atts>
      <Itm DBID="106" Desc="Sales Consultant" MasterID="405" />
      <Itm DBID="162" Desc="Degree" MasterID="411" />
      <Itm DBID="105" Desc="Marketing" MasterID="405" />
   </Job_Atts>
   <Consultants>
      <Itm DBID="13" Desc="USER8 " EMail="test2@account.com" />
   </Consultants>
   <Locations>
      <Itm DBID="204" Desc="Andover,Hampshire" Code="SP10 4AE" GridX="43490" GridY="14670" />
   </Locations>
</JobShopExport>

Open in new window

ee.xml
0
Comment
Question by:tryinghard45
  • 2
4 Comments
 
LVL 108

Accepted Solution

by:
Ray Paseur earned 500 total points
ID: 39953006
Please see http://iconoun.com/demo/temp_tryinghard45.php

This kind of access to XML and JSON documents seems to be easiest if you use object-oriented notation.  These data types can be turned into instances of PHP StdClass objects, then you can use iterators to access the properties.

<?php // demo/temp_tryinghard45.php
error_reporting(E_ALL);
echo '<pre>';

// http://www.experts-exchange.com/Web_Development/Web_Languages-Standards/PHP/Q_28396599.html

$xml = <<<ENDXML
<?xml version="1.0" encoding="UTF-8"?>
<JobShopExport xmlns="http://tempuri.org/JSExport.xsd">
   <Jobs>
      <Job SysKey="0" DBID="79" RefNo="J142" Con="13" CONSULTANTNAME="USER8 " EMAILADDRESS="test@gp.vu" Sector="47" SECTORNAME="Main Sector" Title="Sales Consultant" Loc="204" LOCATIONDESC="Dudley,West Midlands" Term="4" EMPTYPEDESC="Perm" MinBsc="18000" MaxBsc="20000" MinPkg="0" MaxPkg="0" HoursPW="0" Cat="65" PUBCATDESC="Sales" LOCATIONCODE="SP10 4AE" GRIDREFX="43490" GRIDREFY="14670" SDate="" EDate="" LTDRATE="" PAYERATE="" Currency="0" CURRENCYSYMBOL="" Area="11" AREADESCRIPTION="S" CreatedOn="21/December/2005" UpdatedOn="19/May/2006" PubJobDesc="" PosID="106" POSITIONDESC="Sales Consultant" Company="Test Company Ltd" ChuntID="" ChargeUnitDesc="">
         <Atts>
            <Att AttID="162" Grade="0" />
            <Att AttID="105" Grade="0" />
            <Att AttID="106" Grade="0" />
         </Atts>
      </Job>
   </Jobs>
   <SysKeys>
      <Itm DBID="0" Desc="admin  " />
   </SysKeys>
   <Master_Atts>
      <Itm DBID="405" Desc="Position" />
      <Itm DBID="411" Desc="Qualifications" />
   </Master_Atts>
   <Att_Grades>
      <Itm DBID="0" Desc="" />
   </Att_Grades>
   <Sectors>
      <Itm DBID="47" Desc="Main Sector" />
   </Sectors>
   <EmpTerms>
      <Itm DBID="4" Desc="Perm" />
   </EmpTerms>
   <Categories>
      <Itm DBID="65" Desc="Sales" />
   </Categories>
   <Job_Areas>
      <Itm DBID="11" Desc="S" />
   </Job_Areas>
   <Position_Types>
      <Itm DBID="106" Desc="Sales Consultant" />
   </Position_Types>
   <Currencies>
      <Itm DBID="0" Desc="" />
   </Currencies>
   <Charge_Units>
      <Itm DBID="0" Desc="" />
   </Charge_Units>
   <Job_Atts>
      <Itm DBID="106" Desc="Sales Consultant" MasterID="405" />
      <Itm DBID="162" Desc="Degree" MasterID="411" />
      <Itm DBID="105" Desc="Marketing" MasterID="405" />
   </Job_Atts>
   <Consultants>
      <Itm DBID="13" Desc="USER8 " EMail="test2@account.com" />
   </Consultants>
   <Locations>
      <Itm DBID="204" Desc="Andover,Hampshire" Code="SP10 4AE" GridX="43490" GridY="14670" />
   </Locations>
</JobShopExport>
ENDXML;

// MAKE AN OBJECT
$obj = SimpleXML_Load_String($xml);

// ACTIVATE THIS TO SEE THE OBJECT
// var_dump($obj);

// TEASE OUT SOME DATA
$job = $obj->Jobs->Job;
var_dump($job);

foreach ($job->attributes() as $key => $val)
{
    echo PHP_EOL . "$key <b>$val</b>";
}

// SOME MORE NESTED DATA
foreach ($job->Atts->Att as $att)
{
    print_r($att);
}

Open in new window

HTH, ~Ray
0
 

Author Closing Comment

by:tryinghard45
ID: 39953157
Superb Ray - many thanks!!!

(Easy when you know how eh? !!!)

Cheers

Matt
0
 
LVL 108

Expert Comment

by:Ray Paseur
ID: 39953263
when you know how
Yep!  Took me a lot of trial and error to know how!

Thanks for the points and thanks for using EE, ~Ray
0

Featured Post

DevOps Toolchain Recommendations

Read this Gartner Research Note and discover how your IT organization can automate and optimize DevOps processes using a toolchain architecture.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

What is Node.js? Node.js is a server side scripting language much like PHP or ASP but is used to implement the complete package of HTTP webserver and application framework. The difference is that Node.js’s execution engine is asynchronous and event…
SASS allows you to treat your CSS code in a more OOP way. Let's have a look on how you can structure your code in order for it to be easily maintained and reused.
Viewers will learn about basic arrays, how to declare them, and how to use them. Introduction and definition: Declare an array and cover the syntax of declaring them: Initialize every index in the created array: Example/Features of a basic arr…
The viewer will learn the basics of jQuery, including how to invoke it on a web page. Reference your jQuery libraries: (CODE) Include your new external js/jQuery file: (CODE) Write your first lines of code to setup your site for jQuery.: (CODE)

919 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question

Need Help in Real-Time?

Connect with top rated Experts

21 Experts available now in Live!

Get 1:1 Help Now