You can not select more than 25 topics
Topics must start with a letter or number, can include dashes ('-') and can be up to 35 characters long.
92 lines
2.8 KiB
92 lines
2.8 KiB
<?php
|
|
session_start();
|
|
require_once('../../BDD/SqliteDb.php');
|
|
|
|
$db = new SqliteDb('save');
|
|
|
|
|
|
$question = str_replace("textbox","", $_GET['id']);
|
|
$tab = explode('-', $question);
|
|
|
|
$numQcm = $tab[0];
|
|
$numQuestion = $tab[1];
|
|
$numReponse = $tab[2];
|
|
|
|
//$user = "mehdi";
|
|
$user = $_SERVER['REMOTE_USER'];
|
|
|
|
|
|
if($_GET['type'] == 'vraifaux'){
|
|
if($_GET['check'] == 'true'){
|
|
$query = $db->prepare('INSERT OR REPLACE INTO QcmSauvegarde VALUES (?,?,?,?)');
|
|
$query->bindParam(1, $user);
|
|
$query->bindParam(2,$numQcm);
|
|
$query->bindParam(3,$numQuestion);
|
|
$query->bindParam(4,$numReponse);
|
|
$result = $query->execute();
|
|
echo "d";
|
|
}
|
|
else {
|
|
$query = $db->prepare('DELETE FROM QcmSauvegarde WHERE numQcm=? AND numQuestion=? AND numReponse = ? AND idEtudiant=?');
|
|
$query->bindParam(1,$numQcm);
|
|
$query->bindParam(2,$numQuestion);
|
|
$query->bindParam(3,$numReponse);
|
|
$query->bindParam(4, $user);
|
|
$result = $query->execute();
|
|
echo "e";
|
|
}
|
|
}
|
|
else {
|
|
//Sauvegarde des notes//
|
|
$query = $db->prepare('SELECT points FROM QcmReponse WHERE numQuestion=? AND numQcm= ? AND numReponse= ?');
|
|
$query->bindParam(1, $numQuestion);
|
|
$query->bindParam(2, $numQcm);
|
|
$query->bindParam(3,$numReponse);
|
|
$result = $query->execute();
|
|
$pointRow = $result->fetchArray();
|
|
|
|
$query = $db->prepare('INSERT OR REPLACE INTO NotesParQuestion VALUES (?,?,?,?)');
|
|
$query->bindParam(1,$user);
|
|
$query->bindParam(2,$numQcm);
|
|
$query->bindParam(3,$numQuestion);
|
|
$query->bindParam(4,$pointRow['points']);
|
|
$result = $query->execute();
|
|
|
|
$query = $db->prepare('SELECT note FROM NotesParQuestion WHERE numQcm= ? AND idEtudiant = ?');
|
|
$query->bindParam(1, $numQcm);
|
|
$query->bindParam(2, $user);
|
|
$result = $query->execute();
|
|
|
|
$note = 0;
|
|
while($r = $result->fetchArray()){
|
|
$note += $r['note'];
|
|
}
|
|
|
|
$query = $db->prepare('INSERT OR REPLACE INTO Notes VALUES (?,?,?)');
|
|
$query->bindParam(1,$user );
|
|
$query->bindParam(2,$numQcm);
|
|
$query->bindParam(3,$note );
|
|
$result = $query->execute();
|
|
|
|
|
|
|
|
//Sauvegarde des REPONSES//
|
|
$query = $db->prepare('DELETE FROM QcmSauvegarde WHERE numQcm= ? AND numQuestion = ? AND idEtudiant=?');
|
|
$query->bindParam(1,$numQcm);
|
|
$query->bindParam(2,$numQuestion);
|
|
$query->bindParam(3, $user);
|
|
$result = $query->execute();
|
|
|
|
$query = $db->prepare('INSERT OR REPLACE INTO QcmSauvegarde VALUES (?,?,?,?)');
|
|
$query->bindParam(1, $user);
|
|
$query->bindParam(2,$numQcm);
|
|
$query->bindParam(3,$numQuestion);
|
|
$query->bindParam(4,$numReponse);
|
|
$result = $query->execute();
|
|
|
|
//$db->ecrireFichierNotes($numQcm,'save');
|
|
|
|
|
|
}
|
|
|