1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31 32 33 34 35 36 37 38 39 40 41 42 43 44 45 46 47 48 49 50 51
|
<?php
/*Connect base*/
$db = mysql_connect('localhost', 'root', '') or die('erreur'.mysql_error());
mysql_select_db('esd',$db);
for ($Tab_Id=0; $Tab_Id < 4; $Tab_Id++)
{
/*E = injured player*/
$team = array (
0 => "A",
1 => "B",
2 => "C",
3 => "D",
4 => "E",
);
$Table_Id = $team [$Tab_Id];
for ($Player_Id=0; $Player_Id < 5; $Player_Id++)
{
$query = ("SELECT name, surname FROM joueur Where joueur.team = '{$Table_Id}' AND joueur.numberTabPlayer = '{$Player_Id}' ");
$result = mysql_query($query) or die(mysql_error());
$res = mysql_num_rows($result);
while($row = mysql_fetch_array($result))
{
$res= $row['name']." - ".$row['surname'];
$obj = array();
$obj [$Tab_Id] = array();
$obj [$Tab_Id] [$Player_Id] = $res;
}
}
}
echo json_encode($obj);
mysql_close();
?> |