File "yyy.php"

Full Path: /home/analogde/www/Freebox/CHESS_ON/yyy.php
File size: 3.4 KB
MIME-type: text/x-php
Charset: utf-8

 
Open Edit   Advanced Editor   Back 
<?php

	session_start();
	include('database.php');
	DB_connexion(); 
	
	$_SESSION['chessmaster'] = "chessmaster_new";	
	$_SESSION['classement'] = "classement_new";
	$_SESSION['parties'] = "parties_new";
	$_SESSION['evolution'] = "evolution_new";

	$_SESSION['membres'] = "membres";
	$_SESSION['elo_affectation'] = "elo_affectation";

	$sql = "select * from " .$_SESSION['classement'] ." ORDER by elo desc ";
	//echo $sql;
			
	$results = mysql_query($sql);
	$number = mysql_num_rows($results);
			
	//echo $number;
			
	$indice = 0;

	while($row = mysql_fetch_assoc($results))
	{
		$joueur = $row["joueur"]; 
		$elo = $row["elo"];
		$parties = $row["parties"];

		if($elo > 900 && $parties >= 20)
		{
			$arrData[$indice]["label"] = $joueur;
			$arrData[$indice]["value"] = $elo;
			$indice = $indice + 1;
		}
	}	

			//echo "<pre>";
			//print_r($arrData);
			//echo "</pre>";
			
	//$data_json = json_encode($arrData);
			
			//echo $data_json;
			
?>



<html>
<head>
<title>ELO classement</title>
<!-- Include fusioncharts core library -->
<!--<script type="text/javascript" src="https://cdn.fusioncharts.com/fusioncharts/latest/fusioncharts.js"></script>-->
<!-- Include fusion theme -->
<!--<script type="text/javascript" src="https://cdn.fusioncharts.com/fusioncharts/latest/themes/fusioncharts.theme.fusion.js"></script>-->

<script src="Charts_2022/js/fusioncharts.js"></script>

<script src="Charts_2022/js/themes/fusioncharts.theme.fusion.js"></script>

<script type="text/javascript">

//https://www.fusioncharts.com/dev/getting-started/plain-javascript/your-first-chart-using-plain-javascript

    //STEP 2 - Chart Data
	
	//const data = "<?php echo $data_json; ?>";

	//  var javaScriptVar = "<?php echo $someVar; ?>";
	
//	var javaScriptVar = "<?php echo json_encode($arrData); ?>";
	
	
 //var javaScriptVar = JSON.parse("<?php echo $data_json; ?>");
	
//var plouf = JSON.parse(data);

	var import_data = <?php echo json_encode($arrData); ?>;

alert("azzeesds");
	
    const chartData = [{
        "label": "Venezuela",
        "value": "290"
    }, {
        "label": "Saudi",
        "value": "260"
    }, {
        "label": "Canada",
        "value": "180"
    }, {
        "label": "Iran",
        "value": "140"
    }, {
        "label": "Russia",
        "value": "115"
    }, {
        "label": "UAE",
        "value": "100"
    }, {
        "label": "US",
        "value": "30"
    }, {
        "label": "China",
        "value": "30"
    }];

    //STEP 3 - Chart Configurations
    const chartConfig = {
    type: 'column3d',
    renderAt: 'chart-container',
    width: '60%',
    height: '400',
    dataFormat: 'json',
    dataSource: {
        // Chart Configuration
        "chart": {
            "caption": "Classement ELO",
            "subCaption": "Onsemi Toulouse",
            "xAxisName": "Joueurs",
            "yAxisName": "ELO",
			"formatNumberScale": "0",
			"yAxisMaxValue": "1800",
			"yAxisMinValue": "900",
            //"numberSuffix": "K",
            "theme": "fusion",
            },
        // Chart Data
        "data": import_data //chartData
        }
    };
    FusionCharts.ready(function(){
    var fusioncharts = new FusionCharts(chartConfig);
    fusioncharts.render();
    });

</script>
</head>
<body>
<div id="chart-container">FusionCharts XT will load here!</div>
</body>
</html>