PHP - Xpath Elements And Attributes

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

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 -

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:

        <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>

good evening dear php-freaks, 

hope you are all right. 

i am currently working on a parser that gets  data via OSM Overpass API with PHP-SimpleXML. I am workin with the pretty new to the work with PHPSimpleXML so do not bear with me for askin newby questions.  I am tryin to get data using Open Street Maps. I want to write a code that works with the endpoint of openstreetmap - and the given data is the starting point for further explorations.

My tactic is as follows:

 
I fetch data from the openstreetmap-endpoint 

1. i run requests to the openstreetmap-endpoint- (see below) and i try three different APIs per request isn't that easy on ressources and 

2. I don't know how to work with the results that i gather from the OpenStreetmap-Endpoint

as of the first point:  - workin on the endpoint of  OSM-Overpass-API.... see my approach: 

<?php
/**
 * OSM Overpass API with PHP SimpleXML / XPath
 *
 * PHP Version: 5.4 - Can be back-ported to 5.3 by using 5.3 Array-Syntax (not PHP 5.4's square brackets)
 */
//
// 1.) Query an OSM Overpass API Endpoint
//

$query = 'node
  ["amenity"~".*"]
  (38.415938460513274,16.06338500976562,39.52205163048525,17.51220703125);
out;';

$context = stream_context_create(['http' => [
    'method'  => 'POST',
    'header' => ['Content-Type: application/x-www-form-urlencoded'],
    'content' => 'data=' . urlencode($query),
]]);

# please do not stress this service, this example is for demonstration purposes only.
$endpoint = 'http://overpass-api.de/api/interpreter';
libxml_set_streams_context($context);
$start = microtime(true);

$result = simplexml_load_file($endpoint);
printf("Query returned %2\$d node(s) and took %1\$.5f seconds.\n\n", microtime(true) - $start, count($result->node));

//
// 2.) Work with the XML Result
//

so far so good:  with this i get a bunch of data..... 

I have data in a file retrieved from a API pull request at the openstreetmap data source that looks something like this:

<?xml version="1.0" encoding="UTF-8"?>
<osm version="0.6" generator="Osmosis SNAPSHOT-r26564" xapi:planetDate="2014-10-07T15:42:02Z" xmlns:xapi="http://jxapi.openstreetmap.org/">
   <node id="251652819" version="6" timestamp="2013-10-19T14:03:10Z" uid="1198089" user="GeorgeKaplan" changeset="18434238" lat="48.8527413" lon="2.3333559">
     <tag k="dispensing" v="yes"/>
     <tag k="website" v="http://www.pharmacie-paris-citypharma.fr/"/>
     <tag k="name" v="Pharmacie Citypharma in downtown paris"/>
     <tag k="amenity" v="pharmacy"/>
  </node>
  <node id="251774849" version="9" timestamp="2014-07-28T21:28:26Z" uid="92075" user="Art Penteur" changeset="24411346" lat="48.8468043" lon="2.3696423">
     <tag k="phone" v="0143430996"/>
     <tag k="dispensing" v="yes"/>
     <tag k="name" v="Pharmacie de la Rapée in downtown paris"/>
     <tag k="amenity" v="pharmacy"/>
     <tag k="opening_hours" v="Mo-Fr 08:30-20:30; Sa 09:00-19:30"/>
 </node>
 <node id="263262912" version="3" timestamp="2014-07-28T21:37:24Z" uid="92075" user="Art Penteur" changeset="24411346" lat="48.8446917" lon="2.3101829">
     <tag k="dispensing" v="yes"/>
     <tag k="amenity" v="pharmacy"/>
 </node>

and so forth and so forth ....etc.

what is aimed: I am trying to filter the records based on the attributes that i find in the dataset,
 basically i am trying to retrieve the records that do not have a

    <tag k="name" v="blahblahblah"/> field.

I have been looking around and the classical way to do it its easy, however because of my poor skills in doing anything 
xml related i do have a couple of questions:

Is it possible to apply xml filtering for tags that look like this

<tag k="dispensing" v="yes"/> 

ones that do not have the

 <tag></tag>

.....format. Also how can i filter the records when each child of the node has different attributes,like v, 
i would knew how to do it if it would look like this

  <tag k="name">Pharmacie in Paris-downtown -  Rapée-metro-station</tag> 

but within this format received at this moment i cannot  not see a way out on how to get the children that i need

i have had a quick look at the PHP-SimpleXML and the XPath-approach: it may help me in achieving what is aimed.

but at the moment - i think i got stuck. 

i greatly appreciated hints and some ideas that may fit her. 

have a great day. -  yours dil_bert
 

hello dear community, good day,

I've been having an issue trying to parse text in a span cass with DOM. Here is my code example. try to extract some lines out of a webpage - with following technique: with the Extraction of values of attributes of elements with DOMDocument. Here is what i have gathered and learned:

$remote = "http://website.com/"; $doc = new DOMDocument(); @$doc->loadHTMLFile($remote); $xpath = new DOMXpath($doc); $node = $xpath->query('//span[@class="user"]'); echo $node;

and this returns the following

error -> "Catchable fatal error: Object of class DOMNodeList could not be converted to string". 

And now - with this i need help.

What I am trying to do is parse the user name between this tag;

<div class="widget plugin-meta"> <h3 class="screen-reader-text">Meta</h3>

see more below:Here the concrete example view-source: https://wordpress.org/plugins/participants-database/ and https://wordpress.org/plugins/participants-database/

goal  i need the following data:

Version: Last updated: Active installations: Tested up:

view-source: https://wordpress.org/plugins/participants-database/

Proceedings; i checked the source of the webpage. i tried to find out whether the texte is related to some kind of pattern.i have looked closely and found that all of them have

class=”widget plugin-meta”

. Well - This will make extracting them, a piece of cake. I tried with the code below helps to filter html elements based on values of attributes.

but unfortunatley this ends up in a bad result; i need a helping hand and need to know how to parse the above mentioned data

Again; the goal: i need the following data:

Version:

Last updated:

Active installations:

Tested up:

Any idea for the starting-point!?  I love to hear from you.

Context.

Class AbstractTenantEntity's purpose is to restrict access to data to the tenant (i.e. account, owner, etc) that owns the data.  Any entity which extends it will have the TenantId added when created and the TenantId in the WHERE clause for all other requests.

Tenant typically does not have collections of the various entities which extend AbstractTenantEntity, but does for a few of them do.  When using annotation, I handled it by applying Doctrine's AssociationOverride annotation to the extended classes which should have a collection in Tenant.

use Doctrine\ORM\Mapping as ORM;

/**
 * @ORM\Entity()
 */
class Tenant
{
    /**
     * @ORM\OneToMany(targetEntity=Asset::class, mappedBy="tenant")
     */
    private $assets;

    // Other properties and typical getters and setters
}

use Doctrine\ORM\Mapping as ORM;

abstract class AbstractTenantEntity implements TenantInterface
{
    /**
     * inversedBy performed in child where required
     * @ORM\ManyToOne(targetEntity=Tenant::class)
     * @ORM\JoinColumn(nullable=false)
     */
    protected ?Tenant $tenant = null;

    // Typical getters and setters
}

use Doctrine\ORM\Mapping as ORM;

/**
 * @ORM\Entity()
 * @ORM\AssociationOverrides({
 *     @ORM\AssociationOverride(name="tenant", inversedBy="assets")
 * })
 */
class Asset extends PublicIdTenantEntity
{
    // Various properties and typical getters and setters
}

So, now I am changing from annotations to attributes, and modified AbstractTenantEntity as follows:

use Doctrine\ORM\Mapping\ManyToOne;
use Doctrine\ORM\Mapping\JoinColumn;

abstract class AbstractTenantEntity implements TenantInterface
{
    /**
     * inversedBy performed in child where required
     */
    #[ManyToOne(targetEntity: Tenant::class)]
    #[JoinColumn(nullable: false)]
    protected ?Tenant $tenant = null;

    // Typical getters and setters
}

Next I went to modify Asset and realized that there didn't appear to be an attribute for AssociationOverride.  I found a little discussion on the topic on github but couldn't find any resolution.

Question

Can inheritance be used with PHP 8 attributes where the property is defined in the parent class and the attribute is applied in the child class?  Googling php 8 attributes inheritance didn't provide anything and thus I expect the answer is no but thought I'd ask.

Thanks

EDIT.  Maybe Doctrine does have an attribute version: https://github.com/doctrine/orm/blob/2.9.x/lib/Doctrine/ORM/Mapping/AttributeOverride.php

EDIT2.  Actually don't think so