guichen
/
RangLimier


			
				
					
						
						
							1234567891011121314151617181920212223242526272829303132333435363738394041424344454647484950515253545556575859606162636465666768697071
							<?php
require_once "libs/fnMain.php";
$_SETTINGS = require "libs/_settings.php";

if (isset($_POST["csv"])) {
	// On parse le fichier CSV reçu
	$tempCsvByRow = explode("\n", $_POST["csv"]);
	array_shift($tempCsvByRow); // Enlève la 1ère ligne listant les colonnes
	$csvArray = [];
	foreach ($tempCsvByRow as $row) {
		$csvArray[] = str_getcsv($row, ",");
	}
	
	// On enregistre les data dans la BDD
	// MySQL avec autoImcrement 
	$sql = "INSERT INTO notes_rang(annee, note, classement) VALUES (:annee, :note, :classement)";
	$reqInsertRangLimites = $db->prepare($sql);
	
	foreach ($csvArray as $item) {
		$reqInsertRangLimites->execute([
			"annee" => (int) $item[1],
			"note" => (float) $item[3],
			"classement" => (int) $item[2]
		]);
	}

	// PgSQL sans autoIncrement 
	/*
	$sql = "INSERT INTO notes_rang(id, annee, note, classement) VALUES (:id, :annee, :note, :classement)";
	$reqInsertRangLimites = $db->prepare($sql);
	
 	$initialId = 14701;
	foreach ($csvArray as $item) {
        $initialId ++;
        $reqInsertRangLimites->execute([
        	"id" => $initialId,
            "annee" => (int) $item[1],
            "note" => (float) $item[3],
            "classement" => (int) $item[2]
        ]);
    }
    */
	
	echo "Valeurs enregistrées";
	
} else {
	// Affichage du formulaire d'import
	?>
	<!doctype html>
	<html lang="fr">
	<head>
		<meta charset="UTF-8">
		<meta name="viewport"
		      content="width=device-width, user-scalable=no, initial-scale=1.0, maximum-scale=1.0, minimum-scale=1.0">
		<meta http-equiv="X-UA-Compatible" content="ie=edge">
		<title>IMPORT NOTES et RANGS</title>
		<link rel="stylesheet" href="assets/bootstrap.min.css">
		<link rel="stylesheet" href="assets/divers.css">
	</head>
	<body>
	<h1>RangLimier - Import des notes et rangs associés</h1>
	<p>Importation des données en CSV en DB.</p>
	<form action="_importDataNotes.php" method="post">
		<label for="csv">Ajouter le CSV ici (sous la forme "Session,Year,Rank,Total") </label> <br>
		<textarea name="csv"></textarea> <br>
		
		<button type="submit" class="btn btn-info">Envoyer</button>
	</form>
	</body>
	</html>
<?php }