ID |
Resultat |
ELO |
Couleur |
Adversaire |
Date |
";
$graph_data = array();
$result = mysql_query($sql);
$retid = mysql_query($sql);
$id = 1;
while ($row = mysql_fetch_array($retid))
{
$white = $row["w_playerID"];
$w_name=$row["w_name"];
$black = $row["b_playerID"];
$b_name=$row["b_name"];
$w_rating = $row["w_arating"];
$b_rating = $row["b_arating"];
$w_brating = $row["w_brating"];
$b_brating = $row["b_brating"];
$result=$row["result"];
//$date =$row["date"];
//$date=date("d F Y",$date);
//$date_convert = strftime('%d-%m-%Y',strtotime($date));
$date = $row["date"];
$date= date("d F Y",$date);
$date_convert = strftime('%d-%h-%Y',strtotime($date));
$diff_w = $w_rating - $w_brating;
$diff_b = $b_rating - $b_brating;
if($white==$playerID)
{
if ($result==1)
{
echo "
| ".$id." " ."W1" ." |
 |
".$w_rating. " (" .$w_brating ." " .$diff_w ." ) |
White |
".$b_name." ".$b_rating ." (" .$b_brating ." " .$diff_b .") Black  |
".$date_convert." |
";
$pipo =array( $date_convert , $w_rating);
}
if($result==2)
{
echo "
| ".$id." " ."W2" ." |
 |
".$w_rating. " (" .$w_brating ." " .$diff_w ." ) |
White |
".$b_name." ".$b_rating ." (" .$b_brating ." " .$diff_b .") Black |
".$date_convert." |
";
$pipo =array( $date_convert , $w_rating);
}
if ($result==3)
{
if($diff_w < 0)
{
$s1 = "".$w_rating. " (" .$w_brating ." " .$diff_w .") | ";
$s2 = "".$b_name." ".$b_rating ." (" .$b_brating ." " .$diff_b .") Black | ";
}
else
{
$s1 = "".$w_rating. " (" .$w_brating ." " .$diff_w .") | ";
$s2 = "".$b_name." ".$b_rating ." (" .$b_brating ." " .$diff_b .") Black | ";
}
$pipo =array( $date_convert , $w_rating);
echo "
| ".$id." |
 | ";
echo $s1;
echo " White | ";
echo $s2;
echo " ".$date." |
";
}
}
if ($black==$playerID)
{
if($result==1)
{
echo "
| ".$id ." " ."B1" ." |
|
".$b_rating. " (" .$b_brating ." " .$diff_b .") |
Black |
".$w_name." ".$w_rating ." (" .$w_brating ." " .$diff_w .") White |
".$date_convert." |
";
$pipo =array( $date_convert , $b_rating);
}
if ($result==2)
{
echo "
| ".$id ." " ."B2" ." |
|
".$b_rating. " (" .$b_brating ." " .$diff_b.") |
Black |
".$w_name." ".$w_rating ." (" .$w_brating ." " .$diff_w .") White |
".$date_convert." |
";
$pipo =array( $date_convert , $b_rating);
}
if ($result==3)
{
if($diff_b < 0)
{
$s1 = "".$b_rating. " (" .$b_brating ." " .$diff_b .") | ";
$s2 = "".$w_name." ".$w_rating ." (" .$w_brating ." " .$diff_w .") Black | ";
}
else
{
$s1 = "".$b_rating. " (" .$b_brating ." " .$diff_b .") | ";
$s2 = "".$w_name." ".$w_rating ." (" .$w_brating ." " .$diff_w .") Black | ";
}
$pipo =array( $date_convert , $b_rating);
echo "
| ".$id." |
| ";
echo $s1;
echo " Black | ";
echo $s2;
echo " ".$date." |
";
}
}
$graph_data[] = $pipo;
$id = $id + 1;
}
?>
";
print_r($graph_data);
echo "";
echo json_encode($graph_data);
$json = json_encode($graph_data);
file_put_contents("test_data.json", $json)
?>