<?php

include 'database.php';
session_start();

$database = new Database();
$connexion = $database->getConnection();

function getId($connexion){
            $username = $_SESSION['login'];
            $sql = "SELECT id_user from users where username = '$username'";
            $statement = $connexion->prepare($sql);
            $statement->execute();
            $results = $statement->fetchAll(PDO::FETCH_ASSOC);
            foreach ($results as $row) {
                $id = $row['id_user'];
                return $id;
            }
        }

$value = $_POST['toto'];
$id = getId($connexion);

if($value == "vaisseau1"){
    $val = "Aurora";
    $vall = 1;

}
if($value == "vaisseau2"){
    $val = "Spectrus";
    $vall = 2;

}

if($value == "vaisseau3"){
    $val = "Blorps";
    $vall = 3;

}

$sql = "select * from team where id_user='$id' and statu = 'vivant' and id_vaisseau ='$vall'";
$statement = $connexion->prepare($sql);
    $statement->execute();
    $results = $statement->fetchAll(PDO::FETCH_ASSOC);
    foreach($results as $value){
        echo $value['prenom'];
        echo " ";
        echo $value['nom'];
        echo " ";
        echo $value['age'];
        echo "ans ";
        echo $value['metier'];
        echo " ";
        if($vall == 1){
            //echo "Aurora";
        }
        if($vall == 2){
            //echo "Spectrus";
        }
        echo ".";
        
    }
    
?>