<?php
    // info Connection
    $servername = "";
    $server_username = "";
    $server_password = "";
    $dbName = "";

    // New account
    $name = $_POST["namePost"];
    $password = $_POST["passwordPost"];


    //Make Connection
    $conn = new mysqli($servername, $server_username, $server_password, $dbName);
    //Check Connection
    if(!$conn){
        die("Connection Failed". mysqli_connect_error());
    }

    $query = $conn->query("SELECT * FROM player WHERE name='$name'");
    $rows = $query->rowCount();

    if($rows == 1){
        echo "Pseudo deja utilise";
    }else{
        $sql = "INSERT INTO player (name, password)
                VALUES ('".$name."','".$password."')";
        $result = mysqli_query($conn ,$sql);
        echo "Compte creer";
    }

?>