Tiny File Manager

Back Back Up Advanced Editor

<?php

// https://www.fusioncharts.com/dev/chart-attributes/realtimestackedcolumn

// https://www.fusioncharts.com/charts/line-area-charts/line-chart-with-multiple-series?framework=php

// https://www.fusioncharts.com/dev/chart-guide/standard-charts/multi-series-charts

// https://www.fusioncharts.com/fusiontime/examples/plotting-multiple-series-on-time-axis?framework=javascript

// sur l'axe des y : les tâches
	// sur l'axe des x : la durée pour la réalisation d'une tâche

// https://www.geeksforgeeks.org/overview-of-burndown-chart-in-agile/
	
	// php diagramme d'avancement d'un projet
	
	// etat d'avancement
	
	// planification de projet
	
	// https://siocours.lycees.nouvelle-aquitaine.pro/doku.php/si7/si7.3
	
	// http://lyc-vaucanson-tours.tice.ac-orleans-tours.fr/php5/Accueil/index.php/gestion-de-projet/927-planifier-un-projet-avec-ganttproject
	
	//https://code.daypilot.org/93862/html5-gantt-chart
	
	// https://github.com/th0liveira/GanttChartPHP
	
	//  php time tracking open source
	
	// https://sourceforge.net/directory/time-tracking/php/
	
	// timeline
	
	// https://hotexamples.com/examples/-/TimeLine/-/php-timeline-class-examples.html
	
	//https://www.techieclues.com/blogs/converting-html-table-to-array-in-php

/*
CREATE TABLE IF NOT EXISTS `graph02` (
  `id` int(11) DEFAULT NULL,
  `jour` varchar(255) NOT NULL,
  `val1` int(11) DEFAULT NULL,
  `val2` int(11) DEFAULT NULL,
  PRIMARY KEY (`jour`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1;
*/

include("database.php");	
	include("fusioncharts.php");

echo "Poisson d'Avril :)";
	echo "<br>";
	echo "<br>";
	echo "<br>";
	echo "<br>";
	echo "<br>";
	
	blabla();
	
	echo "Fin";
	echo "<br>";
	echo "<br>";
	echo "<br>";
	
?>

<html>
   <head>
      <title>FusionCharts | Multi-Series Chart using PHP and MySQL</title>
	  	
	
        <script src="js/js/fusioncharts.js"></script>
        <script src="js/js/fusioncharts.charts.js"></script>
        <script src="js/js/themes/fusioncharts.theme.fint.js"></script>
		
	
   </head>
   <body>
   
<?php

function blabla()
{

/*$dbhandle = new mysqli($hostdb, $userdb, $passdb, $namedb);

if ($dbhandle->connect_error) 
	{
		exit("There was an error with your connection: ".$dbhandle->connect_error);
	}*/

$conn = db_connexion();

$strQuery = "SELECT * FROM aabbcc; ";
	//$result = $dbhandle->query($strQuery) or exit("Error code ({$dbhandle->errno}): {$dbhandle->error}");
	$result = $conn->query($strQuery) or exit("Error code ({$conn->errno}): {$conn->error}");

if ($result)
	{
		// https://www.fusioncharts.com/dev/chart-attributes/scrollline2d

$arrData = array(
        "chart" => array(
        	  "caption"=> "blabla",
            "xAxisname"=> "XXX",
            "yAxisName"=> "YYY",
            "numberPrefix"=> "",
            "plotFillAlpha"=> "80",
        	  "showValues"=> "1",
        	  "placeValuesInside"=> "1",
        	  "usePlotGradientColor"=> "0",
        	  "rotateValues"=> "1",
        	  "valueFontColor"=> "#FFFFFF",
        	  "showHoverEffect"=> "1",
            "rotateValues"=> "1",
			
			"flatScrollBars"=> "1",
			"numVisiblePlot"=> "3",
			
            "showXAxisLine"=> "1",
			"rotateLabels"=> "1",
            "xAxisLineThickness"=> "1",
            "xAxisLineColor"=> "#999999",
            "showAlternateHGridColor"=> "0",
            "legendBgAlpha"=> "0",
            "legendBorderAlpha"=> "0",
            "legendShadow"=> "0",
            "legendItemFontSize"=> "10",
            "legendItemFontColor"=> "#666666",
            "theme"=> "fint"
          	)
         	);

$categoryArray=array();
		$dataseries1=array();
		$dataseries2=array();
        	
		while($row = mysqli_fetch_array($result)) 
		{				
		
			$tmp = "210";
			array_push($categoryArray, array( "label" => $row["plage"])	);

array_push($dataseries1, array(	"value" => $row["valeur"]) );
				
			array_push($dataseries2, array(	"value" => $tmp )	);

}
	
		$arrData["categories"]=array(array("category"=>$categoryArray));
	
		$arrData["dataset"] = array(array("seriesName"=> "Prévision", "data"=>$dataseries1), array("seriesName"=> "Avancement", "data"=>$dataseries2));

$jsonEncodedData = json_encode($arrData);
            			
		// chart object
		//scrollline2d
		//$burndown = new FusionCharts("msline", "chart1" , "100%", "400", "contenu", "json", $jsonEncodedData);
		$burndown = new FusionCharts("scrollline2d", "chart1" , "100%", "800", "contenu", "json", $jsonEncodedData);
		
		
		//scrollline2d
		
		$burndown->render();
		//$dbhandle->close();
		$conn->close();
	}
}
?>   
   
<?php
	
	blabla();

<center>
 
<div id="contenu"> 3 Chart will render here!</div>
 
</center>

</body>
   
</html>