}
} else {
$arrayLogin['count_cat'] = "-2";
}
echo json_encode($arrayLogin);
} else {
echo json_encode(array('id' => '-1'));
}
} else {
if (strcmp('get-user-by-id', $_POST['method']) == 0) {
$username = $_POST['data'];
$sql = "SELECT USER.ID,\n\t\t\t\t\t\tUSER.EMAIL,\n\t\t\t\t\t USER.NAME,\n\t\t\t\t\t USER.BIRTH,\n\t\t\t\t\t USER.SEX,\n\t\t\t\t\t USER.PICTURE_PROFILE,\n\t\t\t\t\t USER.SOCIALNET,\n\t\t\t\t\t USER.IS_PRO,\n\t\t\t\t\t USER.DATE_TIME_USER,\n\t\t\t\t\t (PROFESSIONAL.ID)AS ID_PRO,\n\t\t\t\t\t PROFESSIONAL.BANNER,\n\t\t\t\t\t PROFESSIONAL.CITY,\n\t\t\t\t\t PROFESSIONAL.STATE,\n\t\t\t\t\t PROFESSIONAL.ADDR,\n\t\t\t\t\t PROFESSIONAL.DISTRICT,\n\t\t\t\t\t PROFESSIONAL.PHONE1,\n\t\t\t\t\t PROFESSIONAL.PHONE2,\n\t\t\t\t\t PROFESSIONAL.LOCATION,\n\t\t\t\t\t PROFESSIONAL.DATE_TIME_PROF FROM USER LEFT JOIN PROFESSIONAL ON (USER.ID=PROFESSIONAL.ID_USER) WHERE EMAIL='" . $username . "'";
$result = $conn->query($sql);
if ($result->num_rows > 0) {
foreach ($result as $model) {
$arrayUser = getArrayUser($model);
}
echo json_encode($arrayUser);
} else {
echo json_encode(array('id' => 'not_found'));
}
} else {
if (strcmp('get-favorites', $_POST['method']) == 0) {
$idUserLogged = $_POST['data'];
$result = selectFavorites($conn, $idUserLogged);
$arrayAll = array();
if ($result->num_rows > 0) {
foreach ($result as $model) {
$arrayFavorites = getArrayPro($model);
//$sql = "SELECT ROUND(AVG(RATING),1) AS AVG FROM COMMENTARY WHERE ID_PROFESSIONAL=".$model['ID'];
//$resultAvg = $conn->query($sql);
}
}
?>
<!DOCTYPE html>
<!--
To change this license header, choose License Headers in Project Properties.
To change this template file, choose Tools | Templates
and open the template in the editor.
-->
<html>
<head>
<title>Affichage des incrits</title>
<meta charset="UTF-8">
<meta name="viewport" content="width=device-width, initial-scale=1.0">
<link rel="stylesheet" href="style.css">
<script>
</script>
</head>
<body>
<?php
echo getArrayUser();
if (isset($_REQUEST['value'])) {
echo getUser($_REQUEST['value']);
}
echo getFormSport();
?>
<a href="index.php">Formulaire d'inscription</a>
<a href="AffichageNom.php?deconnect=yes">Se déconnecter</a>
</body>
</html>
