if($conn) {
            $sql_sel = "SELECT id_adopteur,etat_demande,explication
            FROM adopteur
            WHERE mail_adop = '{$email}' AND mot_pass_adop = '{$pass}'";
            $data = mysqli_fetch_assoc(mysqli_query($conn,$sql_sel));
            if($data["etat_demande"] == "acceptee") {
                $id_adopteur = mysqli_real_escape_string($conn, $data["id_adopteur"]);
                echo $id_adopteur;
                $d = 1;
                $sql_rv = "SELECT id_adopteur,id_rendez_v, date_r,heure
                FROM rendez_vous
                WHERE id_adopteur = '{$id_adopteur}'";
                $query_rdv = mysqli_query($conn,$sql_rv);
                if($query_rdv) {
                    echo mysqli_num_rows($query_rdv);
                }



            }
        }