profil.php

<?php
$servername = "192.168.100.103";
$username = "group1-1";
$password = "Unistra2023#";
$dbname = "bdd_ludo";


try {
    $pdo = new PDO("mysql:host=$servername;dbname=$dbname", $username, $password);
    // set the PDO error mode to exception
    $pdo->setAttribute(PDO::ATTR_ERRMODE, PDO::ERRMODE_EXCEPTION);
        //echo "Connected successfully";
  }
 catch(PDOException $e) {
    echo "Connection failed: " . $e->getMessage();
 }

   if (isset($_POST['id_joueur'])) {
    $req = "SELECT * FROM Joueur  WHERE id_joueur = ?";
    $res = $pdo->prepare($req);
    $res->execute([$_POST["id_joueur"]]);

    
    if ($row = $res->fetch()) {
        $retVal = array(
           "Pseudo" => $row["pseudo"],
           "nbVictoire" => $row["nbVictoire"],
           "nbMatch" => $row["nbMatch"],
           "activeAvatar" => $row["activeAvatar"],
           "response" => "Success"
        );
    } else {
        $retVal = array(
            "response" => "Echec"
        );
    }
    echo json_encode($retVal);
} else {
    echo json_encode(array("response" => "No Player"));
}

?>