</script> <META http-equiv="Page-exit" CONTENT="RevealTrans(Duration=1,Transition=12)"> <!-- <link href="stile.css" rel="stylesheet" type="text/css"> --> <link href="css/aironi.css" rel="stylesheet" type="text/css"> <link href="css/classifica.css" rel="stylesheet" type="text/css"> <meta http-equiv="Content-Type" content="text/html; charset=iso-8859-1"> </head> <body id="bodyClassifica"> <div class="divTitolo"> <p class="DescClasseCategoria">Classifica: <?php echo getClassi($classe); ?> - <?php echo getCategorie($categoria); ?> </p> </div> <div id="ClassificaSinistra" class="Classifica"> <table class='theadClassifica'> <thead> <tr> <td class='headPOS'>POS</td> <td class='headNome'>Nome</td>
$idCategoria = null;
}
$response['code'] = 1;
$response['status'] = $api_response_code[$response['code']]['HTTP Response'];
$response['data'] = getCategorie($idCategoria);
}
// Method d: classi
if (strcasecmp($apiMethod, 'classi') == 0) {
if (isset($_GET['cla'])) {
$idClasse = $_GET['cla'];
} else {
$idClasse = null;
}
$response['code'] = 1;
$response['status'] = $api_response_code[$response['code']]['HTTP Response'];
$response['data'] = getClassi($idClasse);
}
// Method e: un podio per classe / categoria
if (strcasecmp($apiMethod, 'podio') == 0) {
if (isset($_GET['cla'])) {
$idClasse = $_GET['cla'];
} else {
$idClasse = null;
}
if (isset($_GET['cat'])) {
$idCategoria = $_GET['cat'];
} else {
$idCategoria = null;
}
$response['code'] = 1;
$response['status'] = $api_response_code[$response['code']]['HTTP Response'];
<?php
include 'config.php';
include 'funzioni.php';
if (isset($_GET['classe'])) {
$classe = $_GET['classe'];
$nomeClasse = getClassi($classe);
} else {
$classe = $nomeClasse = "";
}
if (isset($_GET['categoria'])) {
$categoria = $_GET['categoria'];
$nomeCategoria = getCategorie($categoria);
} else {
$categoria = $nomeCategoria = "";
}
// Create connection
$conn = new mysqli(AIRO_CONN_SERVERNAME, AIRO_CONN_USERNAME, AIRO_CONN_PASSWORD, AIRO_CONN_DBNAME);
// Check connection
if ($conn->connect_error) {
die("Connection failed: " . $conn->connect_error);
}
$sql = "SELECT A.CATEGORIA, A.PUNTI, A.SPOT + A.SUPERSPOT as SPOT, A.SUPERSPOT as SUPER, concat(A.NOME, ' ' , A.cognome) as ISCRITTI , A.CLASSE, B.NomeFile FROM ISCRITTI A LEFT JOIN IMMAGINI B ON A.TESSERA = B.ID WHERE A.CLASSE= ? AND A.CATEGORIA = ? AND A.PUNTI is not null ORDER BY A.PUNTI DESC, A.SPOT + A.SUPERSPOT DESC LIMIT 3;";
// echo $sql;
$stmt = $conn->prepare($sql);
$stmt->bind_param("ss", $classe, $categoria);
$stmt->execute();
$result = $stmt->get_result();
$numeroarcieri = $result->num_rows;
$anagrafica1 = "";
$punti1 = "";