Untitled

<!DOCTYPE html>
<html>
<head>

</head>
<body>

<?php

require "mysql_con.php";

$str='';
if( isset($_GET['q'])){
$str= ($_GET['q']);
}

$sql="SELECT TU.nome, A.cognome, A.ruolo, A.titolare
                FROM teamutente AS TU JOIN
                    (SELECT NBAPL.idnbaPlayer, NBAPL.cognome, NBAPL.ruolo, PIT.squadra, PIT.titolare
                        FROM playerinteam AS PIT JOIN nbaplayer NBAPL
                            ON PIT.player = NBAPL.idnbaPlayer) AS A
                ON TU.idteamUtente = A.squadra
                WHERE TU.nome='$str' AND A.titolare='1'

        ";

$result = mysqli_query($mysqli,$sql);

echo  "<form action=\"titolari.php\" method=\"POST\">";

while($row = mysqli_fetch_array($result)) {

    echo "
            <input type='checkbox' name='player[]' value='".$row['cognome']."'> ".$row['cognome']." ".$row['ruolo']."".$row['titolare']." <br>

    ";
}
echo "<input type=\"submit\" name=\"submit\">";
echo " </form>";


$checkBox = isset($_POST['player']) ? $_POST['player'] : array();


if(isset($_POST['submit'])){

     for ($i=0; $i<sizeof($checkBox); $i++){


            $findIdPL = "SELECT idnbaPlayer FROM nbaplayer WHERE cognome='$checkBox[$i]'";


           // if ($mysqli->query($findIdPL) === TRUE) {
            $result = $mysqli->query($findIdPL);
            $rowPL = mysqli_fetch_row($result);
            echo " id nba player ";
            print_r($rowPL);


            $findIdT = "SELECT idteamUtente FROM teamutente WHERE nome='$str'";

            //if ($mysqli->query($findIdT) === TRUE) {
            $result = $mysqli->query($findIdT);
            $rowT = mysqli_fetch_row($result);
            echo "id team in cui inserirlo ";
            print_r($rowT);
            echo "  ";


            //$query="INSERT INTO playerinteam VALUES ('" .$rowPL[0] . "','" .$rowT[0] . "', '1')";


           echo $checkBox[$i];

        }

}

?>

</body>

</html>