escape_string($_GET["Email"]);
$sql = "SELECT utenti.Email, utenti.Tipo, partner.Attivo, partner.Lat, partner.Lon";
$sql .= " FROM utenti, partner";
$sql .= " WHERE Email = '".$mail."'";
$sql .= " AND utenti.Email = partner.Email ";
$result = $mysqli->query($sql);
if ($mysqli->errno)
{
print json_encode("Error");
echo "
".$mysqli->error;
exit;
}
else
{
if ($result->num_rows == 0)
{
print json_encode("Not exist");
exit;
}
$row = $result->fetch_row();
if($row[1] != "SPO" || $row[1] != "PAR")
{
print json_encode("Not a partner");
exit;
}
if($row[2] == 0)
{
print json_encode("Not active");
exit;
}
print json_encode($row[3].",".$row[4])
}
}
catch (Exception $e)
{
print json_encode("Failed");
echo '
Caught exception: '.$e->getMessage()."\n";
}
?>