} } 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>