PHP - Getting Data Via Osm Overpass Api With Xpath & Php-simplexml

I am trying to use php to loop through an xml file and reorganize the data.  For example, if I have a xml file about books and the first xml sub tag under the <book> tag is "<type>" .  I would like to make the following tags (nodes?) as child nodes under the type tag.  For example, instead of this:
Code: [Select]
   <book>
        <type>nonFiction</type>
        <title>Advanced PHP Programming</title>
        <author>George Schlossnagle</author>
        <publisher>Developer Library</publisher>
        <category>1</category>
        <category>3</category>
   </book>
   <book>
        <type>Fiction</type>
        <title>My Novel</title>
        <author>Same Nagle</author>
        <publisher>Developer Library</publisher>
        <category>1</category>
        <category>3</category>
   </book>
I want to make the xml look like this:
Code: [Select]
   <book>
        <type>nonFiction
                <title>Advanced PHP Programming</title>
                <author>George Schlossnagle</author>
                <publisher>Developer Library</publisher>
                <category>1</category>
                <category>3</category>
        </type>
   </book>
   <book>
        <type>Fiction
             <title>My Novel</title>
             <author>Same Nagle</author>
             <publisher>Developer Library</publisher>
             <category>1</category>
             <category>3</category>
        </type>
   </book>


[attachment deleted by admin]

My parser:
<?php        
if (isset($_GET['formSubmit'])) {
$option = $_GET['option'];
$option = array_values($option);
if (!empty($option)){
$xml = simplexml_load_file('differences.xml');
$i = 0;
$count = count($option); ?>
<table>
<tr>
<td>Item</td>
        <td>Code</td>
        <td>Type</td>
        <td>Level</td>
    </tr>
<?php
while($i < $count)
{
$selected = $xml->xpath("//item[contains(@name,'".$option[$i]."')]");
echo "<tr>";
echo "<td>".$selected[0]['name']."</td>";
echo "<td>".$selected[0]['code']."</td>";
echo "<td>".$selected[0]['type']."</td>";
echo "<td>".$selected[0]['requiredLevel']."</td>";
echo "</tr>";
$i++;
} ?>
 </table>


This works great however requiredLevel is showing nothing. Here is what is stored in the $selected array:


Array ( [0] => SimpleXMLElement Object ( [@attributes] => Array ( [buildingName] => EiffelTower [code] => lM [type] => building ) [requiredLevel] => 5 [cost] => 5000 [built] => 03/31/1889  => SimpleXMLElement Object ( [@attributes] => Array ( [itemClass] => EiffelTower_construct ) ) [defaultItem] => SimpleXMLElement Object ( [@attributes] => Array ( [amount] => 1 [name] => iron ) ) [finishedReward] => iron [image] => Array ( [0] => SimpleXMLElement Object ( [@attributes] => Array ( [loadClass] => mc [name] => construct_0 [url] => /buildings/eiffel_tower.swf ) ) [1] => SimpleXMLElement Object ( [@attributes] => Array ( [loadClass] => mc [name] => construct_1 [url] => /buildings/eiffel_tower.swf ) ) [2] => SimpleXMLElement Object ( [@attributes] => Array ( [loadClass] => mc [name] => built_0 [url] => /buildings/eiffel_tower.swf ) ) [3] => SimpleXMLElement Object ( [@attributes] => Array ( [name] => icon [url] => buildings/eiffel_tower.png ) ) [4] => SimpleXMLElement Object ( [@attributes] => Array ( [name] => startIcon [url] => /buildings/eiffel_tower.png ) ) [5] => SimpleXMLElement Object ( [@attributes] => Array ( [name] => halfIcon [url] => /buildings/eiffel_tower.png ) ) [6] => SimpleXMLElement Object ( [@attributes] => Array ( [name] => completeIcon [url] => /buildings/eiffel_tower.png ) ) ) [constructionUI] => /buildings/Construct_eiffel_tower.swf [countryCard] => france )


My XML:


<element>
<item code="lM" name="snowman2010" type="building">
<requiredLevel>5</requiredLevel>
<cost>5000</cost>
<built>03/31/1889</built>
<storageType itemClass="EiffelTower_construct"/>
<defaultItem amount="1" name="iron"/>
<finishedReward>iron</finishedReward>
<image loadClass="mc" name="construct_0" url="/buildings/eiffel_tower.swf"/>
<image loadClass="mc" name="construct_1" url="/buildings/eiffel_tower.swf"/>
<image loadClass="mc" name="built_0" url="/buildings/eiffel_tower.swf"/>
<image name="icon" url="/buildings/eiffel_tower.png"/>
<image name="startIcon" url="/buildings/eiffel_tower.png"/>
<image name="halfIcon" url="/buildings/eiffel_tower.png"/>
<image name="completeIcon" url="/buildings/eiffel_tower.png"/>
<constructionUI>/buildings/eiffel_tower.swf</constructionUI>
<countryCard>france</countryCard>
</item>


Using the established code pattern in my parser.php how can I print out requiredLevel?

The output of my array is mighty confusing! [/code]

Hi everyone,

I am having trouble  with the last() function in xpath . I want to get the text3.

The HTML looks like this:


Code: [Select]
div id="body">

<br>
<br>
text1
<hr>
text2
<br>
<br>
text3


So far I have:

Code: [Select]
$lastdata= $simplexml->xpath("//div[@id='body']/following-sibling::node [last()]");


This is not working. I would appreciate any help.

Thank you in advance,

Bill

Hi all,

I am pretty new to php and I am having an issue trying to load an XML document. When ever I try to use Xpath it negates all the code below the line, including the HTML, and returns a white page. here is my code:

Code: [Select]
<html>
         <head>
        <?php
                       $xpath = new DOMXPath("structure.xml");
         ?>
          <body>
                    hello world
           </body>
</html>

I checked phpinfo() and I have both the DOM and XPath enables and installed. I have also tried using just DOM and that worked so it is only Xpath that is not working. Ideas?

Thank you
James S



 

I am having trouble obtaining the second table in this HTML code:
Code: [Select]
<!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN" "http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd">
<html xmlns="http://www.w3.org/1999/xhtml">
<head><html>
<head>
<meta http-equiv="Pragma" content="no-cache">
<title>Entity Information</title>
<link rel="stylesheet" href="documents/CORP/default.css" media="screen" type="text/css">
<link rel="stylesheet" href="documents/CORP/infotable.css" media="screen" type="text/css">
</head>
<body>
<div class="headings">
<h1 class="dos_heading1">Company Information </h1>
<BR>
<h2 class="dos_heading2">&nbsp;</h2>
<h3 class="page_heading">Company Information</h3>
<p class="DtMsg">The information contained in this database is current through September 10, 2010.</p>
</div>
<hr noshade width="100%">
<center>
<div class="highlight">Selected Company Name:&nbsp;1 PARK ROW, LLC</div>
      <table summary="This table contains status information for the selected entity.">
         <caption>
         Selected Company Status Information
         </caption>
         <tr>
            <th>Current Company Name:</th>
            <td>1 PARK ROW, LLC</td>
         </tr>
         <tr>
            <th>Initial  Filing Date:</th>
            <td>JANUARY   22, 1997</td>
         </tr>
         <tr>
            <th>County:</th>
            <td>NASSAU</td>
         </tr>
         <tr>
            <th>Jurisdiction:</th>
            <td>NEW JERSEY </td>
         </tr>
         <tr>
            <th>Entity Type:</th>
            <td>DOMESTIC LIMITED LIABILITY COMPANY</td>
         </tr>
         <tr>
            <th>Current Company Status:</th>
            <td>ACTIVE
</td>
         </tr>
      </table>
<BR>
<table id="tblAddr" summary="This table contains address information for the selected entity.">
<caption>Selected Entity Address Information</caption>
<tr>
<th scope="col" id="c1" class="leftalign"><span class="rmvbold">Address</span></th>
</tr>
<tr>
<td headers="c1">
C/O ELECTRONICS INC.<br>
2355 PARK ROW<br>
NEW BRUNSWICK, NEW YORK, 15538
</td>
</tr>
<tr>
<th scope="col" id="c4" class="leftalign">Registered Agent</th>
</tr>
<tr>
<td headers="c1">
NONE
</td>
</tr>
</table>
<br>
<p style="width:50%">&nbsp;</p>     
<div id="divStockContainer">
         <h4 id="capStock">*Stock Information</h4>
         <div id="divStock">
            <table id="tblStock" cellpadding="0" cellspacing="6">
               <tr>
                  <th># of Shares</th>
                  <th>Type of Stock</th>
                  <th>$ Value per Share</th>
               </tr>
            <tr>
               <td>&nbsp;</td>
               <td>No Information Available</td>
               <td>&nbsp;</td>
            </tr>
           </table>
         </div>
         <p id="pStockBlurb">*Stock information is applicable to domestic business corporations.</p>
  </div>
  <div id="divHistNmContainer">
         <h4 id="capNmHist">Name History</h4>
         <div id="divNmHist">
            <table id="tblNameHist" cellpadding="0" cellspacing="6">
               <tr>
                  <th class="FileDt">Filing Date</th>
                  <th class="NameType">Name Type</th>
                  <th class="CorpName">Company Name</th>
               </tr>
            <tr>
               <td class="FileDt">JAN 22, 1997</td>
               <td class="NameType">Actual</td>
               <td class="CorpName">1 PARK ROW, LLC</td>
            </tr>
           </table>
         </div>
    <p id="pFictName">&nbsp;</p>
      </div>
</center>
</body>
</html> <script language='javascript' src='https://a12.alphagodaddy.com/hosting_ads/gd01.js'></script></script>


I can get the top part with this:

/*** a new dom object ***/ 
    $dom = new domDocument; 

    /*** load the html into the object ***/ 
    $dom->loadHTML($html2); 

    /*** discard white space ***/ 
    $dom->preserveWhiteSpace = false; 

    /*** the table by its tag name ***/ 
    $tables = $dom->getElementsByTagName('table'); 

    /*** get all rows from the table ***/ 
    $rows = $tables->item(0)->getElementsByTagName('tr'); 

    /*** loop over the table rows ***/ 
    foreach ($rows as $row) 
    { 
        /*** get each column by tag name ***/ 
$cols = $row->getElementsByTagName('td');
        /*** echo the values ***/ 
        echo $cols->item(0)->nodeValue.'<br />'; 
        echo $cols->item(1)->nodeValue.'<br />'; 
        echo $cols->item(2)->nodeValue; 
        echo '<hr />'; 
    }

}



Any help would be appreciated I dont even know where to start to echo the 2nd table in the html. Thanks.

Hello, I recently moved hosts and upgraded to PHP 7.4.10. Suddenly, one of my sites is having issues with XSL views. The software creator claims this is an issue with XSL in PHP. I am unsure of what to check to troubleshoot this. Would anyone have an opinion on my issue? If not, please let me know if I should be posting somewhere else altogether. Thanks in advance -

 

Quote

xmlXPathCompOpEval: function function not found
XPath error : Unregistered function
xmlXPathCompiledEval: 3 objects left on the stack.
runtime error: file /Sitessection/view.xsl line 32 element value-of
XPath evaluation returned no result

The view.xsl file:

 

Quote

        <xsl:value-of select="php:function( 'SobiPro::AlternateLink', $rssUrl, 'application/atom+xml', $sectionName )"/>
        <xsl:variable name="showCategoriesLabel">
            <xsl:value-of select="php:function( 'SobiPro::Txt', 'CATEGORIES_SHOW' )"/>
        </xsl:variable>

 

Code: [Select]
$domdoc=new DOMDocument();
$domdoc->formatOutput=TRUE;

$empty_cart_xml=
'<Order>
<Cart>
<Items>
<Item>1</Item>
<Item>2</Item>
<Item>3</Item>
</Items>
</Cart>
</Order>';

$domdoc->loadXML($empty_cart_xml);
print $domdoc->saveXML()."<hr/>"; //works up to this point

$xpath=new DOMXPath($domdoc);

$items=$xpath->query('Order/Cart/Items');
foreach($itemses AS $items)
{
$items->appendChild($domdoc->createElement('Item','4'));
}

print $domdoc->saveXML();

All I want to do is to add a new Item to Items.  What am I doing wrong?

Hi all,

I'm sure I'm making this far more difficult than I need to...

I've got an xml document...

<library id="1">
<lname>Lib1</name>
<book id="1">
<title>book 1</title>
<author>Author 1</author>
</book>
<book id="2">
<title>book 2</title>
<author>Author 2</author>
</book>
</library>

I can access the nested elements using xpath like :

$result = $xml->xpath('//book');

    foreach($result as $books) {
        echo $books->title;
    }

How would I do this for the attributes? If I specify I want the attributes in the xpath query I can't get at the elements...

I'm trying to turn this xml file into a simple relational database... A library table and a book table.

So I need the library id (attribute) and the name(nested element) for one insert query - and the book id, title, author and the library id for the other.


Anyone got any idea?

Cheers

John

Hi all

I am trying to get the lat and long properties from the googlemaps geocoding api.

$xml=simplexml_load_file($url);
if ($xml === false) {
    echo "Failed loading XML\n";
    foreach(libxml_get_errors() as $error) {
        echo "\t", $error->message;
    }
}
else{
           $path = $xml->xpath( "/GeocodeResponse/result/geometry/location");
            $lat = $path->lat;
            $lng = $path->lng;
            echo $lat;
            echo $lng;
           $sql1 = "UPDATE tbl_clubs set lat='$lat',lng='$lng' where club_id =$id";
           echo $sql1;
           $result1 = mysqli_query($dbConn,$sql1) or die($mysqli_error($dbConn));
}

This is the XML  I am using

<GeocodeResponse>
<status>OK</status>
<result>
<type>establishment</type>
<type>point_of_interest</type>
<type>stadium</type>
<formatted_address>Aldridge Rd, Perry Barr, Birmingham B42 2ET, UK</formatted_address>
<address_component>
</address_component>
<address_component>
</address_component>
<address_component>
</address_component>
<address_component>
<long_name>West Midlands</long_name>
<short_name>West Midlands</short_name>
<type>administrative_area_level_2</type>
<type>political</type>
</address_component>
<address_component>
<long_name>England</long_name>
<short_name>England</short_name>
<type>administrative_area_level_1</type>
<type>political</type>
</address_component>
<address_component>
<long_name>United Kingdom</long_name>
<short_name>GB</short_name>
<type>country</type>
<type>political</type>
</address_component>
<address_component>
<long_name>B42 2ET</long_name>
<short_name>B42 2ET</short_name>
<type>postal_code</type>
</address_component>
<geometry>
<location>
<lat>52.5196698</lat>
<lng>-1.8986236</lng>
</location>
<location_type>GEOMETRIC_CENTER</location_type>
<viewport>
<southwest>
<lat>52.5183208</lat>
<lng>-1.8999726</lng>
</southwest>
<northeast>
<lat>52.5210188</lat>
<lng>-1.8972746</lng>
</northeast>
</viewport>
</geometry>

 

But I am getting the following response

Notice: Trying to get property of non-object in /home/sites/1a/9/95f15f28a6/public_html/results/getLatLng.php on line 22

I am guessing my path is wrong, any guidance would be great

hi, im trying to parse this xml  file : 
xml.gamebookers.com/sport /football.xml_attr.xml

i want to echo on my page like this :

league name 1
match 1 of league 1
odds odds odds
match 2 of league 1
odds odds odds
.
.
league name 2
match 1 of league 2
odds odds odds
match2 of league 2
odds odds odds
.
.


this is my code so far

<?php
$xml=simplexml_load_file('http://xml.gamebookers.com/sports/football.xml_attr.xml');

$league=$xml->xpath('//event/..');             // leagues refers to element<group> 
$matches=$xml->xpath('//bettype[@name="Versus (with Draw)"]/..'); // shows matches name (team versus team)
$odds=$xml->xpath('//event/bettype[@name="Versus (with Draw)"]/bet'); //odds of matches 1 x 2


$leaguecount=count($league);
$matchescount=count($matches);
$oddscount=count($odds);

$i=0;

while ($i<$leaguecount){
echo $league[$i]['name'].'<br>';
$i++;
}

echo '<br><br>';

$i=0;
while ($i<$matchescount){
echo $matches[$i]['name'].'<br>';
$i++;
}

$i=0;
while ($i<$oddscount){
echo $odds[$i]['odd'].'<br>';
$i++;
}

?>


it prints this:
http://www.mh724.com/school/xp.php

so i need something like that:
echo league[$i][mathces[$i][odds[$i]  // like arrays of array but it does not work of course

any help will highly appreciated  :shrug:

with regardS

<league name="italy" id="1">
     <match name="AC Milan v Palermo" time="15/02/2011 20:45">
          <bettype name="Versus (with Draw)">
          <bet outcome_name="AC Milan"      odd="1.87">
               <bet outcome_name="X"                 odd="3.40">
               <bet outcome_name="Palermo"  odd="4.00">
          </bettype>
    </match>

    <match name="Juventus v Torino"  time="15/02/2011 20:45">
         <bettype name="Versus (with Draw)">
                <bet outcome_name="Juventus"   odd="2.00">
              <bet outcome_name="X"          odd="3.00">
              <bet outcome_name="Torino"  odd="2.00">
         </bettype>
   <bettype name="Half Time">
               <bet outcome_name="1"  odd="2.40">
               <bet outcome_name="X"  odd="3.40">
               <bet outcome_name="2"  odd="1.40">
          </bettype>
     </match>
</league>

<league name="Spain" id="2">
     <match name="Barcelona v Real Madrid" time="15/03/2011 21:45">
          <bettype name="Versus (with Draw)">
          <bet outcome_name="Barcelona"    odd="1.87">
               <bet outcome_name="X"            odd="3.40">
               <bet outcome_name="Real Madrid"  odd="4.00">
         </bettype>
     </match>
</league>


im trying to parse attributes of above xml  with using xpath functions. what i want to output is this:
(  <bettype name="Half Time"> this will be ignored   )


Italy
AC Milan v Palermo
1.87 3.40 4.00
Juventus v Torino
2.00 3.00 2.00

spain
Barcelona v Real Madrid
1.87 3.40 4.00



im trying do this with below xpath codes



$xml=simplexml_load_file('http://xml.gamebookers.com/sports/football.xml_attr.xml');
$league=$xml->xpath("//league");          
$matches=$xml->xpath('//bettype[@name="Versus (with Draw)"]/..'); 
$odds=$xml->xpath('//match/bettype[@name="Versus (with Draw)"]/bet'); 



i searched and tried lots of tutorials. i need help in writing the correct code
thanks

Hi,  I'm new to php and coding in general.  I'm trying to parse xml from a remote device and access specific value data.

Here is the xml:

<?xml version="1.0" encoding="ISO-8859-1" ?>
- <Device id="S10011" hb="1935">
  <Group id="1" />
  <Group id="2" />
  <Group id="3" />
  <Group id="4" />
  <Group id="5" />
  <Group id="6" />
  <Group id="7" />
  <Group id="8" />
- <Group id="9">
- <Probe id="99">
  <Value>1.0</Value>
  </Probe>
- <Probe id="1">
  <Value>86.4</Value>
  </Probe>
- <Probe id="2">
  <Value>45.7</Value>
  </Probe>
- <Probe id="3">
  <Value>2.9</Value>
  </Probe>
- <Probe id="4">
  <Value>1.0</Value>
  </Probe>
  </Group>
  </Device>
-----------------------
Here is my php code to read in the xml:
<?php
   // Establish a port 80 connection
   $http = fsockopen("192.168.2.106",80);

   // Send a request to the server
   $req = "GET /xmldata HTTP/1.0\r\n";
   $req .= "Host: 192.168.2.106\r\n";
   $req .= "Connection: Close\r\n\r\n";
   fputs($http, $req);

   // Output the request results
   while(!feof($http)) {
      $data .= fgets($http, 1024);
   }
   // Close the connection
   fclose($http);
  
  $xml = simplexml_load_string($data);

print_r ($xml);

?> 

This yields the following data:
SimpleXMLElement Object ( [@attributes] => Array ( [id] => S10011 [hb] => 117546 ) [Group] => Array ( => SimpleXMLElement Object ( [@attributes] => Array ( [id] => 1 ) => ) [1] => SimpleXMLElement Object ( [@attributes] => Array ( [id] => 2 ) => ) [2] => SimpleXMLElement Object ( [@attributes] => Array ( [id] => 3 ) => ) [3] => SimpleXMLElement Object ( [@attributes] => Array ( [id] => 4 ) => ) [4] => SimpleXMLElement Object ( [@attributes] => Array ( [id] => 5 ) => ) [5] => SimpleXMLElement Object ( [@attributes] => Array ( [id] => 6 ) => ) [6] => SimpleXMLElement Object ( [@attributes] => Array ( [id] => 7 ) => ) [7] => SimpleXMLElement Object ( [@attributes] => Array ( [id] => 8 ) => ) [8] => SimpleXMLElement Object ( [@attributes] => Array ( [id] => 9 ) [Probe] => Array ( => SimpleXMLElement Object ( [@attributes] => Array ( [id] => 99 ) [Value] => 1.0 ) [1] => SimpleXMLElement Object ( [@attributes] => Array ( [id] => 1 ) [Value] => 84.2 ) [2] => SimpleXMLElement Object ( [@attributes] => Array ( [id] => 2 ) [Value] => 44.1 ) [3] => SimpleXMLElement Object ( [@attributes] => Array ( [id] => 3 ) [Value] => 4.8 ) [4] => SimpleXMLElement Object ( [@attributes] => Array ( [id] => 4 ) [Value] => 1.0 ) ) ) ) )

I would like to display group 9 probe 1 value for example and I cannot get it to work.  Any tips?

so the code is



<?php

$xml1 = "
<outer>
  <xml>
    <more_info>
     <user>
        <id>200</id>
        <name>CLUEL3SS</name>
    </user>
    <user>
        <id>201</id>
        <name>CLUEL3SS2</name>
     </user>
    </more_info>
  </xml>
</outer>    ";

$cwb = simplexml_load_string($xml1);
foreach($cwb->xml->more_info->user as $stats)
  {
   echo $stats->id."\n";}
   
?>




output is

Code: [Select]
200
201

Now, how can I echo the name under <id>201</id> since there is more than one?


echo $stats->id."\n";


That echos both of the "ID" values, now how can I get it to only echo the second id 201 and the second name?

Thanks