extraer info con Xquery para un XML

Victoria222 · #1 (**permalink**) 19/05/2015, 09:32

Primero de todo perdon por si este tema no va aqui, pero creo que es lo que mas se parece

Tengo un xml en la siguiente direccion:
http://www.resultados-futbol.com/scripts/api/api.php?tz=Europe/Madrid&format=xml&req=get_teams&key=0bbe700a8b3bcf 94832e2cd9556b8c5e&filter=espana

que me devuelve los equipos de la liga.

Alguien me podria ayudar con el xquery para extraer id, nameShow i competition-name cuando competition_name es liga_bbva

estoy probando con esto http://try.zorba.io/queries/xquery

Cita:

declare variable $doc := doc("http://www.resultados-futbol.com/scripts/api/api.php?tz=Europe/Madrid&format=xml&req=get_teams&key=0b be700a8b3bcf94832e2cd9556b8c5e&filter=espana") ;
[

for $t in $doc/get_teams/teams
where $t//competition_name="Liga BBVA"
return $t
(:return <teams name="{$t/@nameShow}"> </teams> :)

]
]

gracias

germangutierrez · #2 (**permalink**) 20/05/2015, 22:20

Aca un ejemplo usando xpath, tiene un hack feo para limpiar el salto de linea porque no me andaba el query de una

Código PHP:

Ver original<?php
/*
$xmlstr = "http://www.resultados-futbol.com/scripts/api/api.php?tz=Europe/Madrid&format=xml&req=get_teams&key=0bbe700a8b3bcf94832e2cd9556b8c5e&filter=espana";
 
$curl = curl_init();
curl_setopt_array($curl, array(
    CURLOPT_RETURNTRANSFER => 1,
    CURLOPT_URL => $xmlstr,
    CURLOPT_USERAGENT => 'Api client'
));
$resp = curl_exec($curl);
curl_close($curl);
print_r($resp);*/
 
$resp = <<< EOL
<?xml version="1.0" encoding="UTF-8"?>
<get_teams>
    <teams>
        <id>
2107</id>
        <nameShow>
Real Madrid</nameShow>
        <basealias>
real-madrid</basealias>
        <competition_name>
Liga BBVA</competition_name>
        <team_shield>
http://thumb.resfu.com/img_data/escudos/medium/2107.jpg?size=36x&amp;amp;ext=png&amp;amp;lossy=1&amp;amp;1</team_shield>
    </teams>
    <teams>
        <id>
429</id>
        <nameShow>
Barcelona</nameShow>
        <basealias>
barcelona</basealias>
        <competition_name>
Liga BBVA</competition_name>
        <team_shield>
http://thumb.resfu.com/img_data/escudos/medium/429.jpg?size=36x&amp;amp;ext=png&amp;amp;lossy=1&amp;amp;1</team_shield>
    </teams>
    <teams>
        <id>
369</id>
        <nameShow>
Atlético</nameShow>
        <basealias>
atletico-madrid</basealias>
        <competition_name>
Liga BBVA</competition_name>
        <team_shield>
http://thumb.resfu.com/img_data/escudos/medium/369.jpg?size=36x&amp;amp;ext=png&amp;amp;lossy=1&amp;amp;1</team_shield>
    </teams>
    <teams>
        <id>
1102</id>
        <nameShow>
Sevilla</nameShow>
        <basealias>
sevilla</basealias>
        <competition_name>
Liga BBVA</competition_name>
        <team_shield>
http://thumb.resfu.com/img_data/escudos/medium/1102.jpg?size=36x&amp;amp;ext=png&amp;amp;lossy=1&amp;amp;1</team_shield>
    </teams>
    <teams>
        <id>
1102</id>
        <nameShow>
Sevilla</nameShow>
        <basealias>
sevilla</basealias>
        <competition_name>
Supercopa Euroamericana</competition_name>
        <team_shield>
http://thumb.resfu.com/img_data/escudos/medium/1102.jpg?size=36x&amp;amp;ext=png&amp;amp;lossy=1&amp;amp;1</team_shield>
    </teams>
    <teams>
        <id>
2647</id>
        <nameShow>
Valencia</nameShow>
        <basealias>
valencia-cf</basealias>
        <competition_name>
Liga BBVA</competition_name>
        <team_shield>
http://thumb.resfu.com/img_data/escudos/medium/2647.jpg?size=36x&amp;amp;ext=png&amp;amp;lossy=1&amp;amp;1</team_shield>
    </teams>
    <teams>
        <id>
347</id>
        <nameShow>
Athletic</nameShow>
        <basealias>
athletic-bilbao</basealias>
        <competition_name>
Liga BBVA</competition_name>
        <team_shield>
http://thumb.resfu.com/img_data/escudos/medium/347.jpg?size=36x&amp;amp;ext=png&amp;amp;lossy=1&amp;amp;1</team_shield>
    </teams>
    <teams>
        <id>
2120</id>
        <nameShow>
R. Sociedad</nameShow>
        <basealias>
real-sociedad</basealias>
        <competition_name>
Liga BBVA</competition_name>
        <team_shield>
http://thumb.resfu.com/img_data/escudos/medium/2120.jpg?size=36x&amp;amp;ext=png&amp;amp;lossy=1&amp;amp;1</team_shield>
    </teams>
    <teams>
        <id>
2716</id>
        <nameShow>
Villarreal</nameShow>
        <basealias>
villarreal</basealias>
        <competition_name>
Liga BBVA</competition_name>
        <team_shield>
http://thumb.resfu.com/img_data/escudos/medium/2716.jpg?size=36x&amp;amp;ext=png&amp;amp;lossy=1&amp;amp;1</team_shield>
    </teams>
    <teams>
        <id>
1617</id>
        <nameShow>
Málaga</nameShow>
        <basealias>
malaga</basealias>
        <competition_name>
Liga BBVA</competition_name>
        <team_shield>
http://thumb.resfu.com/img_data/escudos/medium/1617.jpg?size=36x&amp;amp;ext=png&amp;amp;lossy=1&amp;amp;1</team_shield>
    </teams>
    <teams>
        <id>
140</id>
        <nameShow>
Albacete</nameShow>
        <basealias>
albacete</basealias>
        <competition_name>
Segunda División</competition_name>
        <team_shield>
http://thumb.resfu.com/img_data/escudos/medium/140.jpg?size=36x&amp;amp;ext=png&amp;amp;lossy=1&amp;amp;1</team_shield>
    </teams>
    <teams>
        <id>
831</id>
        <nameShow>
Córdoba</nameShow>
        <basealias>
cordoba</basealias>
        <competition_name>
Liga BBVA</competition_name>
        <team_shield>
http://thumb.resfu.com/img_data/escudos/medium/831.jpg?size=36x&amp;amp;ext=png&amp;amp;lossy=1&amp;amp;1</team_shield>
    </teams>
    <teams>
        <id>
2563</id>
        <nameShow>
Las Palmas</nameShow>
        <basealias>
ud-palmas</basealias>
        <competition_name>
Segunda División</competition_name>
        <team_shield>
http://thumb.resfu.com/img_data/escudos/medium/2563.jpg?size=36x&amp;amp;ext=png&amp;amp;lossy=1&amp;amp;1</team_shield>
    </teams>
    <teams>
        <id>
2115</id>
        <nameShow>
Real Oviedo</nameShow>
        <basealias>
real-oviedo</basealias>
        <competition_name>
Segunda División B</competition_name>
        <team_shield>
http://thumb.resfu.com/img_data/escudos/medium/2115.jpg?size=36x&amp;amp;ext=png&amp;amp;lossy=1&amp;amp;1</team_shield>
    </teams>
    <teams>
        <id>
1547</id>
        <nameShow>
Levante</nameShow>
        <basealias>
levante</basealias>
        <competition_name>
Liga BBVA</competition_name>
        <team_shield>
http://thumb.resfu.com/img_data/escudos/medium/1547.jpg?size=36x&amp;amp;ext=png&amp;amp;lossy=1&amp;amp;1</team_shield>
    </teams>
    <teams>
        <id>
486</id>
        <nameShow>
Real Betis</nameShow>
        <basealias>
betis</basealias>
        <competition_name>
Segunda División</competition_name>
        <team_shield>
http://thumb.resfu.com/img_data/escudos/medium/486.jpg?size=36x&amp;amp;ext=png&amp;amp;lossy=1&amp;amp;1</team_shield>
    </teams>
    <teams>
        <id>
712</id>
        <nameShow>
Celta</nameShow>
        <basealias>
celta</basealias>
        <competition_name>
Liga BBVA</competition_name>
        <team_shield>
http://thumb.resfu.com/img_data/escudos/medium/712.jpg?size=36x&amp;amp;ext=png&amp;amp;lossy=1&amp;amp;1</team_shield>
    </teams>
    <teams>
        <id>
2113</id>
        <nameShow>
Real Murcia</nameShow>
        <basealias>
real-murcia</basealias>
        <competition_name>
Segunda División B</competition_name>
        <team_shield>
http://thumb.resfu.com/img_data/escudos/medium/2113.jpg?size=36x&amp;amp;ext=png&amp;amp;lossy=1&amp;amp;1</team_shield>
    </teams>
    <teams>
        <id>
901</id>
        <nameShow>
Deportivo</nameShow>
        <basealias>
deportivo</basealias>
        <competition_name>
Liga BBVA</competition_name>
        <team_shield>
http://thumb.resfu.com/img_data/escudos/medium/901.jpg?size=36x&amp;amp;ext=png&amp;amp;lossy=1&amp;amp;1</team_shield>
    </teams>
    <teams>
        <id>
4235</id>
        <nameShow>
Granada</nameShow>
        <basealias>
granada</basealias>
        <competition_name>
Liga BBVA</competition_name>
        <team_shield>
http://thumb.resfu.com/img_data/escudos/medium/4235.jpg?size=36x&amp;amp;ext=png&amp;amp;lossy=1&amp;amp;1</team_shield>
    </teams>
</get_teams>
EOL;
$equipos = new SimpleXMLElement(join("",explode("\n",$resp)));
 
foreach ($equipos->xpath("/get_teams/teams[competition_name='Liga BBVA']") as $equipo) {
    echo $equipo->nameShow . ' tiene id ' . $equipo->id, PHP_EOL;
}