I have a website in Wordpress and I'm consuming a Web Service, I created a function to filter the championships based on some information:
Sex: M
Mode: 2
Category: 4
If all are true, it returns the name of the respective championship and prints on the screen inside a div date-toggle of the bootstrap, the function is correct but I needed that within the content of that date -toggle, it compared two returned values of different urls in JSON:
Home
$ api_results ['championship]
$ api_campeonatos ['code']
If these values were the same, you had to print the results of the respective championship games within div tables , in table format:
Mandante x Visitor , placard and date
I'm trying the following way, but without success, if you can help me, I'll be grateful!
Pull championship values and print names if true:
<?php
$api_campeonatos = 'https://sportsmanager.com.br/api/[email protected]&token=SXLSO8342HSDE78623GVS7234GNMSKL';
$campeonatos = wp_remote_get( $api_campeonatos );
$campeonatos_data = json_decode( wp_remote_retrieve_body( $campeonatos ), true );
$retorno_campeonatos = array(); // <- mudar para array
if($campeonatos_data){
foreach($campeonatos_data as $row){
if(!is_array($row)){
//$retorno = $retorno.'<td>'.$row.'</td>';
}else{
if($row['sexo'] == 'M' && $row['modalidade'] == 2 && $row['categoria'] == 4){
$retorno_campeonatos[] = array('valor' => '<td>'.$row['nome'].'</td>', 'id' => $row['codigo']); // <--- adiciona
}
}
}
}
?>
<script>
$(function(){
var html = '';
var html2 = '';
<?php foreach($retorno_campeonatos as $valor){ ?>
html += '<a class="list-group-item list-group-item-action" data-toggle="list" href="#bloco-<?php echo $valor['id'];?>" role="tab"><?php echo $valor['valor'];?></a>';
html2 += '<div class="tab-pane" id="bloco-<?php echo $valor['id'];?>" role="tabpanel"><div id="tables></div></div>';
<?php } ?>
$('#myList').html(html);
$('#tabList').html(html2);
});
</script>
<div class="container">
<div class="row">
<div id="contents">
<div class="list-group" id="myList" role="tablist">
</div>
<div id="tabList" class="tab-content">
</div>
</div>
</div>
</div>
Pull the results of the championships and print the table:
<?php
$api_resultados = 'https://sportsmanager.com.br/api/[email protected]&token=SXLSO8342HSDE78623GVS7234GNMSKL&ano=2018&status=A';
$resultados = wp_remote_get( $api_resultados );
$resultados_data = json_decode( wp_remote_retrieve_body( $resultados ), true );
$retorno_resultados = array(); // <- mudar para array
if($resultados_data){
foreach($resultados_data as $row => $campeonatos_data){
if(!is_array($row)){
//$retorno = $retorno.'<td>'.$row.'</td>';
}else{
if($row['campeonato'] == $campeonatos_data['codigo']){
$retorno_resultados[] = array('val' => '<td>'.$row['mandante'].'</td>'); // <--- adiciona
}
}
}
}
?>
<script>
$(function(){
var html3 = '';
<?php foreach($retorno_resultados as $val){ ?>
html3 += '<td><?php echo $val['mandante'];?>x<?php echo $val['visitante'];?></td>';
<?php } ?>
$('#tables').html(html3);
});
</script>
Return Championships:
{
"codigo": "17",
"nome": "CIRCUITO ESCOLAR - SÉRIE OURO",
"modalidade": "2",
"categoria": "6",
"sexo": "M",
"data": "2018-08-13 00:00:00",
"atualizacao": null,
"status": "N"
},
{
"codigo": "19",
"nome": "CIRCUITO ESCOLAR - SÉRIE OURO",
"modalidade": "2",
"categoria": "4",
"sexo": "M",
"data": "2018-08-13 00:00:00",
"atualizacao": null,
"status": "N"
},
{
"codigo": "18",
"nome": "CIRCUITO ESCOLAR - SÉRIE PRATA",
"modalidade": "2",
"categoria": "4",
"sexo": "M",
"data": "2018-08-13 00:00:00",
"atualizacao": null,
"status": "N"
},
Return Results
{
"codigo": "32",
"campeonato": "18",
"data": "2018-09-25 00:00:00",
"horario": "18",
"local": "4",
"realizada": "N",
"jogo": "0",
"fase": "2",
"rodada": "0",
"mandante": "7",
"visitante": "3",
"placar1n": null,
"placar2n": null,
"placar1p": null,
"placar2p": null,
"placar1s": null,
"placar2s": null,
"grupo1": "",
"grupo2": "",
"quadra": "4",
"obs": null
},
{
"codigo": "25",
"campeonato": "19",
"data": "2018-08-13 00:00:00",
"horario": "19",
"local": "9",
"realizada": "N",
"jogo": "0",
"fase": "2",
"rodada": "0",
"mandante": "2",
"visitante": "6",
"placar1n": null,
"placar2n": null,
"placar1p": null,
"placar2p": null,
"placar1s": null,
"placar2s": null,
"grupo1": "",
"grupo2": "",
"quadra": "9",
"obs": null
},