<?php
include_once 'connect.php';
if (isset($_GET["table"])) {
$table = $_GET['table'];
}
switch ($_GET["table"]) {
case "scores":
selectScores($_GET);
break;
case "personnes":
selectPersonnes($_GET);
break;
case "documents":
selectDocuments($_GET);
break;
default:
break;
}
//selection scores
function selectScores($data)
{
global $conn;
$sql = "SELECT * FROM scores WHERE id_perso ='" . $data["id_perso"] . "' ";
$result = $conn->query($sql);
if ($result->num_rows > 0) {
// output data of each row
while ($row = $result->fetch_assoc()) {
echo "<br> id: " . $row["id"] . " distance: " . $row["distance"] . " id_doc" . $row["id_doc"] . "<br>";
}
} else {
switch ($_GET["table"]) {
case "score":
selectScore($_GET);
break;
case "scores":
// get score of a member
selectScores($_GET);
break;
case "personne":
selectPersonne($_GET);
break;
case "allscores":
selectAllScores();
break;
case "personnes":
selectPersonnes();
break;
case "document":
selectDocuments();
break;
case "connect":
connect($_GET);
break;
case "personnesw2ui":
selectPersonnesForW2UIGrid();
break;
case "documentsw2ui":
selectDocumentsForW2UIGrid();
break;
case "scoresw2ui":
selectScoresForW2UIGrid();
